Access Advanced – Standard – Full Day

$ 285.00

Class Duration: 7 Hours

Class Agenda

Morning Session 3 Hours
Lunch 1 Hour
Afternoon Session 3 Hours
Other Breaks Prescribed by Instructor

In our Access training courses, students will learn how to take control of their data. This course will teach the advanced features of Access.

  • 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 
  • Designing Complex Forms 
  • Creating “Keystroke-less” field controls 
  • Adding Buttons and Drop-Down Lists for Navigation
  • Create a Main Switchboard 
  • Design a Reports Switchboard 
  • 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 
  • Use Visual Basic to Secure Forms with Passwords 
  • Create User Input Boxes 
  • Use Logic Programming to Interpret Conditions
  • Place Tables in a Separate Database 
  • Manage Tables with the Linked Table Manager 
  • Set Startup Options 
  • Applying the Compact and Repair Tool
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

The ability to work with and analyze data is critical to the success of your organization. For decades, Microsoft Excel has been the go-to application for doing so. Begin adding it to your professional skill set with our foundational Excel course. You will learn to navigate the application confidently while creating and developing worksheets and workbooks that employ the most popular features Excel has to offer.

DETAILED COURSE OUTLINE

Getting Started with Access

Working with Table Data

Querying a Database

Using Forms

Generating Reports

“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

Event Details

Phone: (602)252-3955

Email: registration@trainingtoyou.com

Scroll to Top