This query will show the top 5 grades in this class
What is Top Values Query
100
This query has provided the information of records that have no match in other tables/queries
What is Find unmatched query
100
In this query you must enter criteria
What is Parameter query
100
An unbound control that displays text
What is Label
100
The main body of a form or report in which you place bound, unbound and calculated controls
What is Detail section
200
A query that changes selected fields from selected records in one or more tables bases on the criteria you specify
What is Update query
200
A query that adds selected fields in records from existing tables or queries to the end of another table
What is Append query
200
A select query that finds repeated records in a table or query
What is Find duplicates query
200
A control that displays the result of an expression
What is Calculated control
200
A control that is not connected to a field in the database and that is used to display controls such as text, lines, rectangles, and graphics
What is Unbound control
300
A list that relates field values to the records that contain those field values that can quickly locate records
What is Index
300
A query that deletes a group of records matching the criteria you specify from one or more tables
What is Delete query
300
A query that displays a dialog box to prompt you to enter one or more criteria values when you run the query
What is Parameter query
300
A conrol that is connected, or bound, to a field in the database based on the record source
What is Bound control
300
Appears at the bottom of a form
What is Form footer
400
A query that adds, changes, or deletes multiple table records at a time
What is Action query
400
A query that creates a new table by copying selected fields in records from one or more existing tables
What is Make-table query
400
A query that performs aggregate function calculations on the values of one database field and display the result in a spreadsheet format
What is Crosstab query
400
Appears at the top of the form and is used to display titles, a picture, date/time, etc.
What is Form header
400
A property that you use to specify the type of special effect applied to a control in a form or report. Choices are chiseled, etched, flat, raised, shadowed, and sunken
What is Special effect property
500
A select query that finds all records in a table or query that have no related records in a second table or query
What is Find unmatched query
500
A query property that lets you limit the number of records in the query results of a specific number or percentage (for example - top 10 or top 10%)
What is Top values query
500
An expression used to combine text fields together (for example: LastName & " " & FirstName)
What is Concantenated expression
500
The arrangement of dotted and solid lines in a section that help you position controls precisely in a form or report
What is Design grid
500
The order in which you move from control to control, or change the focus, in a form when you press the Tab key