Access XP

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. Word processor

B. Database

C. Spreadsheet

D. Internet browser

Question 3

Which of the following choices appears in the File Menu?

A. Query

B. Print

C. Report

D. Report and Query

Question 4

True or False: In Datasheet view, a table is presented as a grid of columns and rows.

A. True

B. False

Question 5

A field that uniquely identifies a particular record in a table is called a ________.

A. foreign key

B. house key

C. secondary key

D. primary key

Question 6

A database is __________.

A. the same as a file

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

C. used to make flyers

D. a hard drive on a computer

Question 7

To add a record to a table that already contains data, open the table and click ________.

A. Add Record

D. New Record

C. Append Record

D. Insert Record

Question 8

A record in Access is composed of a ________.

A. series of databases

B. series of files

C. series of records

D. series of fields

Question 9

Use a(n) _________ to list only certain records in a table.

A. list

B. answer

C. question

D. query

Question 10

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

A. Search

C. Find

A. Find

D. Query

Question 11

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 12

A report is run instead of a query when ______.

A. you want a formatted and visually appealing printout

B. the table contains more than 10 records

C. you want to delete records from a table

D. a query has not been created

Question 13

True or False: A sort and a query perform the same function.

A. True

B. False

Question 14

A database wizard is used to ______.

A. create a new database

B. add records to an existing table

C. create a new table in an existing database

D. fly Dorothy home from the land of Oz

Question 15

Which of the following is NOT a database object?

A. table

B. query

C. report

D. record

Question 16

True or False: Records can be added to a table using either the Datasheet view or the Form view.

A. True

B. False

Question 17

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

A. True

B. False

Question 18

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

A. False

B. True

Question 19

A table record can be displayed ______.

A. by selecting a record from the File menu

B. by selecting a record from the Edit menu

C. by selecting a record from the View menu

D. by selecting a table in Datasheet view

Answers:

1) A. True
2) B. Database
3) B. Print
4) A. True
5) D. primary key
6) B. a collection of information that can be managed and shared with other tables and databases
7) D. New Record
8) D. series of fields
9) D. query
10) A. Find
11) B. False
12) A. you want a formatted and visually appealing printout
13) B. False
14) A. create a new database
15) D. record
16) A. True
17) B. False
18) A. False
19) D. by selecting a table in Datasheet view