A1

Access Intermediate​​​​

Objective

So, you've built a database, but now you want to do more with the information you've gathered. This Intermediate Access class builds on the concepts taught in Access Basic and covers more advanced features. You will be able to build more customized forms and employ more complex queries. This class will also teach you how to display the information generated in reports in more visually dynamic charts, as well as explore data relationships with pivot tables. You will get plenty of interactive experience to ensure you have mastered each lesson, and our instructors will be there lead you to a full understanding of the material and answer all of your questions.​

Students who complete this Intermediate Access training class will be able to develop more advanced Access databases, as well as extract advanced reports from their databases. This course will enable students to explore the complex relationships between data sets. Relational databases are introduced. Students will learn to use graphics, PivotTables and charts to give their data visual impact. This Intermediate Access course will give the student a confident proficiency of this database application.

Prerequisites

Students should enter this Intermediate Access training course with Basic Access skills including navigation, creating and using databases in both design and datasheet view, and creating basic reports, queries, and forms.