Access Lesson 2
Terms
undefined, object
copy deck
- Alphanumeric data
- Data that contains numbers, text, or a combination of numbers and text.
- AutoNumber
- A 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.
- Design grid
- The top half of the Table window in the 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 fields. You can also use it 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 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, a Number, or an 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 value for each record in the table.
- Required property
- A field property that specifies 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.