Term | Definition |
Alphanumeric data | Data containing numbers, text, or a combination of numbers and text. |
AutoNumber | Data type that automatically adds a unique field value to each record in a table. |
Blank database template | A template that creates a database that contains only an empty table. |
Data type | The property of a field that determines the type of data that you can enter into the field, such as numbers or text. |
Default Value property | A field property that lets you specify the value to enter into that field for each record in a table. |
Description property | An optional field property that you can use to describe the data to store in the field. |
Design grid | The top half of the Table window in Design view that displays the name, data type, and optional Description property for each field in a table. |
Design view | The view of a table that lets you add, delete, and rearrange field. You can also use Design view to make changes to the way that fields store data. |
Field Properties pane | The bottom half of the Table window in Design view that displays properties for the selected field in a table. |
Field property | An additional description of a field beyond the field's data type specifying how to store data in the field, like the number of characters the field can store. |
Field Size property | Property identifying the number of characters that a Text, and Number, or an AutoNumber field can store. |
Format property | Property for a field specifying how to display numbers, dates, times, and text. |
Primary key | Field in a database table containing a unique field value for each record in the table. |
Required property | Field property specifying whether a value must be entered into the field. |
Template | An object that you can use to create a database, table, or field in a database. |