Access Unit Objective Test

A database can best be described as a(n)

• type of software

• process used to deliver information to a

  user.

• organized collection of related data.

• collection of related fields.

Microsoft Access uses an object called a _____ to enter and organize data

• table

• report

• cell

• Spreadsheet

A collection of related _____ makes up a record

• reports

• fields

• tables

• Forms

Which of the following objects would not be listed in the Navigation pane when you open an Access database?

• tables

• forms

• documents

• Queries

When entering data in a table or form, use the _____ key to move to the next field

• Tab

• Backspace

• Down Arrow

• Up Arrow

What is the best way to arrange database information in alphabetical order?

• filter it

• sort it

• alphabetize it manually

• query it

Suppose that you have a customer table containing a field called State. If you click the first record in the State column and then click the Align Left button in the Text Formatting group on the Home tab the formatting be applied to

• only the State column in the first record

• the State column in all the records

• all columns in all records

• all columns in the first record.

Which of the following is not an Access database field type?

• AutoNumber

• Date/Time

• Formula

• Currency

Which field type automatically stores a number that is one greater than the last

number used?

• AutoNumber

• Number

• OneMore

• AddOne

Which of the following Access objects provides a user-friendly data entry method?

• report

• form

• table

• Query