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:
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