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 |