Exam 1: Getting Started With Access

Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. Lauren has written a paragraph describing the use for each inventory item. Which data type should she use to define the field that will store this information?

"Focus" refers to which data you would edit if you started typing.

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

Which Access object contains all of the raw data within the database?

Which keystroke combination moves focus to the last field of the last record?

The ____________________ refers to which data you would edit if you started typing.

Which data type links files created in other programs such as pictures or documents?

Which two properties are required for every field?

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

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

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

You can use the Calendar Box to enter dates in a Date/Time field. _________________________

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator. _________________________

In Navigation mode, press [Tab] or ____ to move to the next field within the same record.

In Access, data entry screens are called forms . _________________________

Which data type stores Web addresses?

Tables contain all of the data in the database.

Which shortcut key moves focus to the previous field of the current record?

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

Each object in an Access database application displays at the left side of the Access window in the ____.