Access 2010

Quiz

Question 1

A database that understands how information is connected is called __________.

A. a connected database

B. a linked database

C. an Access database

D. a relational database

Question 2

Which of the following is a complete list of the Access objects?

A. Tables, forms, queries

B. Queries, reports, forms

C. Records, queries, reports, forms

D. Tables, forms, queries, reports

E. Records, tables, forms, queries, reports

Question 3

The __________ is a list containing every object in your database.

A. Document Tabs bar

B. Navigation pane

C. Objects pane

D. Ribbon

Question 4

Open objects are listed in the __________.

A. Fields pane

B. Document Tabs bar

Question 5

In Access, rows are referred to as __________, and columns are referred to as __________.

A. lines, columns

B. records, fields

C. fields, records

D. objects, types

Question 6

__________ allow you to enter data without typing records directly into tables.

A. Menus

B. Queries

C. Forms

D. Reports

Question 7

When you sort records in A-Z order, you are applying a(n) __________ sort.

A. ascending

B. descending

C. filtered

Question 8

When you build a query, you must write __________ to tell the query which records to retrieve.

A. terms

B. criteria

C. functions

D. tables

Question 9

A __________ query allows you to perform calculations with your data.

A. mathematical

B. sum

C. totals

D. calculator

Question 10

It's possible to build reports with information from __________.

A. tables

B. queries

C. both tables and queries

Question 11

Open objects are listed in the __________.

C. Navigation bar

D. Ribbon

Question 12

When you select a new theme, it applies to __________.

A. just the current object

B. the entire database

Question 13

Setting the __________ for a field sets a rule about how many letters, numbers, punctuation marks, or spaces can be entered in a field.

A. data rule

B. character limit

C. row height

D. validation rule

Question 14

A __________ is a drop-down list you can add to your form.

A. text box

B. list box

C. combo box

D. drop-down box

Answers:

1) D. a relational database
2) D. Tables, forms, queries, reports
3) B. Navigation pane
4) B. Document Tabs bar
5) B. records, fields
6) C. Forms
7) A. ascending
8) B. criteria
9) C. totals
10) C. both tables and queries
12) B. the entire database
13) B. character limit
14) C. combo box