When you create a table you must specify a data type for each field. Please describe each of these data types: Date & Time, Number, AutoNumber, Yes/No.

What will be an ideal response?


- Use the Date & Time data type for dates and times. This special data type makes it much easier, for example, to determine if one date occurs before or after another date.
- Use the Number data type for fields that contain numeric data. Don't use the Number data type for data consisting of numerals that will not be used in calculations.
- Access creates an ID field using the AutoNumber data type. A unique number is automatically entered in this field as you enter each new record. 
- The Yes/No data type can be useful for fields designed to hold simple Yes/No or True/ False data.

Computer Science & Information Technology

You might also like to view...

Discuss the role of the physical security process.

What will be an ideal response?

Computer Science & Information Technology

Which of the following methods returns a value?

A. Method changeName(String lName, String fName)    lastName = lName    firstName = fName    Display "The name has been changed to " + firstName + " " + lastName End Method B. Method displayInfo()    Display "Account #: " + acctNumber    Display "Account type: " + acctType    Display "Owner name: " + lastName + ", " + firstName    Display "Current balance: " + acctBal End Method C. Method withdraw(Numeric amt)    acctBal = acctBal - amt    Display "The new balance is: $" + acctBal End Method D. Method inquire()    Return acctBal End Method

Computer Science & Information Technology

Which of the following agents is called upon when moving a message from one user to another?

a. Mail user agent b. Mail transport agent c. Mail delivery agent d. Application interface agent

Computer Science & Information Technology

You should take at least two key documents with you to an interview-your resume and a(n) ______________________________.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology