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