Access 2007

Quiz

Question 1

True or False: The Ribbon is Microsoft Access 2007's new menu system.

A. True

B. False

Question 2

To open Access 2007 database objects, you must use the:

A. Navigation pane

B. Quick Access toolbar

C. Ribbon

D. None of the above

Question 3

A table is a collection of:

A. forms

B. queries

C. records

D. reports

Question 4

True or False: When you are entering or editing a record, a pencil icon appears in the active record row.

A. True

B. False

Question 5

To encourage database users to save records, you can include a/an ______________ on the data entry form.

A. toggle button

B. action button

C. combo box

D. list box

Question 6

You add an AutoFormat to a form or report in ________________ view.

A. Datasheet

B. Design

C. Print Preview

D. Layout

Question 7

Access allows you to use or include a sort function in:

A. queries

B. reports

C. tables

D. all of the above

Question 8

An ascending sort lists records:

A. A to Z

B. Z to A

C. Highest to lowest

D. None of the above

Question 9

When you set up a filter, you are telling Access to look for records that match a specific ______________ that you have set.

A. number limit

B. criteria

C. total

D. command

Question 10

An advanced filter is a small query run on ______________.

A. several tables at once

B. only one table

C. several reports at once

D. only one report

Question 11

True or False: You CANNOT modify a query once it has been saved.

A. True

B. False

Question 12

To include an addition function to a query in the Query Design view:

A. Use the Function command

B. Use the Addition command

C. Use the Totals command

D. Use the Sort command

Question 13

To limit the number of records that appear in a report, you must:

A. set the Limit option in Layout view

B. set Page Layout options

C. delete records from your tables

D. set the Return option in the query design

Question 14

Microsoft Access 2007 is a:

A. word processing software package

B. slideshow presentation software package

C. relational database management software package

D. spreadhseet software package

Question 15

When adding fields to a table, which view would you work in?

A. Datasheet view

B. Design view

C. Print view

D. Both A and B

Question 16

In a relationship map, you have a primary key in each table. What is a primary key?

A. A field that is the primary field in its own table, but shows up in another table

B. The second field in each table of a database

C. The first field in each table of the database

D. The last field in each table of the database

Question 17

True or False: Data validation is the process by which Access tests the data that is being entered into the database to make sure it is in an acceptable or valid format.

A. True

B. False

Question 18

Which command allows you to create a drop-down list within a form in Access 2007?

A. Combo Box command

B. Drop-Down command

C. Form command

D. Form Wizard

Question 19

When designing a database in Access, what is the first thing you need to determine in order to begin?

A. The number of tables needed

B. The number of fields needed

C. The name of the tables

D. The purpose of the database

Question 20

A report in Access can be generated using data from:

A. a table

B. a query

C. a table or query

D. none of the above

Question 21

True or False: Company logos can be added to a report in Access.

A. True

B. False

Answers:

1) A. True
2) A. Navigation pane
3) C. records
4) A. True
5) B. action button
6) D. Layout
7) D. all of the above
8) A. A to Z
9) B. criteria
10) B. only one table
11) B. False
12) C. Use the Totals command
13) D. set the Return option in the query design
14) C. relational database management software package
15) D. Both A and B
16) C. The first field in each table of the database
17) A. True
18) A. Combo Box command
19) D. The purpose of the database
20) C. a table or query
21) A. True