Your cart is empty.
Keep shopping
Access 2007 Intermediate
167 students
What you'll learn
- Understand relational database concepts
- Effectively design and create tables
- Perform calculations
- Create multi-table, action and parameter queries
- Work with advanced form functions and advanced report functions
Explore related topics
Course content
11 sections • 50 lectures • 3h 25m total length
Requirements
- Basic Microsoft Windows and Microsoft Access 2007 training or equivalent experience
Description
This course builds on the skills and concepts taught in Access 2007: Introduction. Students will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.
Who this course is for:
- Students who are familiar with creating basic databases looking to better understand table relationships, learn advanced table design, create queries and use advanced form and report features