Exam 1: Access Lesson 1: Microsoft Access Basics

When you change the row height of a datasheet, the change ____.

The database object called Macro displays data from one or more tables or queries in a format that might be similar in appearance to a paper form.

FIGURE AC 1-1 Referring to Figure AC 1-1 above, if you sorted the database on Last Name, you would be sorting on a ____.

A record is an incomplete set of data.

You can print a datasheet by clicking the File tab, clicking Print in the navigation bar, and then clicking ____ to print the datasheet using the default printer and the default print.

____ is a program known as a database management system (DBMS).

If you copy an entire record and want to paste it into a table as a new record, use the ____ command.

Each object has a different ____________________ to identify its function.

Access opens in ____ view.

You can close Access by clicking the Close button on the ____.

The database object called query stores all the data in the database in a format called a datasheet.

You can select all of the records in a table by clicking the ____________________, which is the box in the upper-left corner of a datasheet.

Case AC 1-2 Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Chloe needs to move the second column so it becomes the first column. To do this efficiently, Chloe will ____.

After opening a database, the Navigation Pane opens on the left side of the screen.

The Cut, Copy, and Paste commands in Access work the same way as they do in other Office programs.

When you enter an improper field value, a(n) ____ message appears and tells you what to do to correct your mistake.

Access is a DBBS program.

You can change the colors used in the rows of the datasheet by clicking the arrow on the Alternate Row Color button in the Text Formatting group on the ____________________ tab.

Imagine that you are a Sales Manager at a Toy Company, and give an example of a business situation where you would use each of these database objects: query, report, and macro.