Access 2007 Intermediate Study Guide

1-4239-1804-5 © 2008 Publish date: March 31, 2007 192 pages

Buy Now: $25.99

Course ID: access-2007-int-sg

CBT Planet has a series of Microsoft Access training books that have been designated as approved courseware for the Microsoft Certified Application Specialist program. The Access 2007 Intermediate study guide is the second in the series designed to teach you about Access 2007 and help prepare you for the Access 2007 exam #70-605.

ProCert Labs has rated the Access 2007 Intermediate courseware with a 4.9/5.0 score for overall quality. It builds on the skills and concepts you learned in the Basic course. By movbing to the intermediate level, you will learn about normalizing data, using Lookup fields and sub-datasheets, creating join queries, adding objects to forms, creating charts, printing reports and labels, and using both PivotTables and PivotCharts.

For comprehensive certification training in Access, you should plan on completing the entire series including Basic, Intermediate, and Advanced. These study guides allow you to learn at your own pace with a convenient, portable format.

You can use the Access 2007 Intermediate courseware as a standalone tool to learn the intermediate concepts on your own terms. It also makes an excellent supplemental aid when attending other courses. Seven full units cover a wide variety of skills you will need to master before moving on to the advanced level of training. This manual is designed for completion in just one day of focused studies but because you are in charge of your pace, you can move through the course at your own leisure.

Course Objectives

By choosing this course, you will learn about normalizing tables, analyzing tables and viewing object dependencies. You will also work on setting table relationships, enforcing referential integrity between related tables, and setting cascading deletes and updates.

Next, you'll learn how to work with fields including lookup fields and multi-valued fields. You'll learn how to add data to related tables using sub-datasheets as well as how to use join queries. Other topics include creating calculated fields in queries, using queries for summarizing and grouping data, adding a variety of controls, calculated fields, and graphics to forms. You'll learn about multiple-item forms, datasheet forms, split forms, and sub-forms.

Finally, you will work with reports and charts learning intermediate features including adding headers and footers, adding calculated values, printing table objects and database documents, creating labels, and adding charts, PivotTables, and PivotCharts.

Course Contents

Unit 1 covers relational databases

• Database normalization
• How to relate tables
• Enforcing referential integrity

Unit 2 covers related tables

• Lookup fields
• How to modify lookup fields
• Sub-datasheets

Unit 3 goes over complex queries

• How to join tables in queries
• Calculated fields
• How to summarize and group values

Unit 4 covers advanced form design

• How to add unbound controls
• How to add graphics
• How to add calculated values
• How to add combo boxes
• Advanced form types

Unit 5 goes over reports and printing

• Customizing headers and footers
• How to add calculated values
• Printing
• Labels

Unit 6 covers charts

• Working with charts in forms
• Working with charts in reports

Unit 7 discusses PivotTables and PivotCharts

• PivotTables
• How to modify PivotTables
• Working with PivotCharts
• PivotTable forms