Access 2016 Advanced

Encrypting a Database with a Password.................................................................96 Opening and Decrypting a Database......................................................................98 Removing a Database Password.............................................................................99 Exercise.................................................................................................................101 CREATING MACROS ................................................................... 103 Working with Macros ...........................................................................................104 Opening the Macro designer Window .................................................................104 Creating a Macro ..................................................................................................106 Saving a Macro .....................................................................................................111 Using Single Step Mode for Testing......................................................................113 Running a Macro ..................................................................................................115 Editing an Existing Macro .....................................................................................116 Exercise.................................................................................................................118 USING MACROS ......................................................................... 119 Using Properties ...................................................................................................120 Creating Embedded Macros .................................................................................120 Assigning a Macro to a Control ............................................................................122 Creating a Command Button ................................................................................125 Adding a Condition to a Macro.............................................................................128 Creating a Group Macro .......................................................................................131 Creating an Autoexec Macro ................................................................................134 Exercise.................................................................................................................136 USING SWITCHBOARDS.............................................................. 137 Opening and Using a Switchboard .......................................................................138 Creating a Switchboard Form...............................................................................140 Adding a Command Button to a Switchboard......................................................144 Setting Startup Options ........................................................................................147 Exercise.................................................................................................................150

LESSON 10 -

LESSON 11 -

LESSON 12 -

OFFICEPRO, Inc.

Page v