Upgrade to remove ads
Access Matching Set
The basic part of a database that you work with; for example, tables, queries, forms, and reports.
The collection of related information that displays in a single row of a database table.
A form that displays one record at a time uses this type of layout.
A data type that automatically assigns a unique, numeric value to a field.
A database object used to enter new records, delete records, or update existing records.
The conditions used in a query to select the records that you are looking for.
This specifies the kind of information that a field will hold; for example, text or numbers.
A set of fields that can be added with a single click. For example, the Address data type inserts five fields for storing postal addresses.
An Access field property that prevents a field in a table from having two of the same values.
A database that consists of two or more tables that are related by sharing a field common to both tables.
A wizard that quickly adds fields to a new query.
A technology that displays Quick Info, ToolTips, and AutoComplete as you type expressions.
Equal to (=) and greater than (>) are examples of this type of operator.
This dialog box is used to add tables to an existing query.
In the query design grid, two criteria placed in the same row use this logical operator.
When two criteria are placed in different rows in the query design grid, this logical operator will be applied.
This wildcard character can represent any combination of characters.
This wildcard character can represent any single character.
When using a field name in a calculated field, the field's name must start and end with this character.
To add summary statistics to a query, this row be added to the query.
The arrangement of data and labels in a form or report.
A tool used to create a form where the desired fields are selected before they are added to the form.
Blank Form tool
An Access feature that adds fields to the form when you double-click them in the Field List.
A small picture that can be added to a form header, typically to the left of the title.
A form control that displays the name of a form by default; the actual text can be edited later.
Cells arranged in rows and columns into which controls are placed.
A set of special characters that control what can and cannot be entered in a field.
A type of form that has a subform that displays related records from another table.
This name is often applied to the form that has a subform.
By default, subforms display in this view.
Upgrade to remove ads