Access Training:
in San Diego or 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:

  • Design an Access database which is best suited to your business needs.
  • Confidently navigate Microsoft Office's "Ribbon" interface and help menus.
  • Harness existing templates to avoid unnecessary duplication of effort.
  • Implement logical naming conventions to make your database "tables" and "fields" easier for others to use.
  • Add captions to provide extra information useful for data entry.
  • Create validation rules and input masks for searchable and accurate records.
  • Employ "wildcards" to generate meaningful results on even the most difficult searches.
  • Use the Query Wizard to retrieve and display a set of database records based on any number of criteria.
  • Perform global updates and calculations on multiple database records simultaneously.
  • Build custom reports which powerfully communicate the data and support business decision making.
  • and many more topics... See full outline for Access Fundamentals training.
REGISTER:
Price:  $695 for 12 hours.
In-Person Training:
        No classes scheduled. Get a quote for private training.
Online Live Training:
        Jul 7 and 8      9am - 4pm  day - register
        Sep 8 to 9       9am - 4pm  day - register
        Nov 15 to 16     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:

  • Database Relationships
  • Working With Tables
  • Working With Queries
  • Working With Forms
  • Working With Reports
  • and much more! See full outline for Access Intermediate training
REGISTER:
Price:  $695 for 12 hours.
In-Person Training:
        No classes scheduled. Get a quote for private training.

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