Deck 70: Queries and Reports

Question 1

A database cannot contain more than one saved query.

Answer 1

False

Question 2

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

A) HOME
B) CREATE
C) REPORTS & QUERIES
D) DATABASE TOOLS

Answer 2

B

Question 3

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

Answer 3

True

Question 4

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

A) join tables more easily
B) bring attention to specific report details
C) organize your report data more efficiently
D) build a more efficient report design grid

Question 5

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

A) records
B) tables
C) fields
D) databases

Question 6

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

A) The cell's contents can be displayed in bold red font.
B) The cell can be formatted with a new image.
C) The cell's contents can be recalculated.
D) The column or row is sorted.

Question 7

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

Question 8

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

A) >12/1/2013
B) =>#12/1/2013#
C) >#12/1/2013#
D) #12/1/2013#

Question 9

In Access,a report is based on a ____.

A) form
B) record
C) table
D) spreadsheet

Question 10

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

Question 11

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

Question 12

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

A) recorded
B) queried
C) joined
D) constructed

Question 13

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

Question 14

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

A) Image
B) Logo
C) Title
D) Picture

Question 15

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

A) to the left of the colon
B) to the right of the colon
C) before the greater than sign
D) after the greater than sign

Question 16

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

Question 17

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

A) table
B) Reports window
C) Builder pane
D) Navigation pane

Question 18

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