[ Team LiB ] Previous Section Next Section

Workshop

The Workshop includes quiz questions that are designed to help you test your understanding of the material covered and activities to help put what you've learned to practice. You can find the answers to the questions in the section immediately following the quiz.

Quiz

1:

Name the four macro columns.

A1:

Macro Name, Action, Condition, and Comment.

2:

Comments that you add to a macro print when you print the macro (True/False).

A2:

True.

3:

You turn the Step feature on and off for each macro in a database (True/False).

A3:

False. The Step feature applies to all databases that you work with in Access (until you toggle it off).

4:

Name the macro that you use to remap keystrokes.

A4:

AutoKeys.

5:

Name the macro that you create when you want something to happen as the user opens the database.

A5:

AutoExec.

Activities

Practice adding four macros to an application that you build. The macros should include the following:

  • An AutoExec macro

  • An AutoKeys macro

  • A macro that contains three named macros that open three different forms

  • A macro that contains a condition

Build a form with command buttons that execute the named macros and the macro containing the condition.

    [ Team LiB ] Previous Section Next Section