Term
|
Definition
| database management component of Microsoft Office |
|
|
Term
|
Definition
| collection of related information |
|
|
Term
|
Definition
| database object that contains data collected about a single type of person, place, or thing (e.g., employees, books, cars) |
|
|
Term
|
Definition
| database object used to enter new data in a table or review or edit existing data in a table |
|
|
Term
|
Definition
| database object used to present data from one or more tables in a useful manner, either on-screen or on paper |
|
|
Term
|
Definition
| database object used to locate records that meet one or more conditions defined by the user |
|
|
Term
|
Definition
| conditions defined by the user when forming a query (e.g., city = "Beckley" or age < 21) |
|
|
Term
|
Definition
| one piece of information in a table (e.g., Name, Address, Department) |
|
|
Term
|
Definition
| the complete set of fields for an individual entity in a table (e.g., all the information about one employee, one book, or one car) |
|
|
Term
|
Definition
How many fields and records in the table shown below?
[image]
|
|
|
Term
| EmpID--because it is unique for every record |
|
Definition
In the table below, which field is the best choice for primary key? Why?
[image] |
|
|
Term
|
Definition
| field that uniquely identifies one record from all other records in the table (e.g., SSN, WVEIS#) |
|
|
Term
|
Definition
| identifies the type of data that will be stored in a field |
|
|
Term
|
Definition
| recommended data type for fields containing numbers on which no arithmetic operations will be performed |
|
|
Term
|
Definition
| table view in which the contents of all records are displayed in columns and rows similar to a spreadsheet |
|
|
Term
|
Definition
| table view in which fields are added and removed and field information is displayed and edited |
|
|
Term
|
Definition
| Field Size and Format are examples of these |
|
|
Term
|
Definition
| stepwise guide to creating Access objects like forms and queries |
|
|
Term
|
Definition
| process of reordering the records in a table on the basis of one or more fields |
|
|
Term
|
Definition
| operation that locates and highlights fields that match a criteria designed by the user |
|
|
Term
|
Definition
| operation that locates and highlights fields that match a criteria designed by the user and substitutes another value |
|
|
Term
| create new table - table design |
|
Definition
Identify the functions of the buttons shown:
[image] [image] |
|
|
Term
| create new form - form design |
|
Definition
Identify the functions of the buttons shown:
[image] [image] |
|
|
Term
| create new report - report design |
|
Definition
Identify the functions of the buttons shown:
[image] [image] |
|
|
Term
| query design - query wizard |
|
Definition
Identify the functions of the buttons shown:
[image] [image] |
|
|
Term
A - first record
B - previous record
C - current record
D - next record
E - last record
F - new record |
|
Definition
Identify the functions of the buttons shown in the Record Navigation panel:
[image]
|
|
|
