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.
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.
Also available in-person in NYC