Corporate Training By Zack Academy - Access 2007/2010 - Intermediate

Why Should You Take This Access 2007/2010 - Intermediate Course?

This ILT Series course builds on the skills and concepts taught in Access 2007/2010: Basic. Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts. This course is task-based and focuses on real-world scenarios and challenges students’ face in their day to day environments. This course will help students prepare for the Access 2007 exam (77-605).

Taking this course will give you the skills necessary to effectively and efficiently:

• structure databases,
• create and format database elements,
• enter and modify data,
• create and modify queries,
• present and share data, and
• manage and maintain the overall database.

The Following Topics Will Be Covered:

1.  Relational Databases:

• Topic A: Database normalization
• Topic B: Table relationships
• Topic C: Referential integrity

2.  Related Tables:

• Topic A: Creating lookup fields
• Topic B: Modifying lookup fields
• Topic C: Subdatasheets

3.  Complex Queries:

• Topic A: Joining tables in queries
• Topic B: Using calculated fields
• Topic C: Summarizing and grouping values

4.  Advanced Form Design:

• Topic A: Adding unbound controls
• Topic B: Adding graphics
• Topic C: Adding calculated values
• Topic D: Adding combo boxes
• Topic E: Advanced form types

5.  Reports and Printing:

• Topic A: Customized headers and footers
• Topic B: Calculated values
• Topic C: Printing
• Topic D: Labels

6.  Charts:

• Topic A: Charts in forms
• Topic B: Charts in reports

7.  PivotTables and PivotCharts:

• Topic A: PivotTables
• Topic B: Modifying PivotTables
• Topic C: PivotCharts
• Topic D: PivotTable forms

Syllabus

Unit 1: Relational Databases:

• Topic A: Database normalization
• Topic B: Table relationships
• Topic C: Referential integrity

Unit 2: Related Tables:

• Topic A: Creating lookup fields
• Topic B: Modifying lookup fields
• Topic C: Subdatasheets

Unit 3: Complex Queries:

• Topic A: Joining tables in queries
• Topic B: Using calculated fields
• Topic C: Summarizing and grouping values

Unit 4: Advanced Form Design:

• Topic A: Adding unbound controls
• Topic B: Adding graphics
• Topic C: Adding calculated values
• Topic D: Adding combo boxes
• Topic E: Advanced form types

Unit 5: Reports and Printing:

• Topic A: Customized headers and footers
• Topic B: Calculated values
• Topic C: Printing
• Topic D: Labels

Unit 6: Charts:

• Topic A: Charts in forms
• Topic B: Charts in reports

Unit 7: PivotTables and PivotCharts:

• Topic A: PivotTables
• Topic B: Modifying PivotTables
• Topic C: PivotCharts
• Topic D: PivotTable forms