| Append |
to add on to the end of an object, for example, adding records to the end of an existing table in a database |
| Arrange tab |
a tab in the Form or Report Layout toolbar that allows you to make changes to the arrangement of tables, rows, and columns in a Form or Report |
| Autonumber |
a data type that describes a unique sequential or random number assigned by Access as each record is entered and that is useful for data that has no distinct field that can be considered unique. This data type cannot be manually changed or typed in |
| Blank form |
allows you to create a new, blank form, which you can then customize and format the way you want |
| Bound |
a control that retrieves data from an underlying table or query |
| Data |
Facts about people, events, things, or ideas |
| Data type |
classification identifying the kind of data that can be stored in a field such as numbers, text, or dates |
| Database |
an organized collection of facts about people, events, things, or ideas related to a specific topic or purpose |
| Datasheet view |
the Access view that displays data organized in columns and rows similar to an Excel spreadsheet |
| DBA |
stands for Database Administrator, an IT professional whose primary responsibilities include database installation, configuration, design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery |
| Design tab |
a tab in the Form or Report Layout toolbar that allows you to make modifications to the design of the Form or Report |
| Design view |
an Access view that displays the detailed structure of a table, query, form, or report. Also known as developer’s view. For Forms and Reports, this may be the only view in which some tasks are performed. Only the controls, not the data are displayed in this view |
| Detail |
the area in a Form or Report that data is displayed and interacted with; may include text boxes, checkboxes, combo boxes, labels, pictures, and other data editing controls |
| Developer’s view |
also known as Design View. The most powerful view in Access |
| Enable content |
Microsoft Office’s built-in security feature |
| End users |
the person or people that use the database |
| Export |
also known as a ‘dump’, extracting and saving a database file that can be used for storage, distribution, or importing into another system |
| Field |
a single piece of information that is stored in every record and is represented by a column in a database table |
| Field name |
the description that identifies a field |
| Flat databases |
a simple database file that is not related or linked to any other collections of data |
| Form |
a database object that you can use to enter new records into a table, or to edit, delete, and display existing records in a table |
| Form design |
allows you to work with the underlying structure of your form |
| Form footer |
the bottom margin of each page of an Access form |
| Form header |
the top margin of each page of an Access