Your cart is empty.
Keep shoppingAccess 2016 Intermediate
462 students
Access 2016 Intermediate
Take your Access skills to the next level by learning advanced query, form, report and macro techniques.
Created byIntellezy Trainers
Last updated 3/2018
English
What you'll 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
Explore related topics
Course content
10 sections • 43 lectures • 2h 2m total length
Requirements
- Access 2016 Introduction or equivalent experience.
Description
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.
Who this course is for:
- Students who want to take Access to the next level and improve their database design skills.