Learn advanced querying techniques and database management in this hands-on training in Microsoft Access.
In this course, you’ll learn how to write advanced queries and organize your database for maximum efficiency. If you’ve taken Microsoft Access Essentials or already understand the basics, this is the perfect course for you. At the end of this intermediate Microsoft Access class, you’ll be able to join tables, implement data validation techniques, and use advanced reporting functions.
Prerequisite
Students must have Access proficiency equivalent to our Microsoft Access Level I course.
What You’ll Learn at a Glance
- Design a Relational Database
- Join Tables to Retrieve Data
- Validate Data Entered
- Advanced Queries
- Efficiency & Performance
- Maintain Data Integrity
- Customize Reports
Course Syllabus
- Designing a Relational Database
- Joining Tables
- Using Data Validation
- Creating Advanced Queries
- Organizing a Database for Efficiency
- Using Advanced Reporting Techniques
Learn more about Microsoft Access Level II at NYIM Training.
