Exam 7: Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

To calculate an average or total on records displayed in a table or query,you would use a calculation function.

The ________ query wizard helps you identify orphan records.

A ________ gives you less control and fewer options to manage the details of a query design than the query window.

Since everyone in the United States has a unique Social Security number,it is the best choice for primary key in a database table.

Query by example allows you to specify the data you want see by entering sample data.

A condition you apply temporarily to a table to display a subset of records is called a(n)________.

When developing a query,you should only add ________ that have fields you are going to use in the query to prevent incorrect or inconsistent results.

To retrieve information from more than one table or query,you would use a ________ query.

Before opening the Expression Builder to create a(n)________ field,you should save your query first.

In the Relationship window,the field the line is pointing to in each table is the ________ field between the tables.

When you sort by multiple fields in Access the first field you sort on is called the primary sort field and all subsequent fields are called ________ sort fields.

A complex query designed by combining search criteria and aggregate functions in a single query can make it more difficult to ________ the query if it does not work.

The Access tool that helps you format calculated fields correctly is called Expression Builder.

A type of operator that combines two or more criteria in a query is called a(n)________ operator.

A custom filter that matches all or part of the text in a field that you specify is called a(n)________.

One method to increase the width of columns in a query result to best fit the data is to double-click the ________.

The ________ work by asking a series of questions about the tables and fields,then creating a query based upon your responses.

The Access tool used to format calculated fields correctly is called the ________.

AND and OR are examples of ________ operators.