How can we help?

You can also find more resources in our Help Center.

30 terms

Access Matching Set

STUDY
PLAY
Database object
The basic part of a database that you work with; for example, tables, queries, forms, and reports.
Record
The collection of related information that displays in a single row of a database table.
Single form
A form that displays one record at a time uses this type of layout.
AutoNumber
A data type that automatically assigns a unique, numeric value to a field.
Form
A database object used to enter new records, delete records, or update existing records.
Criteria
The conditions used in a query to select the records that you are looking for.
Data type
This specifies the kind of information that a field will hold; for example, text or numbers.
Quick start
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.
Unique
An Access field property that prevents a field in a table from having two of the same values.
Relational Database
A database that consists of two or more tables that are related by sharing a field common to both tables.
Simple Query
A wizard that quickly adds fields to a new query.
IntelliSense
A technology that displays Quick Info, ToolTips, and AutoComplete as you type expressions.
Comparison
Equal to (=) and greater than (>) are examples of this type of operator.
Show Table
This dialog box is used to add tables to an existing query.
And
In the query design grid, two criteria placed in the same row use this logical operator.
Or
When two criteria are placed in different rows in the query design grid, this logical operator will be applied.
Asterisk (*)
This wildcard character can represent any combination of characters.
Question mark
This wildcard character can represent any single character.
Square bracket
When using a field name in a calculated field, the field's name must start and end with this character.
Total
To add summary statistics to a query, this row be added to the query.
Layout
The arrangement of data and labels in a form or report.
Form Wizard
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.
Logo
A small picture that can be added to a form header, typically to the left of the title.
Title
A form control that displays the name of a form by default; the actual text can be edited later.
Control grid
Cells arranged in rows and columns into which controls are placed.
Input mask
A set of special characters that control what can and cannot be entered in a field.
One-to-many form
A type of form that has a subform that displays related records from another table.
Main form
This name is often applied to the form that has a subform.
Data sheet
By default, subforms display in this view.