Term
|
Definition
| A main component that is created and used to make the database function. |
|
|
Term
|
Definition
| The smallest data element contained in a table (first name, last name, address). |
|
|
Term
|
Definition
| A complete set of all the data elements (fields) about one person, place, even, or concept. |
|
|
Term
|
Definition
| A collection of related records. |
|
|
Term
|
Definition
| Consists of one or more tables to store data, one or more forms to enter data into tables, and one or more reports to output the table data as organized information. |
|
|
Term
|
Definition
| organizes and lists the database objects in an Access Database. |
|
|
Term
|
Definition
| Is where you add, edit, and delete the records of a table. |
|
|
Term
|
Definition
| Is where you create tables, add and delete fields, and modify field properties. |
|
|
Term
|
Definition
| Is the field (or combination of fields) that uniquely identifies each record in a table. |
|
|
Term
|
Definition
| Is an object that enables you to enter, modify or delete table data. |
|
|
Term
|
Definition
| Is a question that you ask about the data in the tables of your database. |
|
|
Term
|
Definition
| Is a number, a text phrase, or an expression used to filter the records in a table. |
|
|
Term
|
Definition
| Contains professional looking formatted information from underlying tables or queries. |
|
|
Term
|
Definition
| Reduces the size of the database. |
|
|
Term
|
Definition
| Creates a duplicate copy of the database. |
|
|
Term
|
Definition
| Displays a subset of records based on specified criteria. |
|
|
Term
|
Definition
| Displays only the records that match the selected criteria. |
|
|
Term
|
Definition
| Displays table records based on multiple criteria. Filter by Form enables the user to apply the logical operators AND, and OR. |
|
|
Term
|
Definition
| 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. |
|
|
Term
|
Definition
| Lists records in a specific sequence, such as ascending by last name or by ascending Employee ID. |
|
|
Term
|
Definition
| Produces a value from an expression or function that references one or more existing fields. |
|
|
Term
|
Definition
| Is an unchanging value, like a birth date. |
|
|
Term
|
Definition
| Is the unnecessary storing of duplicate data in two or more tables. |
|
|
Term
|
Definition
| Uses no spaces in multi-word field names, but uses uppercase letters to distinguish the first letter of each new word. |
|
|
Term
|
Definition
| Determines the type of fata that can be entered and the operations that can performed on the data. |
|
|
Term
|
Definition
data type is a number that automatically increments each time a record is added.
Reference Data types found on page 122. |
|
|
Term
|
Definition
| is enforced, you cannot enter a foreign key value in a related table unless the primary key value exists in the primary table. |
|
|
Term
| Cascade Update Related Field |
|
Definition
| is an option that directs Access to automatically update all foreign key values in a related table when the primary key value is modified in a primary table. |
|
|
Term
| Cascade Delete Related Records |
|
Definition
| is an option that directs Access to automatically delete all records in related tables that match the primary key that is deleted from a primary table. |
|
|
Term
|
Definition
| Setting enables quick sorting in primary key order and quick retrieval based on the primary key. |
|
|
Term
|
Definition
| Is established when the primary key value in the primary table can match many of the foreign key values in the related table. |
|
|
Term
|
Definition
| Enables you to create queries, the Design view is divided into two parts – the top portion displays the tables, and the bottom portion displays the fields and the criteria. |
|
|
Term
|
Definition
| Provides dialog boxes to guide you through the query design process. |
|
|
Term
|
Definition
| Displays only the records that match the criteria entered in Design view. |
|
|
Term
|
Definition
| Is a special character that surrounds the criterion’s value. |
|
|
Term
|
Definition
| Is a special character that can represent one or more character in the criterion of a query. |
|
|
Term
|
Definition
| Uses such symbols as “=” or “<” to insert wanted criteria. |
|
|
Term
|
Definition
| Is the term in Access to describe a blank field. |
|
|
Term
|
Definition
| Determines the order of records in the query’s datasheet view. |
|
|
Term
|
Definition
| Is used to produce query results. |
|
|
Term
|
Definition
| Are tables that are joined together in a relationship using a common field. |
|
|
Term
|
Definition
| Determines the sequence by which operations are calculated in an expression. |
|
|
Term
|
Definition
| Is a formula used to calculate new fields from the values in existing fields. |
|
|
Term
|
Definition
| Is the set or rules that Access follows when evaluating expressions. |
|
|
Term
|
Definition
| Produces a result based on inputs known as arguments. |
|
|
Term
|
Definition
| Is a variable or constant that is needed to produce the output for a function. |
|
|
Term
|
Definition
| Calculates the monthly loan payment five the interest rate, term of the loan, and the original value of the loan. |
|
|
Term
|
Definition
| Evaluates an expression and displays one value when the expression is true and another value when the expression is false. |
|
|
Term
|
Definition
| Affects the date’s display without changing the actual underlying value in the table. |
|
|
Term
|
Definition
| Enables you to isolate a specific part of a date, such as the year. |
|
|
Term
|
Definition
| Displays as the last row in the Datasheet view of a table or query and provides a number of aggregate functions. |
|
|
Term
|
Definition
| Contains an addition row in the design grid and is used to display only aggregate data when the query is run. |
|
|
Term
|
Definition
| Is used to create data entry forms for customers, employees, products, and other primary tables. |
|
|
Term
|
Definition
| Is the table or query that supplies the record for a form or report. |
|
|
Term
|
Definition
| Displays fields in a vertical column, and displays one record at a time. |
|
|
Term
|
Definition
| Is used to modify the design of a form. |
|
|
Term
|
Definition
| Displays records horizontally, with label controls across the top and the data values in rows under the labels. |
|
|
Term
|
Definition
| Combines two views of the same record source-one sections is displayed in a stacked layout and the other section is displayed in a tabular layout. |
|
|
Term
|
Definition
| Divides the form into two halves. |
|
|
Term
|
Definition
| Displays multiple records in a tabular layout similar to a table’s Datasheet view. |
|
|
Term
|
Definition
| Is a replica of a table or query’s Datasheet view except that it still retains some of the form properties. |
|
|
Term
| Visual Basic for Applications (VBA) |
|
Definition
| Is Microsoft’s programming language that is built into all of the Office Products. |
|
|
Term
|
Definition
| Provides guides to help keep controls aligned horizontally and vertically, and give your form a uniform appearance. |
|
|
Term
|
Definition
| Displays at the top of each form. |
|
|
Term
|
Definition
| Displays the records in the form’s record source. |
|
|
Term
|
Definition
| Displays at the bottom of the form. |
|
|
Term
|
Definition
| To add, edit, and delete data I a form; the layout and design of the form cannot be changed in this view. |
|
|
Term
|
Definition
| Displays the data found in a form’s record source. |
|
|
Term
|
Definition
| Is a literal word or phrase to describe the data. |
|
|
Term
|
Definition
| Is a text box that is connected to a field in a table or query. |
|
|
Term
|
Definition
| Is a label or other decorative design element, and is not connected to a source of data. |
|
|
Term
|
Definition
| Contains an expression that generates a calculated result when displayed in Form view. |
|
|
Term
|
Definition
| Is used to instantly create a tabular report based on the table or query currently selected. |
|
|
Term
|
Definition
| Displays data horizontally across the page in a landscape view. |
|
|
Term
|
Definition
| Displays fields in a vertical column. |
|
|
Term
|
Definition
| Asks you questions and then uses your answers to generate a report. |
|
|
Term
|
Definition
| Prints ponce at the beginning of each report. |
|
|
Term
|
Definition
| Appears once at the top of each page. |
|
|
Term
|
Definition
| Prints once at the bottom of the report. |
|
|
Term
|
Definition
| When activated, will appear just above the Detail section in design view, with the name of the field you are grouping. |
|
|
Term
|
Definition
| When activated, will appear just below the Detail section in Design view, but only when you select this option in the Group, Sort, and Total pane. |
|
|
Term
|
Definition
| Enables you to see what the printed report will look like in a continuous page layout. |
|
|
Term
|
Definition
| Two different tables, same primary key. |
|
|
Term
|
Definition
| Two one-many relationships with a third party junction table. |
|
|
