Microsoft Access On-site Training Courses
Learn from the Access Experts
Looking for the best Microsoft Access training available? Our team at IT Impact, Inc. offers Microsoft Access on-site training designed to meet your company’s skill level—Introductory, Intermediate, and Advanced. Delivered by Access MVPs and expert trainers, our programs are ideal for businesses looking to empower their staff and make the most of their database systems.
What Is Microsoft Access and Why Use It?
Microsoft Access is a powerful database application that allows teams to manage, retrieve, and report on data with speed and flexibility. When paired with expert training, it can help streamline business operations and boost productivity—no matter your industry.
Our Microsoft Access training gives users the skills to handle databases confidently, avoid common pitfalls, and “Discover the power of your data™.”
What’s Included in Each Course?
Taught by Microsoft Access MVP Juan Soto, each on-site course runs for three days and can be customized to fit your team’s needs. Whether your goal is to optimize existing systems or learn how to link with SQL Server, we equip your team with practical, real-world skills they can use immediately.
Sample Microsoft Access On-site Training Syllabus
We offer a three-day Microsoft Access training course for each skill level: Introductory, Intermediate, and Advanced. Each syllabus can be tailored based on your team’s experience and your organization’s database environment. Below is a sample outline of what each course typically includes.
Introductory Class
Day 1
- Design tips for SQL Server tables
- What is the ONE field type every table should have?
- Where NOT to add a new field in a table
- Linking to SQL Server Databases using DSNs
- How to create DSNs
- How to refresh DSN links after changes to a table in SQL Server
- Tips and tricks to filtering data in the data grid. (Hint: Use the force, I mean the right-click)
- Creating native tables in Access, do’s and don’ts
- Creating Forms using the wizard
- Adding objects to your forms using wizards: List boxes, combos and command buttons
- Adding subforms
Day 2
- Reports
- Creating reports using the wizard
- Adding groups
- Adding subtotals
- Adding Filters
- Adding subreports
- Queries
- Know the answer before asking the question
- Using the query wizard
- Creating left, right and outer joins
- Creating group by queries
- Creating calculated columns
Day 3
- Importing data into Access
- Excel imports
- CSV imports
- Cleaning data using queries
- Adding data from imports into other tables (Insert Queries)
- Creating import specifications and saving them
- Linking vs. importing Excel data
Intermediate Class
Day 1
- Designing SQL Server Tables for Access
- Adding indexes to tables
- Creating views in SQL Server
- Do’s and don’ts for using views in Access
- You can’t edit data using views in Access, or can you?
- To delete or not delete?
- Do’s and don’ts for using views in Access
- Forms
- Adding controls and programming command objects
- Launching forms with where clauses
- Advanced combos and list controls
Day 2
- Reports
- Launching reports with where clauses
- Sub reports
- Queries
- Creating a house of cards (using multiple queries together)
- SQL mode vs. QBE or in other words, doing it the hard vs. easy way
- Why we don’t bother with hybrid queries, unless you need a coffee break
Day 3
- Importing data from Excel
- Creating a program to clean imported data
- Exporting to other formats
- Querying SQL Server data from Excel (yes, no need for Access)
Advanced Class
Day 1
- TSQL Primer
- Query Optimisation
- Creating SQL Server procedures – use table variables or temp tables, that is the question
- Invoking SQL Server Procedures using Access pass through queries
- Changing Access queries SQL on the fly with code
- Server Processing vs Doing it in Access
Day 2
- Form object model
- Controls Collection
- Iterating through controls
- TableDefs Collection
- Form recordsets
- Using the bookmark property
- Using queries in your code with recordsets – the easy way
- TempVars
- Proper coding conventions
- Functions vs Subroutines
- ByVal or ref?
Day 3
- Creating a menu system in Access
- Invoking forms from other forms
- Reading data from one form to another
- Advanced Importing Techniques
- Excel Querying
Total Costs: $5,640 + expenses
Frequently Asked Questions
Ready to Train Your Team with the Best Microsoft Access Course?
Book an on-site training session with an Access MVP and level up your team’s skills with hands-on, expert-led instruction.
Call 773-809-5456 or contact us online to schedule your on-site Access training today.
