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.
You might also like to view...
Discuss the role of the physical security process.
What will be an ideal response?
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
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
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).