| A | B |
|---|
| AND Condition | A condition in which only records where all of the values are present in the selected fields. |
| Control | an object on a form or report that displays data or text, performs actions, and lets you view and work with information |
| Bound | The term used to describe objects and controls that are based on data that is stored in tables. |
| Bound Control | A control that retrieves its data from an underlying table or query; a text box control is an example of a bound control. |
| Calculated Control | A control that contains an expression, often a formula, that uses one or more fields from the underlying table or query. |
| Control Layout | The grouped arrangement of controls on a form or report. |
| Data Entry | The action of typing the record data into a database form or table. |
| Date Control | A control on a form or report that inserts the current date each time the form or report is opened. |
| Design View | An Access view that displays the detailed structure of a query, form, or report; for forms and reports, may be the view in which some tasks must be performed, and only the controls, and not the data, display in this view. |
| Detail Section | The section of a form or report that displays the records from the underlying table or query. |
| Filter by Form | An Access command that filters the records in a form based on one or more fields or based on more than one value in the field. |
| Filter by Selection | An Access command that retrieves only the records that contain the value in the selected field. |
| Filtering | The process of displaying only a portion of the total records based on matching a specific value. |
| Form | An Access object you can use to enter new records into a table, edit or delete existing records in a table, or display existing records. |
| Form Footer | Information at the bottom of the screen in Form view that is printed after the last detail section on the last page. |
| Form Header | Information, such as form's title, that displays at the top of the screen in Form view and is printed at the top of the first page when records are printed as forms. |
| Form Tool | The Access tool that creates a form with a single mouse click, which includes all of the fields from the underlying data source ( table or query). |
| Form View | The Access view in which you can view the records, but you cannot change the layout or design of the form. |
| Form Wizard | The Access tool that creates a form by asking a series of questions. |
| Group Footer | Information printed at the end of each group of records; used to display summary information for the group. |
| Group Header | Information printed at the beginning of each new group of records, for example, the group name. |
| Group, Sort, and Total Pane | A pane that displays at the bottom of the screen in which you can control how information is sorted and grouped in a report; provides the most flexibility for adding or modifying groups, sort orders, or totals options on a report. |
| Label Control | A control on a form or report that contains descriptive information, typically a field name. |
| Layout Selector | A small symbol that displays in the upper left corner of a selected control layout in a form or report that is displayed in Layout view or Design view; used to more an entire group of controls. |
| Layout View | The Acces view in which you can make changes to a form or report while the object is running- the data from the underlying data source displays. |
| OR Condition | A condition in which records tha match at least one of the specified values are displayed. |
| Page Footer | Information printed at the end of every page in a report; used to print page numbers or other information that you want to display at the bottom of every report page. |
| Page Header | Information printed at the top of every page of a report. |
| Page Number Control | A control on a form or report that inserts the page number when displayed in Print Preview or when printed. |
| Office 365 Administrator | in Office 365, the person who creates and manages the account, adds new users, sets up the services your organization want to use, sets permission levels, and manages the SharePoint team sites |
| Record Selector Bar | The bar at the left edge of a record in Datasheet view that, when clicked, selects the entire record. |
| Record Source | The tables or queries that provide the underlying data for a form or report. |
| Report | A database object that summarizes the fields and records from a table or query in an easy- to- read format suitable for printing. |
| Report Footer | Information printed once at the end of a report; used to print report totals or other summary information for the entire report. |
| Report Header | Information printed once at the beginning of a report; used for logos, tiltes, and dates. |
| Report Tool | The Access tool that creates a report with one mouse click, which displays all of the fields and records from the record source that you- select- a quick way to look at the underlying data. |
| Report Wizard | An Access feature with which you can create a report by answering a series of questions; Access designs the report based on your answers. |
| Section Bar | A gray bar in a form or report that identifies and separates one section form another; used to select the section and to change the size of the adjacent section. |
| Stacked Layout | A control layout format that is similar to a paper form, with label controls placed to the left of each textbox control. The controls are grouped together for easy editing. |
| Subset | A portion of the total records available. |
| Tab Order | The order in which the insertion point moves form one field to another in a form when you press the Tab key. |
| Text Box Control | The graphical object on a form or report that displays the data from the underlying table or query; a text box control is known as a bound control. |
| Theme | 1. A predefined format that can be applied to the entire database or to individual objects in the database. 2. A predesigned set of colors, fonts, lines, and fill effects that look good together and that can be applied to your entire document or to specific items. |
| Unbound Control | A control that does not have a source of data, such as a title in a form or report. |
