Cfa #2 3Rd

Front 1

. Which Access 2010 feature provides onscreen notes containing the name of the
command, available keyboard shortcuts, a
description of the command, and directions
for getting help using the command?

Back 1

Enhanced ScreenTip

Front 2

What is drawn between two tables in the
Query Design View to illustrate matching
fields and indicate that the tables are
related?

Back 2

Join Line

Front 3

Which Ribbon contains the command to
add specialized items such as a date and
time to a form header?

Back 3

Form Layout Tools Deisgn Ribbon

Front 4

When data is created in Excel 2010 for
import to Access 2010, which format is the
data stored in so that the first row contains
column headings describing the data in
each of the columns and the remaining
rows contain the data?

Back 4

Excel List

Front 5

What is NOT a modification that is applied
to a report's layout?

Back 5

Setting up the report to print in landscape
format.

Front 6

Which is NOT one of the three basic parts
of the report?

Back 6

Page border

Front 7

Which Query type is flexible and prompts
the user for input whenever it is used?

Back 7

Parameter

Front 8

What provides a printable map of how
database tables are related?

Back 8

Relationship Report

Front 9

When a report is collapsed on all levels to
display only the group subtotals, what type
of report is created?

Back 9

Summary

Front 10

In a table, which is a way of exclusively
identifying each record in the database?

Back 10

Unique identifier

Front 11

Which Group on the Report Layout Tools
Design Ribbon contains the command to
include an automatic calculation on a
Report?

Back 11

Grouping & Tools

Front 12

. Which type of database object is typically
used to print data for a presentation?

Back 12

Report

Front 13

Which Ribbon contains the commands to
remove, add, or resize columns in a
Report?

Back 13

Report Layout Tools Design

Front 14

Which type of function performs
mathematical functions on a group of
records such as MAX, MIN, or COUNT?

Back 14

Aggregate

Front 15

Which view allows a user to specify fields,
criteria, sorting, and calculations when
creating a Query?

Back 15

Design