Microsoft Office Access 2003 Level 2

Start Date:

November 20 2009

End Date:

November 20 2009

Time:

9:00am - 4:30pm

Fee:

Venue:

McKimmon Conference and Training Center

1101 Gorman Street

Raleigh, NC 27695

919.515.2277

Course Overview:

Microsoft® Office Access 2003 Level 2

Why you should attend: You will learn how to enhance their database designs by using the principles of normalization and table relationships. You also learn how to query multiple tables for data that is used in customized forms and reports.

Suggested Prerequisites: Access: Level 1 or equivalent knowledge.

Attend and You Will Learn

Lesson 1: Relational Databases

Database normalization
Relating tables
Implementing referential integrity

Lesson 2: Working with Related Tables

Lookup fields
Modifying lookup fields
Subdatasheets

Lesson 3: Complex Queries

Joining tables in queries
Creating calculated fields
Summarizing and grouping values

Lesson 4: Advanced Form Design

Adding unbound controls
Graphics
Adding calculated values
Adding combo boxes

Lesson 5: Advanced Reports

Customized headers and footers
Adding calculated values
Subreports

Lesson 6: Charts

Charts in forms
Charts in reports

Lesson 7: PivotTables and PivotCharts

PivotTables
Modifying PivotTables
PivotCharts

Lesson 8: Internet Integration

Hyperlink fields
Working with data Access pages

Schedule: