Access Training:
in Los Angeles or Online
MS Access is the de facto standard database for everything from business to non-profit to personal use. It allows you to store data in tables with millions of rows. It provides features to retrieve portions of the data in queries and output that data in formatted reports.
Access Fundamentals
The fundamentals class provides you with the knowlegde to create new databases, fill them with data, and provide user-friendly tools such as forms and reports. In this class you will learn how to:
- 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 13 hours.
In-Person Training:
No classes scheduled. Get a quote for private training.
Online Live Training:
Oct 28 9am - 4pm day - register
Access Intermediate
Continuing from the topics in the fundamentals class, the intermediate level provides training in the most popular features of MS Access, beyond 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 13 hours.
In-Person Training:
No classes scheduled. Get a quote for private training.
Online Live Training:
Nov 4 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:
Nov 12 9am - 4pm day - register
Microsoft Access Training Reviews:
Rated 4.6/5 based on 62 student reviews.
We covered the basics and it fulfilled my expectations. I am ready for more.
- Balarko Banerjee
It was incredibly helpful! The instructor is fun and animated and makes the material very interesting. I feel like I now have a good grasp of the basics of making an access database.
- Brandice Brenning, Department of Veterans Affairs, North Hills, CA
It was a very good training. The pace was nice and didn't spend time on things that wasn't needed. I learned a lot and will be able to go back to work and make an impression with my new access skills!
- Breanna Ruelas, Spreckels Sugar, Brawley
Great tempo. The instructor was very open to questions, and was a great help relating what we were learning to our current job.
- Ciana Chastain, iPayment, Inc., Westlake Village
Very professional and very informative. Would be very helpful to all that I work with.
- Greg Manuel, ExxonMobil, Goleta
Very good. I liked the flexibility with the small class size to address tools that help my specific needs
- Harvey Les, Lakeside Medical, Northridge
It was awesome! I wish I had taken the class earlier. It was a great learning experience and I look forward to applying the information learned.
- Katriana Baker, Dept of VA, North Hills
The training great. The instructor was an excellent trainer. I learned many things that will assist with my daily work.
- LaTaisha Ford, Manufacturers Bank, Los Angeles