Table: Access databases store all data in Tables. p29

Theme: specifies colors and fonts applied to the current Access object. p114

Toggle: switch a command from on to off, or off to on, such as with a Filter.  p96

Wizard (Form, Query, etc): a step-by-step guide that walks you through creating or using a complex function.  p86, 105


Worksheet: section of an Excel workbook (or file), used when importing data from Excel. p85


Concatenation: combines multiple Fields into a new, single Field. p186


Control: where users enter and change data on a Form.  Attached to a Label. p141


Cycle: refers to what happens after you Tab to the last Form Field.  You either remain on the current record, returning to the first Field, or you advance to the next record. p145


Datasheet View: this view of an Access Table looks like an Excel spreadsheet, complete with a Header Row.  p29


Data Validation: verifying or limited data to ensure accuracy of data entry. p46


External Data: data retrieved from other programs, such as QuickBooks or Microsoft Excel. p85


Field: where the record of data is stored.  p37


Field Properties: programmable options attached to a selected database field. p59

QBE/ Query By Example: a visual format for programming Query objects


Queries: function that looks up or manipulates data by asking questions of a Table.p30   See also: Select Queries and Action Queries

Real Users: the people who have to use the database to get their job done.  p131

Record: holds all of the information about a specific item or entry in the database. p39


Reports: Access data in printed form, such as a receipt or an inventory. p32


Select Query: asks questions and returns the appropriate data as an answer. p164

Tab: using the keyboard key Tab to move from one form field to another.  p111

Tab Order: sequence of Form Fields selected when pressing the Tab key on the keyboard. p145

Beginning Microsoft Access 2013: Glossary

             Microsoft Office Specialist (MOS): Exam 77-424 for Access 2013