How can we help?

You can also find more resources in our Help Center.

Access

STUDY
PLAY
the basic part of a database that you work with; for example, tables, queries, forms, and reports.
data type
the collection of related information that displays one record at a time uses this type of layout.
record
a form that displays one record at a time uses this type of layout
single form
a data type that automatically assigns a unique, numeric value to a field.
autonumber
a database object used to enter new records, delete records, or update existing records
form
the conditions used in a query to select the records that you are looking for
criteria
this specifies the kind of information that field will hold; for example, text or numbers
data type
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
quick start
an access field property that prevents a field in a table from having two of the same values
unique
a database that consists of two or more tables that are related by sharing a field common to both tables
relational database
a structural collection of related information about people, events, and things
database
the computer software that allows people to interact with a database
database management system
an access view that displays records in rows and fields in columns
datasheet
each individual characteristics in a record that diplays as a single column in a datasheet
field
a database object that displays a subset of data in response to a specific question
query
a database object used to display the result of a query or the contents of a table on the screen or in printed form
report
the blank row at the end of a datasheet used to add records to a table
append
an access field that limits the number of characters that can be typed into text or number field
field size
a rule that keeps related values synchronized
referential integrity
an access view that displays tools to modify the format of a report or form while being able to view the data that it is intended to display
layout
A wizard that quickly adds fields to a new query
Simple Query
A technology that displays Quick Info, ToolTips, and AutoComplete as you type expressions
IntelliSense
Equal to and greater than are examples of this type of operatpr
Comparison
This dialog box is used to add tables to an existing query
Show Table
In the query design grid, two criteria placed in the same row use this logical operator
And
When two criteria are placed in different rows in the query design grid, this logical operator will be applied.
Or
This wildcard charater can represent any combination of characters.
Asterisk *
This wildcard character can represent any single character
Question mark ?
When using a field name in a calculated field, the field's name must start and end with this character
Square bracket
To add summary statistics to a query, this row must be added to the query.
Total
In a query, criteria is added in this view
Design
In a query, results are displayed in this view
Datasheet
An IntelliSense menu of commands that match the characters you are typing
AutoComplete
An IntelliSense box that explains the purpose of the selected AutoComplete
Quick Info
In query criteria, dates are surrounded by this character.
3
An operator that finds all bumbers ort dates between and including two values
Between... And
A combination of fields, mathematical operators, and pre-built functions that calculates values
Expression
A data type used to store values that can have one of two possible values
Yes/No
The operator that is placed at the beginning of criteria that use wildcards
Like
A calculation for a group of data such as a total, an average, or a count
Summary Statistics
The arrangement of data and labels in a form or report
Layout
A tool used to create a form where the desired fields are selected before they added to the form
Form Wizard
An Access feature that adds fields to the form when you double-click them in the Field List
Blank Form tool
A small picture that can be added to a form header, typically to the left of the title
Logo
A form control that displays the name of a form by default; the actual text can be edited later.
Title
Cells arranged in rows and columns into which controls are placed
Contol grid
A set of special characters that control what can and cannot be entered in a field.
Input mask
A type of form that has a subform that displays related records from another table
One-to-many form
This name is often applied to the form that has a subform
Main Form
By default, subforms display in this view.
Datasheet
An Access view used to format a form or report while viewing a sample of the data
Layout View
A layout that places labels in the first column and data in the second column
Columnar
An Access view used to enter data in a form
Form view
Objects on a form or report that describe each field.
Labels
Objects on a form or report that displays the data from fields
Text boxes
This property sheet tab contains the input mask that is replaced as you type data into the field
Placeholder character
The symbol in an input mask that is replaced as you type data into the field
Placeholder character
Formatting that evaluated the values in a field and formats that data accroding to the rules you specify; for example, only values over 1000 will have bold applied
Conditionial formatting
A form contained within another form that displays records related to the other form
Subform
When you want to build a form for a subset of data, you can base the form on this
Query
Cells arranged in rows and columns into which controls are placed
Layout
To combine two or more cells in a tabular layout
Merge
This is used when you want to build a report by adding fields one at a time or arrange them in different layout
Blank Report tool
A small picture that can be added to a reprot header, typically to the left of the title
Logo
To display a subset of records on a report that match a given criterion
Filter
The amount of space between a control's border and other controls on the form or report
Padding
An Area at the beginning of a report that contians labels, text boxes, and other controls.
Report Header
An area on the top of each page that contians labels, text boxes, and other controls.
Page Header
An area at the bottom of each page that contians labels, text boxes, and other controls.
Page footer
An area at the end of a report that contians labels, text boxes, and other controls.
Report footer
A tool that can create a report with a single click
Report tool
A page orientation where the page is wider than it is tall
Landscape
This can be removed from a report to prevent printing blank pages
Extra Space
This pane is used to add fields to a report in Layout view
Field list
This pane is used to grtoup and sort reports
Group, Sort, and Total Pane
A report formatted so that the data can be printed on a sheet of labels
Label report
This view is used when you want the most control over your report layout
Design View
This property is changed when you need to add page breaks before report headers
Force New Page
A text box that displays the result of an expression
Calculated control
When no alternating row color is desired, select this value
No Color