Term
|
Definition
| is a collection of information organized in columns and rows and stored electronically in a file. |
|
|
Term
|
Definition
| a database containing just one table. |
|
|
Term
|
Definition
| contains two or more tables of related information |
|
|
Term
|
Definition
|
|
Term
|
Definition
| contain information about one aspect of a record, such as the store name or city. |
|
|
Term
|
Definition
| column headings in a table. |
|
|
Term
|
Definition
| Program components that you can create and modify in Access to store, retrieve, and work with data |
|
|
Term
|
Definition
| a list of data organized in rows (records) and columns (fields) |
|
|
Term
|
Definition
| a set of criteria (conditions) you specify to retrieve data from a database |
|
|
Term
|
Definition
| a window that lets you enter and edit information in a database one record at a time |
|
|
Term
|
Definition
| a summary of database information designed specifically for printing |
|
|
Term
|
Definition
| is where all database objects for the database are listed. |
|
|
Term
|
Definition
| uniquely identifies each record among all other records in a database. |
|
|
Term
|
Definition
| characteristic of the data |
|
|
Term
|
Definition
| text, numbers that dont require calculations, or a combination of text and numbers |
|
|
Term
|
Definition
| Lengthy text (which can also contain numbers that dont require calculations) |
|
|
Term
|
Definition
| Numeric data to be used in calculations |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Data type used to represent money. |
|
|
Term
|
Definition
| Values that can be only yes or no |
|
|
Term
|
Definition
| Unique sequential number that Access assigns to each new record: can not be edited |
|
|
Term
|
Definition
| a view suited to modify all aspects of a table structure, best view to use if you are creating or changing the table structure |
|
|
Term
|
Definition
| a view used to see all the records in a table, used to update records in the table |
|
|
Term
|
Definition
| data characteristics that dictate how Access stores, handles, and displays field data. |
|
|
Term
|
Definition
| helps database users understand what data should be entered into a particular field, or assign a different field as the primary key field in the table |
|
|
Term
|
Definition
| left of each record offers a quick way to select any record in a table and sometimes displays icons to indicate the status of a record. |
|
|
Term
|
Definition
| the data you enter into each field. |
|
|
Term
|
Definition
| the border between the field names |
|
|
Term
|
Definition
| devices for inputting data such as text boxes, list arrows, or check boxes. |
|
|
