Exam 70: Queries and Reports

The Query Design tool is located on the ____ tab,in the Queries group.

A database cannot contain more than one saved query.

In a new field definition,the new field's name always appears ____.

You want a query's result to include dates after December 1,2013.What will the properly formatted criteria look like in the query?

In Access,a saved report displays as an object in the ____.

A query cannot contain a calculated result because only tables can contain this type of field.

After a query is run,it can be saved as an object in the database.

In Access,a report is based on a ____.

When you make changes in a query datasheet,the changes are not recorded in the original table.

A join line appears between tables within a query window so you can see the relationship between them.

To insert a picture into an Access report's header,click the ____ button in the Header/Footer group on the DESIGN tab.

A benefit of applying conditional formatting to an Access report is to ____.

A benefit of applying conditional formatting to an Access report is to join tables more easily.

When tables are ____,you are able to construct queries that pull data from more than one table.

A query result is a subset of ____ that meet its criteria.

Queries are used by Access to extract data from a database.

To execute a query,press the red exclamation point icon in the Results group.

When conditional formatting is applied to an Access report field,which of the following statements is true?