| A | B |
|---|
| ACCDE file | An Access file format that prevents individuals from making design changes to forms, reports, and macros. |
| Application title | The text that displays in the Access title bar when that database is open. |
| AS | An SQL keyword that creates captions for fields. |
| Back end | A file that consists of the database tables and their data. The back end is typically placed on a server and is not directly seen by the end user. |
| Compact & Repair | A process where an Access file is rewritten to store the objects and data in more efficiently. |
| Decrypt | An action that removes a file’s encryption or unsets a password. |
| Dependency | An object that requires, or is dependent on, another database object. |
| DISTINCT | An SQL keyword that removes duplicates from query results. |
| Encrypt | A process to hide data by making the file unreadable until the correct password is entered. |
| FROM clause | An SQL statement that lists which tables hold the fields used in the SELECT clause. |
| Front end | A file that includes the database forms, queries, reports, and macros. The end users open the front end to work with the data stored in the back-end tables. |
| Indeterminate relationship | a relationship that does not enforce referential integrity. |
| JOIN clause | An SQL statement that defines the join type for a query. |
| Keywords | Commands built into the SQL programming language |
| Microsoft SQL Server | A database application designed for high-end business uses. |
| Navigation form | A form that displays navigational controls that enable you to display forms and reports in your database. |
| Navigation Pane category | A toplevel listing that displays when the Navigation Pane arrow is clicked. |
| Navigation Pane group | A second-level listing that display when a Navigation Pane category is selected. |
| Office background | A small graphic in the top right corner of the Access application window used to personalize Office 2013. |
| ON | An SQL keyword that is used to specify which field is common to two tables. |
| Open Exclusive | An option that opens the database so that changes can be made, but no one else may open the database at the same time. |
| Open Exclusive Read-Only | An option that opens the database in both Exclusive and Read-Only modes. |
| Open Read-Only | An option that opens the database so that all objects can be opened and viewed, but data and design changes cannot be made. |
| Performance Analyzer | A wizard that analyzes database objects, and then offers suggestions for improving them. |
| SELECT clause | An SQL statement that lists which fields the query should display. |
| Split database | An Access database that is split into two files—one containing the back end, and one containing the front end. |
| SQL (Structured Query Language) | A language used by many database programs to view, update, and query data in relational databases. |
| SQL statement | An expression that defines the SQL commands that should be performed when the query is run. |
| Strong password | A password that is very difficult to guess. |
| Table Analyzer | A wizard that searches for repeated data in a table, and then splits the table into two or more related tables. |
| UNION | An SQL keyword that is used to combine one or more queries in a union query. |
| Union query | A query type that combines the results of two or more similar select queries. |
| Weak password | A password that is easy to guess. |
| Where clause | An SQL statement that defines the criteria that should be applied when a query is run. |
