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
Made with FlippingBook - Online magazine maker