Exam 11: Access 2007 Unit A: Getting Started With Access 2007

You cannot undo a record deletion operation.

Pressing [Ctrl][;] will insert the current date.

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode.

Which data type is used to sequentially order each record added to a table?

Which is NOT a feature of Access reports?

A(n) ____ is a collection of tables associated with a general topic such as sales of products to customers.

This Access object provides an easy-to-use data entry screen.

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Press this keystroke combination to move focus to the last field of the last record.

The ____________________ View is used to modify and define field properties that are not available in Datasheet View.

The [F2] key switches between Edit and Navigation modes.

The term ____ database comes from the fact that two or more tables are linked by a common field.

Values in an AutoNumber field cannot be edited.

Matt wants to create a record keeping system to track the inventory needed to efficiently run his lawn and landscape business, such as spare parts, gas cans, string trimmers, etc. His crew manager will also be using the system. Matt is considering whether to use Excel or Access. Which one of the following is NOT a benefit of using Access?

An Access database is able to store any number of records up to ____________________ gigabytes.

A(n) ____________________ field automatically assigns a new number each time you add a record.

Field names appear in the top row of a datasheet.

When you move around the fields and records of a datasheet but do not change data, you are working in ____________________ mode.

____________________ software is used to manage data that can be organized into lists of related information such as customers, products, vendors, employees, projects, or sales.

While editing a record, pressing [Esc] a second time ____.