Microsoft access training

MICROSOFT
ACCESS
COURSES

GET A QUOTE

Manage Data Properly with Professional Training

Access is a powerful and flexible database program that can fill many needs that might otherwise require a custom program. While the program is easy to use, the sheer functionality means it has a steep learning curve for novices.  Our courses take you from the very basics to creating a custom application in Access.

Training takes place at your office – in your meeting room, on the dates that work best for your team.  We can also bring in laptops for the course.

2 days of training at your office, reference manuals and 30 days of technical support

Whether you want to create you own simple database, or learn how to use one created by someone else, this is the course for you.

This two‑day course will teach you all the very basics from entering data, to extracting information, creating forms and producing beautiful printed reports.

Course Prerequisites: because database programs are more complex than most other programs, you should already be using at least one other program before taking this course. (Excel or Word or PowerPoint, etc.)

What you will learn:

  • What is a Database?
  • Database Objects in Access
  • Creating / Opening Databases
  • Creating Tables 
  • Creating Queries
  • The Forms Wizard
  • The Report Wizard
  • Working in the Navigation Pane

Full Course Outline

3 days of training at your office, reference manuals and 30 days of technical support

This three‑day course builds upon your basic Access knowledge by giving you the skills to properly create a powerful, flexible database.

Learn how to use multiple related tables (essential for almost any database) and create your own relational database. You will also learn how combine information from multiple tables, how forms are affected by multiple tables, and use sophisticated form and report tools to completely customize your database. Course Prerequisites: solid understanding of all Level 1 topics.

What you will learn:

  • Relating Tables and Referential Integrity
  • Creating Forms from Scratch
  • Creating Reports from Scratch

Full Course Outline

3 days of training at your office, reference manuals and 30 days of technical support

Take the final step from functional databases to completely automated ones. Dip your toes into the powerful VBA Language (Visual Basic for Applications) that makes it all possible by letting you automate almost any task with a single click.

Course Prerequisites: You should be very comfortable with the Level 2 topics.

What you will learn:

  • Built-In Functions
  • Compact & Repair
  • Setting Default Program & Database Options
  • Importing & Exporting Data
  • Writing VBA to Automate Tasks

Full Course Outline

1 or more days of training at your office, reference manuals and 30 days of technical support

Our build‑your‑own‑course program provides the ultimate level of flexibility to ensure your team gets the most out of their training. Simply mix‑and‑match any of the topics listed in our Master Topic List and send us your list. We will work with you to ensure the material will fit into a single day of training.

Every “build-your-own-course” includes a customized reference manual for each person featuring your topics, and the same 30 days of technical support as our standard offerings.

Master Topic List (PDF)

Access vs Excel

Why Access is the Best Database Product

Access might be the most underutilized product in the Microsoft suite. “Why learn Access, when I already know Excel?“

Most Excel users already know what a database is – they are creating spreadsheets in Excel that are databases.  Do you find that you have large amounts of data you are trying to manage? Is it getting too complicated?

Setting up a database in Access instead of Excel will save endless hours of working with spreadsheet data to get results. The beauty of Access is that once the setup is done, you don’t spend any of your time manipulating data – you can just click a button and print your report!

No time to learn Access?

We can create your database for you. Learn more >

Basic computer course

Choose The Company With 30 Years Of Experience & Top Industry Instructors

At Gump Training, our instructors are all career professionals with extensive corporate training experience. We pride ourselves on having the best instructors in the industry and our loyal clients are proof that our training solutions work. That's why we’re still here after 30 years.

Our Professional Instructors Are
Dedicated To Helping Your Team Succeed

Get Started With Our Training Assessment

Ensure you choose the right course for your team by using our free Access training assessment. This fillable form will show you what each person already knows in Access and the features they would like to learn more about. We can evaluate the results and work with you to select the right standard course level, or build the right custom course for your team. All at no charge.

What Our Customers Are Saying

Frequently Asked Questions

A private meeting room with enough space for each person attending and a TV or Projector for the Instructor to use. Some classes also require connection to the internet.
The ideal class size is up to 10 people. We can teach as many as 15, but more than that is simply too many people to provide enough personal attention. Also, as the class size increases, the amount of material that can be covered decreases. We cover topics at the pace of the group – we never leave anyone behind.
Yes! This is essential. To be successful, the training session must be hands-on, with no computer sharing. If you do not have enough (or any) computers available for training, we can bring in laptops for a fee of $ 50 /ea.
Yes. Our “build your own” course program is an entirely new approach to customized training. Simply send us your list of topics or choose from our ‘Master List’ and we will work with you to create a full‑day course that matches your team’s exact needs. Each “build your own” course also includes custom reference manuals tailored to your specific curriculum.
Yes. We offer discounts for groups of 6 or more and for multiple training days. Please contact us for details.
No, we do not have training facilities. Training takes place at your office, in your company meeting room.
We do not have a training center location. Our Instructors travel to you to teach your team at your office – anywhere in the GTA and most places in Southern Ontario.
Yes. We are a corporate training company. We provide training to both private and public sector organizations.
Since we bring the training to you, we do not have pre-set dates. The dates are completely up to you.
Most standard courses are a full day in length, from 9am to 4pm (6 hours of training). For custom training, the course length is up to you; however, our minimum rate is a full day. If you are looking for courses that are less than a full day, we can run multiple classes in a single day – e.g. two half-day classes, or three two-hour classes, etc.

Gain Confidence In Your Technology