| 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 Access 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, and 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 textboxes, 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 user |
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 database |
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 a