Access 2000

Quiz

Question 1

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

A. True

B. False

Question 2

A form:

A. is a graphical user interface used to enter (and view) data

B. usually displays one record at a time

C. can contain blank fields ready for data entry

D. is all of the above

Question 3

To begin working with an existing database in Access, choose the following option from the Microsoft Access dialog box:

A. Open an existing file

B. Access database wizards, pages, and projects

C. Open an existing file

Question 4

True or False: If you close the Microsoft Access dialog box, you can open an existing file by clicking the Open button on the toolbar.

A. True

B. False

Question 5

The Object palette (featured in the database window) features all of the following database objects EXCEPT:

B. reports

B. favorites

C. forms

D. reports

Question 6

To open an existing database object like a table or form, ALL of the following are methods EXCEPT:

A. selecting and clicking the Open button in the database window

B. single-clicking it

C. right-clicking and choosing Open from the shortcut menu.

D. single-clicking it

Question 7

True or False: Use the status area or keyboard when navigating a table or form records.

A. True

B. False

Question 8

True or False: Editing data in an Access 2000 table or form is different from editing in other Office 2000 applications.

A. True

B. False

Question 9

True or False: In Access, deleting records can be “undone” by using the Undo feature.

A. True

B. False

Question 10

Sorting records is one method of finding information in a database. It's best to sort records in Datasheet view. Why?

A. You can add, edit, and view data more easily

B. You can check spelling and print the table data easily

C. You can filter or sort records, change how the datasheet is displayed, and change the table structure by adding or deleting columns

D. All of the above

Question 11

True or False: When sorting, you can choose Ascending or Descending sort order.

A. True

B. False

Question 12

A filter is a technique that lets you view and work with a subset of data. Applying a filter to an Access table or form:

A. permanently hides records that don't meet search criteria

B. temporarily hides records that don't meet search criteria

C. places filtered records at the top of a set of records

D. does none of the above

Question 13

A query is:

A. a table made up of several records

B. a record made up of several fields

C. data resulting from questions you ask of one or more tables or queries

D. a graphical user interface used to enter (and view) data

Question 14

True or False: To print any part of an Access 2000 database, you must create a report.

A. True

B. False

Question 15

A report:

A. presents data (stored in tables) in a formatted, organized summary suitable for printing

B. is in a format completely unsuitable for printing

C. is in a format completely unsuitable for printing

D. is none of the above

Question 16

When deleting a table or form record:

A. no delete confirmation message appears

B. No delete confirmation message appears

C. More than one delete confirmation message appears

Question 17

Datasheet View looks somewhat like a:

A. form

B. spreadsheet

C. Word document

D. spreadsheet

Question 18

The status area indicates:

A. a message stating a form record is about to be added

B. a message stating a table record is about to be deleted

C. a message stating a form record is about to be added

D. a message stating a form record is about to be edited

Answers:

1) A. True
2) D. is all of the above
3) C. Open an existing file
4) A. True
5) B. favorites
6) D. single-clicking it
7) A. True
8) B. False
9) B. False
10) D. All of the above
11) A. True
12) B. temporarily hides records that don't meet search criteria
13) C. data resulting from questions you ask of one or more tables or queries
14) B. False
15) A. presents data (stored in tables) in a formatted, organized summary suitable for printing
16) A. no delete confirmation message appears
17) D. spreadsheet
18) A. a message stating a form record is about to be added