This course is designed to teach students intermediate level skills in Microsoft Access 2019. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 2019 Advanced course.
Overview
COURSE DIFFICULTY
COURSE DURATION
4h
Skills Learned
After completing this online training course, students will be able to:
Desinging Tables for Better Data Entry
Sharing Data with Other Applications
Working with Action Queries
Advanced Query Techniques
Automating Processes with Macros
Advanced Form Techniques
Advanced Report Techniques
Students who’ve attended Access 2019 Beginner and want to learn more about Access.
The recommended pre-requisite for this course is Access 2019 Beginner or equivalent experience.
01. Access 2019 Intermediate
- Desinging Tables for Better Data Entry
- Sharing Data with Other Applications
- Working with Action Queries
- Advanced Query Techniques
- Automating Processes with Macros
- Advanced Form Techniques
- Advanced Report Techniques
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Desinging Tables for Better Data Entry
Sharing Data with Other Applications
Working with Action Queries
Advanced Query Techniques
Automating Processes with Macros
Advanced Form Techniques
Advanced Report Techniques
WHO SHOULD ATTEND
Students who’ve attended Access 2019 Beginner and want to learn more about Access.
PREREQUISITES
The recommended pre-requisite for this course is Access 2019 Beginner or equivalent experience.
COURSE OUTLINE
01. Access 2019 Intermediate
- Desinging Tables for Better Data Entry
- Sharing Data with Other Applications
- Working with Action Queries
- Advanced Query Techniques
- Automating Processes with Macros
- Advanced Form Techniques
- Advanced Report Techniques
