Brief Summary
This course helps you expand your Access database skills. It's all about digging deeper into queries, reports, and making your data work for you. Plus, it sets you up for that Access 2007 exam. Get ready to ace it, my friend!
Key Points
-
Learn to normalize data for better organization.
-
Create join queries to connect different tables.
-
Use advanced report features for printing.
-
Add objects to forms and make them interactive.
-
Use PivotTables and PivotCharts for data analysis.
Learning Outcomes
-
Master the art of table design and creation.
-
Understand how to use relational database concepts.
-
Perform calculations to analyze your data.
-
Build dynamic forms with interactive features.
-
Get ready and confident for the Access 2007 exam.
About This Course
Expand your Access databases with queries, advanced report and form features and much more
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.
Hal B.
The amount of details being discussed in this course so far are great.