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...
COGNITIVE ASSESSMENT Which of the following types of software do engineers, architects and scientists use to create designs?
A. computer-aided design software (CAD) B. augmented design software (ADS) C. computer-based engineering design software (CED) D. design and development software (DAD)
Ethernet exists at what layer of the OSI model??
A. ?Layer 1 B. ?Layer 2 C. ?Layer 3 D. ?Layer 4
The fundamental job of every operating system is to run programs, and this relies on:
What will be an ideal response?
The purpose of an Office template is to provide layout and format settings in an application.
Answer the following statement true (T) or false (F)