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 typefor 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 typefor 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 typecan be useful for fields designed to hold simple Yes/No or True/ False data.
You might also like to view...
When using the Internet for research, you
a. can assume that everything you find is accurate and appropriate. b. should evaluate sites for bias and relevance. c. can assume if there is no author listed, the site is not appropriate for research. d. should look for sites with many links to other resources.
________ is data that have been organized in a useful manner
Fill in the blank(s) with correct word