click below
click below
Normal Size Small Size show me how
Access Vocab Les2
Access Vocabulary Terms Lesson 2
| Question | Answer |
|---|---|
| Alphanumeric Data | a combination of numbers and text |
| Auto Number | automatically adds a unique number to the primary key field for each table |
| Blank Database Template | creates a blank database with an empty table on it |
| Data Type | determines the kind of data that you can enter in the field |
| Default Value Property | enters the same field value in a field every time a new record is added to the table |
| Description Property | an optional field property that you can use to describe what to enter in a field |
| Design Grid | field names and data types that appear at the top half of the table |
| Design View | can add, delete, and make changes to the way that fields store data |
| Field Properties Pane | bottom half of the table window, displays only certain properties for the field type |
| Field Property | describes a field's contents beyond the fields basic data type |
| Field Size Property | sets the number of characters you can store in a Text Number, or Auto Number field |
| Format Property | specify how you want Acces to display numbers, dates, times, and text |
| Primary Key | field that contains a unique field value for each record in the table |
| Required Property | specifies whether you must enter a field value in a record |
| Template | to create database, template and one or more table, query, form, and report objects that you use to enter and view data |