| A | B |
|---|
| action query | Changes the data in its data source or creates a new table. |
| aggregate fields | A field that uses an aggregate function to calculate data. |
| aggregate function | Performs a calculation on a set of values and then returns a single value. |
| aggregate function | Performs a calculation on a set of values and then returns a single value. |
| append query | An action query that adds the records in a query's result set to the end of an existing table |
| back-end file | In a split database, the database that contains the tables. |
| backup | A copy of a database file. |
| Blank Forms | Category in the Application Parts gallery that contains a collection of 10 form parts that allows you to add predefined forms to a database. |
| calculated field | A column in a query that results from an expression. |
| cross join | A join in which each row from one table is combined with each row from another table. |
| crosstab query | A query that calculates a sum, average, count, or other type of total on records and then groups the results by two types of information: one down the left side of the datasheet and the other across the top. |
| Database Documenter | Creates a report that shows details, or definitions, about a selected object and opens it in Print Preview. |
| database properties | Details about a file that describe or identify it. |
| Database Splitter | A wizard that splits a database into two files. |
| decrypting | Removing the password from a file that has been encrypted. |
| delete query | An action query that removes rows matching the criteria that you specify from one or more tables. |
| encrypting | Scrambling data in a way that can only be reconverted by an authorized user who has the password. |
| front-end file | A database that contains the queries, forms, reports, and other objects created from the tables. |
| group footer | The section of a report where data in the group is summarized. |
| group header | The section of a report where the name of a grouped field is displayed and printed. |
| grouping field | A field by which data is grouped. |
| grouping intervals | The way that records are group together. |
| grouping levels | The nested arrangement of the groups in a report. |
| groups | Collection of records separated visually and displayed with its introductory or summary information. |
| hierarchical form | A form/subform combination, also called a master/detail form or a parent/child form. |
| inner join | Most common type of join; includes rows in the query only when the joined field matches records in both tables. |
| join | A relationship between identical fields in different tables. |
| Label Wizard | A wizard that asks questions about the labels you want to create and the data you want to display on them, which then creates the labels based on the answers. |
| left outer join | A join that includes all of the rows from the first table in the query and only those records from the second table that match the join field in the first table. |
| main form | Primary form in a form/subform combination. |
| make table query | An action query that creates a new table and then creates records in it by copying records from an existing table. |
| Multiple Items tool | A tool that creates a customizable form that displays multiple records. |
| Navigation form | A form that includes a set of navigation tabs that you can click to display forms and reports. |
| object dependencies | Describes how objects in a database are dependent on or rely on other components to function properly. |
| outer join | A join that includes all of the rows from one table and only those rows from the other table that match the join field in the first table. |
| Print Preview | A feature that displays a report as it will look when printed. |
| right outer join | A join that includes all of the rows from the second table in the query and only those records from the first table that match the join field in the second table. |
| SELECT statement | An SQL command that instructs the Microsoft Access database engine to return information from the database as a set of records. |
| split form | A feature that gives you two views of your data at the same time — in both Form view and Datasheet view. |
| subform | A form that is inserted into another form. |
| subquery | An SQL SELECT statement that is inside another select or action query. |
| Table Analyzer | A wizard that performs the normalization process by examining a table design and suggesting a way to divide the table for maximum efficiency. |
| Totals row | A row inserted at the bottom of a table that provides a menu of functions for each column in the row. |
| unequal join | A join that is not based on the equivalence of the joined fields. |
| update query | An action query that changes a set of records according to specified criteria. |
