USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Data Type
|
|
|
Description
|
|
|
Field name
|
|
|
Properties
|
Detailed explanation-1: -When you create a new table in Datasheet view, Access automatically creates a primary key for you and assigns it a field name of “ID” and the AutoNumber data type.
Detailed explanation-2: -AutoNumber is a type of data used in Microsoft Access tables to generate an automatically incremented numeric counter. It may be used to create an identity column which uniquely identifies each record of a table. Only one AutoNumber is allowed in each table. The data type was called Counter in Access 2.0.
Detailed explanation-3: -Autonumbers will automatically default to 4 digits (0001, 0002, etc.) Bonus: If you want the AutoNumber to include specific text, include that text in the format field. For example, a format of “GA-"0000 will generate AutoNumbers like GA-0001, GA-0002, etc.