This ILT Series course, rated 5.0/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Access 2010: Basic. Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.This course will help students prepare for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access 2010.