the basic part of a database that you work with; for example, tables, queries, forms, and reports.
the collection of related information that displays one record at a time uses this type of layout.
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 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 structural collection of related information about people, events, and things
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
each individual characteristics in a record that diplays as a single column in a datasheet
a database object that displays a subset of data in response to a specific question
a database object used to display the result of a query or the contents of a table on the screen or in printed form
the blank row at the end of a datasheet used to add records to a table
an access field that limits the number of characters that can be typed into text or number field
a rule that keeps related values synchronized
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
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 operatpr
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 charater can represent any combination of characters.
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
To add summary statistics to a query, this row must be added to the query.
In a query, criteria is added in this view
In a query, results are displayed in this view
An IntelliSense menu of commands that match the characters you are typing
An IntelliSense box that explains the purpose of the selected AutoComplete
In query criteria, dates are surrounded by this character.
An operator that finds all bumbers ort dates between and including two values
A combination of fields, mathematical operators, and pre-built functions that calculates values
A data type used to store values that can have one of two possible values
The operator that is placed at the beginning of criteria that use wildcards
A calculation for a group of data such as a total, an average, or a count
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 added to the form
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
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.
An Access view used to format a form or report while viewing a sample of the data
A layout that places labels in the first column and data in the second column
An Access view used to enter data in a form
Objects on a form or report that describe each field.
Objects on a form or report that displays the data from fields
This property sheet tab contains the input mask that is replaced as you type data into the field
The symbol in an input mask that is replaced as you type data into the field
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
A form contained within another form that displays records related to the other form
When you want to build a form for a subset of data, you can base the form on this
Cells arranged in rows and columns into which controls are placed
To combine two or more cells in a tabular layout
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
To display a subset of records on a report that match a given criterion
The amount of space between a control's border and other controls on the form or report
An Area at the beginning of a report that contians labels, text boxes, and other controls.
An area on the top of each page that contians labels, text boxes, and other controls.
An area at the bottom of each page that contians labels, text boxes, and other controls.
An area at the end of a report that contians labels, text boxes, and other controls.
A tool that can create a report with a single click
A page orientation where the page is wider than it is tall
This can be removed from a report to prevent printing blank pages
This pane is used to add fields to a report in Layout view
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
This view is used when you want the most control over your report layout
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
When no alternating row color is desired, select this value
Please allow access to your computer’s microphone to use Voice Recording.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Your microphone is muted
For help fixing this issue, see this FAQ.