MicroKnowledge Computer Training and Consulting Access 2007 Intermediate

Access 2007 Intermediate Essentials

This 1 day course is designed to develop skills in creating relationships, complex queries, charts, enhanced forms and enhanced reports. This course is appropriate for individuals who are new users of Access or are self-taught and seeking to quickly fill in gaps in knowledge.

After attending this course, participants will have a better understanding of relational database design. You will be able to maintain and enhance existing databases, forms, reports and queries. Together with Access 2007 Basic and Access 2007 Advanced, this course maps directly to the MCAS certification exam.

Please see Access 2007 Intermediate Comprehensive as an alternative course.

Lesson 1: Relational databases

Database normalization
Relating tables
Implementing referential integrity

Lesson 2: Related tables

Lookup fields
Modifying Lookup fields
Subdatasheets

Lesson 3: Complex queries

Joining tables in queries
Calculated fields
Summarizing and grouping values

Lesson 4: Advanced form design

Adding unbound controls
Adding 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

Optional topics

Internet integration
Hyperlink fields
Working with Outlook 2007

21 British American Blvd. Latham, NY 12110 Phone: 518.786.1181 Fax: 518.786.6221