(888) 804-1132

Microsoft Access

Unlock the Power of Data with Our Interactive Microsoft Access Training!

Women working on programDive into the world of data with Microsoft Access, your magic key to organizing, archiving, and unlocking the full potential of your business’s most valuable resource – information. Imagine seamlessly compiling everything from your inventory and customer data to vendors and order details in a single, powerful application. If you’re in any role dealing with databases, mastering Access 2019/365 isn’t just an option; it’s a must-have tool in your professional arsenal.

Our comprehensive training promises to turbocharge your proficiency no matter where you’re starting from – maybe you’re a Microsoft Office newbie, or you’ve dipped your toes into Access already. Picture yourself turning into a database wizard, expertly navigating this robust software easily.

We’ve designed our training to provide a custom-tailored experience, offering varying levels of complexity that perfectly align with your current abilities. And here’s the best part – our highly-qualified instructors are ready to guide you, live and interactive, every step of the way.
With both online and in-person learning environments, we are ready to empower your teams and groups, no matter their size. So why wait? Join us and unleash the power of Microsoft Access today!

$150 – $550 / Person / Session
*based on number of people

Beginner to Advanced
*all courses can be customized

For Groups Up to 15
*larger groups accommodated with multiple sessions

Virtual or In-person at Client Site
*no public classes

These are the main topics covered in each level of our Access public courses.  Private courses can be customized to focus on the skillsets your team requires.

Level 1 - Beginning

Database Fundamentals
  • Key database terms and management systems
  • Overview of tables, data types, and metadata
  • Understanding SQL and its statements
  • Relational, Flat file, and NoSQL databases
  • Pros of relational databases
  • Access objects in new and existing databases
Database Design
  • Fundamentals of effective design and modeling
  • Logical and physical models of databases
  • Normal forms and their creation
  • Modifying databases, including changing structure and data types
  • Relationships and keys in databases
Tables
  • Table creation in various views and setting primary fields
  • Data validation and rule setting
  • Usage of calculated fields
Forms
  • Creation and design of forms
  • Understanding bound and unbound form controls
  • Working with Form Wizard and form sections
  • Types of form controls and their layout changes
Reports
  • Report creation and setup of data sources
  • Filtering and ordering of reports
  • Usage of automatic report generators and Report Wizard
  • Calculated fields, grouping, and summarizing in reports
  • Formatting and setting up reports, including usage of images and themes

Level 2 - Advanced

Advanced Queries
  • Grouping, summarizing, and building totals queries
  • Understanding referential integrity and cascading practices
  • Techniques for indexing to improve performance
  • Use of specialized query types such as Pass-Through and Data Definition Query
Advanced Forms
  • Utilizing subforms and understanding their relationships
  • Use of various controls: hyperlink, web browser, attachment, chart
  • Creation of specialized form types including navigation and modal dialog forms
  • Establishing a database start-up form
Advanced Reports
  • Incorporating subreports and understanding their record sources
  • Advanced grouping features like date ranges and running sums
  • Formatting options, including banded reports and username/logo display
Macros
  • Macro creation, planning, and assignment to events
  • Working with variables and understanding their scope
  • Troubleshooting and error handling in macros
  • Designing robust macros and logging debug information
Importing and Exporting Data
  • Understanding data exchange basics and the use of various applications
  • Importing, exporting, and linking data with other Access databases and Excel
  • Working with text and XML data files
  • Utilizing import and export options and procedures
Database Management
  • Running Compact & Repair and other maintenance tasks
  • Encrypting a database and creating an executable file
  • Documenting the database structure
  • Working with various types of calculated fields
Carol has always had a passion for helping others in their journey for personal growth. She is a corporate Teacher, Trainer, eLearning Instructor and Program developer with 28 years of experience providing outstanding training for thousands of managers, employees and individuals. Carol is known for her dynamic, motivating and engaging instructional approach.
Chris is our most senior MS Office trainer. He brings 30+ years of experience designing, developing, and delivering effective learning solutions to Tech Touch. With his amazing sense of humor, Chris is a very well-liked and a respected trainer. His classes are lively and never dull. Our clients always ask for him to return!
Michel is an experienced corporate trainer with 20 years of experience and a bachelor’s degree in Business Management. He takes pride in having a unique training style, focusing as much on the ‘What’ and ‘Why’ as it is on the ‘How to’ factor. Michel’s classes showcase real life examples, comparisons, and analogies that all audiences can relate to and benefit from the simplicity of the presented material.
What if I have learners that have different skills sets, some beginners and some more advanced?

Your training specialist will assist you with developing a curriculum that will ensure that no one is left behind. Depending on group size, your consultant may suggest delivering multi sessions so that beginning students don’t feel pressured and more advanced learners don’t feel like the pace is too slow.

Because every situation is different, it is best to discuss this with your Tech Touch Training Specialist, who will help you to come up with a plan that is both economical and efficient.

Where does the training take place?

Your customized training can be delivered either online via Zoom or Webex, or we can bring the training to your location. If you don’t have a space at your site and would prefer not to attend the training online, we can find a location near you, for example at a hotel conference room or similar location.

Talk to your Tech Touch Training Specialist about your options, and we will find a suitable option that best fits your needs and that of your team.

What version do you teach?

Our team of expert instructors can deliver training in any version, so you will be able to learn on the exact version you are using for your projects.

Most businesses have access to the Microsoft 365 Business plans, which allows staff to download the latest version. The most recent version is what we recommend, as you will have the latest features and capabilities.

Tech Touch instructors keep up-to-date on the latest tools for each program in the Microsoft suite. Because our instructors are Microsoft Certified, they often get access to the latest version of these programs in advance of them being made available to the public, so they have familiarized themselves with the latest tools before you have access to them. Therefore, we are able to deliver your best training experience when you are.

Is the training with a live instructor?

Absolutely! Whether you attend the training online or at your location, there is a live instructor delivering your class. No video recordings here.

Having a live instructor available so your team can ask questions and get real-time assistance, is the best training model for learning programs in the Microsoft Office Suite. At Tech Touch, we want you to have the best learning experience possible, so live instruction is a must.

What are the training times?

Most of our clients prefer to have class times starting at 9 am and ending at 4 pm, with a 1-hour lunch period.  This is something your Training Specialist will discuss with you based on your needs and availability.

Do we have to attend an all-day session, or can they be broken up into smaller sessions?

This is one of the biggest reasons Tech Touch offers customized training solutions. Your time is valuable and your team may not be available to leave their work for an entire day. We can offer half-day options and/or break your training sessions up over multiple consecutive or non-consecutive days.

Be sure to discuss your options with your Training Specialist.

Testimonials

Ready to Learn More?

Reach out below to get started on your customized Microsoft Access training course.

The
Tech Touch
Difference

With decades of experience in corporate training, we’re proven time and again that customized training programs are far more effective than cookie-cutter classes.

We put in the work beforehand to ensure that our programs meet your individual needs and goals with a laser-focus on exactly what you need to get YOUR job done.

At Tech Touch, we operate with integrity and passion. As such, we want to be your trusted training partner, not just a training company delivering a service.

Request a Quote

Fields marked with an * are required