Access Advanced

Who should attend

IT professionals, data analysts, database users and coordinators, managers and directors, and anyone who uses Access!
Knowledge of Access Introduction & Intermediate concepts preferred.
Team Pass by Learnit

Access Advanced

From $0
Two, 2-hour Modules (9am - 11:30am PT)

In our Access training courses, students will learn how to take control of their data with software training at Learnit. Our courses will teach you basic to advanced features of Access.

Whether you are new to Access or an advanced user, our Access training courses will cover what you need to know as efficiently as possible. Learnit offers world-class training for several versions, including 2016, 2013, 2010, 2007 and earlier.

Learning Outcomes: 

    • Advanced Form Design Techniques 
      • Using Switchboards to Navigate Database Objects 
        • Designing Macros to Automate Database Tasks 
          • Introduction into Access Visual Basic for Complex Automation 
            • Linking Tables to Ensure Database Security 
              • Customizing Database Options 
              Course ID
              ACCESSYlrW
              Available times
              June 17 & June 18, 2021
              9:00am-11:30am
              June 17 & June 18, 2021
              9:00am-11:30am
              June 17 & June 18, 2021
              9:00am-11:30am
              June 17 & June 18, 2021
              9:00am-11:30am
              June 17, 2021
              9:00am-11:30am
              June 17, 2021
              9:00am-11:30am
              June 17, 2021
              9:00am-11:30am
              June 17, 2021
              9:00am-11:30am
              June 17, 2021
              9:00am-11:30am

              Course Outline

              Module 5

              Advanced Form Design Techniques 

              • Designing Complex Forms 
              • Creating “Keystroke-less” field controls 
              • Adding Buttons and Drop-Down Lists for Navigation 

              Using Switchboards (Menus) to Navigate Database Objects 

              • Create a Main Switchboard 
              • Design a Reports Switchboard 

              Designing Macros to Automate Database Tasks 

              • Create Macros to Open and Close Database Objects 
              • Using Message Boxes to Inform Users 
              • Automate Parameter Queries with Macros 
              • View Related Records in Another Form with Macros 
              • Hiding/Un-Hiding Field Controls with Macros 
              • Use Macros to Validate Data Entry 

              Introduction into Access Visual Basic for Complex Automation 

              • Use Visual Basic to Secure Forms with Passwords 
              • Create User Input Boxes 
              • Use Logic Programming to Interpret Conditions 

              Module 6

              Linking Tables to Ensure Database Security 

              • Place Tables in a Separate Database 
              • Manage Tables with the Linked Table Manager 

              Customizing Database Options 

              • Set Startup Options 
              • Applying the Compact and Repair Tool 

              Skills covered

              No items found.

              Access Advanced

              Reviews

              Coming soon