A database object that lets you ask the database about the data it contains.
What is a query?
100
This is a menu that opens when you click the arrow on the right side of a field selector in a datasheet. The menu contains options for sorting data and for applying and clearing filters.
What is AutoFilter?
100
The feature of a DBMS that lets you connect the data in the tables in the database so you can create queries and other objects using the data from two or more tables.
What is a relationship?
100
This is a set of rules that a DBMS follows to ensure that there are matching values in the common field used to create the relationship between related tables and that protects the data in related tables to make sure that data is not accidentally deleted or change.
What is referential integrity?
100
When two tables are related, the datasheet for the primary table contains expand indicators for each record. Clicking an expand indicator in the primary table displays the records in the related table in this.
What is a subdatasheet?
200
This is a way of telling the query which data you are interested in seeing.
What is a condition?
200
This is a relationship between two tables in a database in which one record in the primary tables can match many (zero, one, many) records in the related table.
What is a one-to-many relationship?
200
When two tables in a database are related, the common field in the related table is called this.
What is a foreign key?
200
this is a field that appears in two or more tables in a database and that has the same data type and field values. This can also be called a matching field. You can relate tables and usually has the same field name in the related tables.
What is a common field?
200
This is a query that is based on the data in two or more tables.
What is a multitable query?
300
This is the wizard in Access that lets you create a query and indicte what you'd like to see in the query results by selecting options in dialog boxes.
What is the Simple Query Wizard?
300
This is an operator used in a query that selects records that match all of two or more conditions in a query.
What is an And Operator?
300
This is the optional row in a datasheet that counts the number of values in a column. When a field contains numeric data, you can use the this to calculate the total, average, minimum, or maximum value in a column.
What is a Total row?
300
This is a field in a query, form, or report that displays a value that is calculated using a combination of operators, constants, and the values in other fields.
What is a calculated field?
300
This is an operator used in a query that selects records that match at least one of two or more conditions in a query.
What is an Or Operator?
400
This is the method of arranging the records in a table, query, form, or report using the values in one or more fields.
What is sort?
400
This opens on the left side of the screen and lists the objects in the database.
What is the navigation pane?
400
This is a filter that you can apply to a datasheet or form that rearranges the records based on one or more field values that you select from a list.
What is Filter by Form?
400
This is a collection of objects.
What is a database?
400
The term given to the calculation used in a calculated field that identifies the fields and operators to use in the calculated field.
What is an expression?
500
This is a temporary rearrangement of the records in a table, query, form, or report based on one or more specified conditions.
What is a filter?
500
Each record is made up of one or more of these.
What is a field?
500
Access is a program known as this, it allows you to store, retrieve, analyze, and print information.
What is a DBMS (Database Management System)?
500
This is a row or a complete set of data.
What is a record?
500
This is a filter that you can apply to a datasheet or form that rearranges the records based on a selected field value or part of a field value.