Exam 1: Microsoft Access Basics

Code refers to the syntax used in VBA.

When viewing a table in Design view, the field names and data types appear in the ____ in the top half of the Table window.

When creating an append query, you place the mouse pointer over the first field in the highlighted fields, press and hold down the mouse button, and drag them to ____ in the query design grid.

You can only encrypt a database with a password if the database is opened in the Read-Only mode.

Queries that are based on more than one table are sometimes called ____ queries.

When you save database data in another file format, you ____________________ the data from the database.

AC Adv Case 13-2 John has written a VBA program that uses the following IF statement. He tests the program and the IF statement is not working as expected, so he asks for your help. 'This If statement checks for an empty input value 'Then it divides 100 by that value If IsEmpty(divisor) then 'Input field has a value so continue result = 100 / divisor End If John wants to display an error message if there is no input value. You suggest that John ____.

When you use the data in a workbook to add records to a database table, the columns in the worksheet ____.

When you need to find and replace data, click the ____ button in the Find group on the Home tab. The Find and Replace dialog box opens with the Replace tab activated.

In a one-to-many relationship, one record in the first table (called the ____ table) can match many records in the second table (called the related table).

Most word processors, including Word, can open files with the .rtf file name extension.

To set a table's primary key, click the Primary Key button in the Tools group on the Home tab.

____ add efficiency to the data entry process.

To run a macro means to have it perform a(n) ____, automated task.

A(n) ____________________ is a graphic or picture that can be placed in a form.

Describe when to use a summary report and briefly describe the possible functions. Include a discussion on how to create a summary report.

Sorting a field in ____________________ order arranges records from A to Z, or smallest to largest.

When you run a macro, Access performs the actions listed in the Macro window in alphabetical order.