click below
click below
Normal Size Small Size show me how
CBA Access Lesson 2
Vocabulary
| Term | Definition |
|---|---|
| Alphanumeric Data | Data that contains numbers, text, or a combination of numbers and text. |
| AutoNumber | A data type that automatically adds a unique field vallue to each record in a table. |
| Blank Database Template | A template that creates a database that contains no objects. |
| 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 | An optional description of a field that specifies the value to enter into each record in a table. |
| Description Property | An optional field property tha tyou can use to describe the data, to store iin the field. |
| Design Grid | The top half of the table window in Design View that desplays 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 fields. 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 desciption of a field beyond the field's data type that specifies how to store data in the field, such as the number of characters the field can store. |
| Field Size Property | The property that identifies the number of characters that a Text, Number, or AutoNumber field can store. |
| Format Property | A property for a field that specifies how to display numbers, dates, times, and text. |
| Primary Key | The field in a database table that contains a unique field calue for each record in the table. |
| Required Property | A field property that specifies whether a value must be entered into the field. |
| Template | A predesigned file that you can use to create a new life. |