Access 2003 Intermediate, 2nd Edition + CertBlaster Study Guide

1-4188-8925-3 © 2007 Publish date: February 10, 2006 188 pages

Buy Now: $25.99

Course ID: access-2003-int-2nd-sg

CBT Planet carries a series of computer training books dedicated to teaching you how to get the most out of Microsoft Office products, including Microsoft Access. The Access 2003 Intermediate study guide builds upon your basic skills in working with this relational database program and teaches you intermediate techniques.

The Access 2003 Intermediate courseware has earned a high ranking from ProCert Labs - a 4.9/5.0 for overall quality. Choose this courseware to learn about the intermediate-level features and functions presented in Microsoft Access 2003. You'll learn about setting table relationships, how to use the Lookup fields and sub-datasheets, creating PivotTables and PivotCharts, joining queries, and working with hyperlink fields and data access pages.

This is a fantastic Microsoft Access training tool to learn how to better use Access to achieve results. By learning these intermediate techniques, you will be well on your way to becoming more productive. This course is excellent on its own and is useful after you've completed your studies as a reference book. It contains eight units discussing various features and techniques as well as hands-on components and activities to reinforce the topics.

In addition, if you are pursuing certification as a Microsoft Office Specialist, consider this Access 2003 Intermediate courseware, it is approved curriculum for your certification.

Course Objectives

By taking this course, you will learn how to normalize tables, create relationships, and enforce referential integrity between related tables. You will also learn about Lookup list fields, modifying Lookup field properties, and using sub-datasheets for adding data to related tables.

Other topics cover creating join queries, using calculated fields in queries, and viewing summarized and grouped data by using queries. You'll learn about adding components to a form including graphics, unbound controls, calculated fields, and combo boxes.

The course will teach you how to embed sub-reports into a report, calculate values, and add headers and footers to your reports. You will also be able to add and edit charts in both reports and forms, work with PivotTables and PivotCharts, and use hyperlinks and data access pages.

Course Contents

Unit 1 introduces relational databases

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

Unit 2 covers using related tables

• Lookup fields
• Modifying Lookup fields
• Sub-datasheets

Unit 3 discusses working with complex queries

• How to join tables in queries
• How to create 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

Unit 5 discusses advanced reports

• Using customized headers and footers
• How to add calculated values
• How to add sub-reports

Unit 6 covers charts

• How to add charts to forms
• How to add charts to reports

Unit 7 talks about working with PivotTables and PivotCharts

• Using PivotTables
• Modifying PivotTables
• Using PivotCharts

Unit 8 covers Internet integration

• Hyperlink fields
• Using data access pages

Appendix A contains the Microsoft Office Specialist exam objectives map