Exam 1: Access Lesson 1: Microsoft Access Basics

Case AC 1-1 Jonathan is the IT manager for a Toy Company and is looking into using different types of database objects. The Sales Manager has asked Jonathan to consolidate data from several tables into a format similar to a paper form. In this case, Jonathan would use the ____ object.

A(n) ____________________ is a collection of objects.

To start Access, click the Start button on the taskbar, click ____, click Microsoft Office, and then click Microsoft Access 2010.

In ____, you can rearrange the order of the fields in a datasheet by dragging them to a new location.

Before printing a datasheet, you should view it in ____ so you can check the print settings.

A(n) ____________________ is used to search for and retrieve data from tables using conditions.

A database management system does not need to be computerized.

The ____ object is similar to a macro, but allows more complex programming of database operations.

Backing up a database rearranges how the database is stored on the disk and optimizes the performance of the database.

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. Once Chloe makes the changes in the layout of the datasheet, the edits are saved ____.

Best of class automatically resizes the column to the best width for the data contained in the column.

If you make changes to the layout of a datasheet and try to close the table, Access will ____.

In Datasheet view, the table displays its data in rows and columns in a ____.

When you are navigating in Datasheet view, pressing Shift+Tab ____.

Access combines compacting and repairing into one step.

When resizing a column, selecting ____ automatically resizes the column to the best width for the data contained in the column.

By default, the rows in a datasheet are displayed with ____.

When you open a database, Access assumes that the database might contain something that could damage your computer.

After you delete a record, you can use the Undo command to restore it.

FIGURE AC 1-1 Referring to Figure AC 1-1 above, the word Denver is an example of a ____.