Access Training:
Live Online

Microsoft Access is a database management system included in the suite of MS Office applications. It can store millions of rows of data in tables which you and your colleagues can query efficiently. Entering data is done in user-friendly forms and printed output can be formatted in reports.



 

Access Fundamentals

The introductory class in MS Access covers the basics: navigating the interface, understanding how data is stored in tables, rows, and cells. We then get into entering data using forms and querying that data using MS Access's "query builder"; finally, we cover how to output that data into nicely formatted "reports." Topics include:

  • Introduction into How Databases Operate
  • Learning the Access Interface
  • Creating A New Database
  • Designing and Creating New Tables
  • Entering Data into Tables
  • Sorting and Filtering Data
  • Introduction into Relating Table Data
  • Create Commonly Used Queries
  • Customizing Queries with Criteria
  • Using Forms for Data Entry
  • Create Reports for Data Output
  • and many more topics... See full outline for Access Fundamentals training.
REGISTER:
Price:  $290 for 12 hours.
In-Person Training:
        No classes scheduled. Get a quote for private training.
Online Live Training:
        Feb 22           9am - 4pm  day - register
        Apr 24           9am - 4pm  day - register
        Jun 21           9am - 4pm  day - register

 

Access Intermediate

The intermediate-level class covers the features you will most need once you've mastered the basics. Topics include:

  • How Table Relationships Affect Queries
  • Controlling Query Results with Join Types
  • Creating Complex Queries with Multiple Criteria
  • Calculating Data with Queries
  • Automating Queries with Parameters
  • Using Query Wizards
  • Exploring Action Queries
  • Advanced Report Design Techniques
  • and much more! See full outline for Access Intermediate training
REGISTER:
Price:  $290 for 12 hours.
In-Person Training:
        No classes scheduled. Get a quote for private training.
Online Live Training:
        Feb 23           9am - 4pm  day - register
        Apr 25           9am - 4pm  day - register
        Jun 22           9am - 4pm  day - register


 

Access Advanced

Continuing from the topics in the intermediate class, the advanced level covers expert topics, such as:

  • 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
  • and much more! See full outline for Access Advanced training
REGISTER:
Price:  $290 for 6 hours.
In-Person Training:
        No classes scheduled. Get a quote for private training.
Online Live Training:
        Feb 24           9am - 4pm  day - register
        Apr 26           9am - 4pm  day - register
        Jun 23           9am - 4pm  day - register


Access Fundamentals Training Reviews:

4.5/5 review stars
Rated 4.5/5 based on 32 student reviews.

I really learned a lot of information. Instructor answered all our questions and took the time to customize to our work needs.
- Rhonda Cormier

A lot of information, very useful,
- Leilani Quesada

Awesome!
- Kim Bruynell, SHC

Fantastic class. Great pace.
- Julie

Was able to cover a lot of topics. Exceeded expectations for a fundamentals class.
- Loraine Lee

Fun! He was very interactive and used a lot of our feedback to provide in-class examples. The pace was really good and the class definitely was informative... not boring at all.
- Charet Wynn

Great. Teacher was very helpful and answered all questions.
- Student

Fantastic. Instructor was a great, perceptive trainer. I love the dual screens (watching her screen in addition to my screen.) The book was very helpful as a takeaway along with the files. I feel armed to start using the product.
- Debbie Mullin