When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Access 2016 Intermediate
Take your Access skills to the next level by learning advanced query, form, report and macro techniques.

This Course Includes
udemy
4.9 (107 reviews )
2 total hours
english
Online - Self Paced
course
Udemy
About Access 2016 Intermediate
This course is designed to teach students intermediate level skills in Microsoft Access 2016. In this course, students will learn to design tables for improved accuracy in data entry by setting default values and restricting data entry, review the various options to share data with other applications including Word and Excel, learn about Action Queries to automate updating, appending and deleting table data, and review various advanced query techniques such as using Query Joins, Parameter queries, working with totals and Crosstab queries. Students will also learn how to automate processes with Macros, advanced form techniques using Conditional Formatting, Tab controls, Combo Box controls and Sub-Forms, and advanced report techniques using Sub-Reports, columns and inserting charts.
What You Will Learn?
- Design Tables for Better Data Entry.
- Share Data with Other Applications.
- Work with Action Queries.
- Advanced Query Techniques.
- Automate Processes with Macros.
- Advanced Forms.
- Advanced Report Techniques.