Microsoft Access
Certified Microsoft Access Training
Microsoft Access is a vital tool for organizing, storing, and documenting essential business information. This application can compile data ranging from inventory and customer information to vendors and order details with tables, reports, forms, and queries. Any position that works with databases requires Access 2019/365 as part of their professional skill set.
Whether you’re just getting started with Microsoft Office or you have the basics of Access down, this training will expand your skills and make you a pro at database management with this software. Our training offers tiered levels for a personalized learning experience, all with qualified, live instructors. We can cater to teams and groups of any kind and offer both online or in-person learning environments.
Benefits of Training Programs
- Boost Employee Retention
- Nurture Growth and Development
- Build Confidence and Engagement
- Foster a Sense of Belonging
- Retain Top Talent
- Increase Employee Satisfaction
$150 – $550 / Person / Session
*based on number of people
Beginner to Advanced
*courses can be customized
For Groups Up to 15
*larger groups accommodated with multiple sessions
Virtual or Onsite
with a Live Instructor
*no public classes
Whether beginner or advanced, your Microsoft Access training will be customized for your team, but these are some of the skills we might cover at each level.
Beginning
- Create tables in Access
- Append data from Excel
- Import data from Excel
- Import data from a CSV text file
- Design tables and database scenarios
- Learn primary keys and foreign keys
- Adjust size, format, and input mask field
- Learn to create and alter forms and queries
- Make reports
- Explore datasheet and options tabs
- Export data
Intermediate
- Learn advanced tables, input masks, column history, and lookup fields
- Explore advanced queries like wildcard, parameter, self join, and top values
- Learn anchor controls, filter and sort, and layout view for forms
- Learn the option controls group
- Discover adding, sorting, and filtering
- Organize records
- Add summary fields
- Add subreports
- Create mailing labels
- Import and export data from CSV files, Excel, and Mail Merge
Advanced
- Learn primary keys and indexes
- Use ODBC and SQL server
- Learn about Macros
- Learn to do a basic VBA in Access
- Customize and filter the datasheet view
- Link to external databases
- Acquire and install SQL Server Express
- Split an access database into front-end and back-end
- Convert shared tables
- Address multi-user issues with data sharing
- Customize the ribbon and quick access tools
- Convert Macros to VBA
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.
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.
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.
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.
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.
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.
Ready to Learn More?
The
Tech Touch
Difference
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.
