Question | Answer |
database | a collection of data that allows access, retrieval, and use |
field | a specific piece of information within a record |
record | a row in a table containing information about a person, product, event |
primary key | a unique identifier in a record, usually a number |
data type | indicates the type of data that can be stored in a field such as text, number, currency |
Access work area | large area for working on objects such as tables, queries, reports |
Navigation pane | pane on the left that contains a list of all objects in the database |
Shutter Bar | an Open/Close button for the Navigation Pane |
Object tab | tabs that appear in the work area when an object is open |
One-to-many relationship | each row in a table may be associated with many rows in another table |
Status bar | lower left bar of Access window, presents information about the object |
Row selector | the small box to the left of the record, when clicked indicates current record with a border |
Number | a field data type that contains only numbers |
Currency | a field data type that contains only monetary values |
Design view | a view for creating fieldnames and data types for a database table |
Datasheet view | a view for entering record information into the database table |
Navigation buttons | buttons used to move within a table |
Field Properties | general and lookup options for each field name and data type |