+
Related Flashcards
Cards In This Set
| Front | Back |
|
Object
|
A main component that is created and used to make the database function ex. table, query, form, report
|
|
Field
|
Smallest data element contained in a table ex. first name, last name address, phone #
|
|
Record
|
Complete set of all of the data elements (fields) about one person, place, event, or concept
|
|
Table
|
The foundation of every database; collection of related records
|
|
Database
|
Consists of one or more tables to store data, one or more forms to enter data into the tables, and one or more reports to output the table data as organized info
|
|
Navigation Pane
|
Organizes and lists the database objs in an Access database
|
|
Datasheet view
|
Where you add, edit, and delete the records of a table
|
|
Design view
|
Where you create tables, add and delete fields, and modify properties
|
|
Primary key
|
The field or combo of fields that uniquely ids each record in a table
|
|
Form
|
An object that enables you to enter, modify, or delete data table
|
|
Query
|
A question that you ask about the data in the tables of your database
|
|
Criteria
|
A number, text phrase, or an expression used to filter records in a table
|
|
Report
|
Contains professional-looking formatted info from underlying tables or queries
|
|
Access speed
|
Measures the time it takes for the storage device to make the file content available for use
|
|
Compact and repair database
|
Reduces size of database
|
