Access 2003

Quiz

Question 1

True or False: A table is made up of several records.

A. True

B. False

Question 2

Microsoft Access is what type of program?

A. Spreadsheet

B. Word processor

C. Database

D. Internet browser

Question 3

True or False: A query lets you find and retrieve information from only one table.

A. True

B. False

Question 4

True or False: Columns or fields in a table cannot be moved.

A. True

B. False

Question 5

True or False: A table in a database cannot be related to another table in the same database.

A. True

B. False

Question 6

A primary key is:

A. a field that uniquely identifies a particular record in a table

B. the mechanism by which you relate different tables and combine information for viewing or printing

C. both A and B

D. neither A nor B

Question 7

A database is __________

A. a collection of information that can be managed and shared with other tables and databases

B. the same thing as a file

C. the same thing as the hard drive on your computer

D. the same thing as a primary key

Question 8

A record in Access is composed of ________.

A. a series of databases

B. a series of fields

C. a series of keys

D. several Word files

Question 9

A database wizard is used to ______.

A. create a new database

B. add records to an existing database

C. create a new record in an existing database

D. assist the primary key in opening the needed files

Question 10

Which of the following is not a database object?

A. Tables

B. Queries

C. Reports

D. Records

Question 11

True or False: A record cannot be changed after it has been added to a table.

A. True

B. False

Question 12

True or False: A table record cannot be edited in Datasheet view.

A. True

B. False

Question 13

A table record can be displayed ______.

A. by selecting a record from the Edit menu

B. by selecting a record from the File menu

C. by selecting a record from the View menu

D. by selecting a table in Datasheet view

Question 14

Records can be added to a table using ______________.

A. only the Datasheet view

B. only the Form view

C. neither A nor B

D. both A and B

Question 15

The status area has all of the following buttons EXCEPT:

A. First record

B. Next record

C. All records

D. New record

Question 16

Sorting is ________________.

A. a method that helps you locate information quickly in a database

B. the same thing as performing a query

C. neither A nor B

D. both A and B

Question 17

A report is run instead of a query when ______.

A. a query has not been created

B. the table contains more than 10 records

C. you want a formatted and visually appealing printout

D. you want to delete records from a table

Question 18

True or False: A Filter by Selection is used when you do not want to use a specific criterion in a filter.

A. True

B. False

Question 19

To search for a specific record in a table, select the field to search and then click the ______ button on the toolbar.

A. Find

B. Search

C. Locate

D. Query

Answers:

1) A. True
2) C. Database
3) B. False
4) B. False
5) B. False
6) C. both A and B
7) A. a collection of information that can be managed and shared with other tables and databases
8) B. a series of fields
9) A. create a new database
10) D. Records
11) B. False
12) B. False
13) D. by selecting a table in Datasheet view
14) D. both A and B
15) C. All records
16) A. a method that helps you locate information quickly in a database
17) C. you want a formatted and visually appealing printout
18) B. False
19) A. Find