Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Micosoft Access
Vocabulary for Access Chapter 1
| Question | Answer |
|---|---|
| Object | An Object in an Access database is a main component that is created and used to make the database function |
| Field | A field is the smallest data element contained in a table. examples of fields are first name, last name, address, and phone number. |
| Record | A record is a complete set of all of the data elements (fields) about one person, place, event, or concept. |
| Table | A table, the foundation of every database, is a collection of related records. |
| Database | A 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 information. |
| Navigation Pane | The Navigation Pane organizes and lists the database objects in an Access database. |
| Datasheet View | The datasheet view is where you add, edit, and delete the records of a table. |
| Design View | The design view is where you create tables, add, and delete fields, and modify field properties. |
| Primary Key | The Primary Key is the field (or combination of fields) that uniquely identifies each record in a table. |
| Form | A form is an object that enables you to enter, modify, or delete table data. |
| query | A query is a question that you ask about the data in the tables of your database. |
| Criterion (criteria,pl) | A Criterion (criteria, pl) is a number, a test phase, or an expression used to filter the records in a table. |
| Report | A report contains professional-looking formatted information from underlying tables or queries. |
| Access Speed | Access Speed measures the time it takes for the storage device to make the file content available for use. |
| Compact and Repair | Compact and Repair reduces the size of the database. |
| Backup | Backup creates a duplicate copy of the database. |
| Filter | A filter displays a subset of records based on specified criteria. |
| Filter by Selection | Filter by Selection displays only the records that match the selected criteria |
| Filter by Form | Filter by Form displays table records based on multi |
| Comparison Operator | A comparison operator is used to evaluate the relationship between two quantities to determine if they are equal or not equal; and, if they are not equal a comparison operator determines which one is greater than the other. |
Created by:
kcabanaw
Popular Business sets