Microsoft Access 2007 Intermediate
Training Course Outline

1-day course

This one-day course builds on the skills and concepts taught in Access 2007: Basic. Students will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (70-605). For comprehensive certification training, students should complete Access 2007: Basic, Intermediate, and Advanced.

Course objectives

• Normalize tables, analyse tables and view object dependencies, set table relationships, implement referential integrity between related tables, and set cascading deletes and updates.
• Create a lookup field and a multivalued field, modify lookup field properties, and use a subdatasheet to add data to related tables.
• Create join queries, create calculated fields in a query, and use queries to view summarized and grouped data.
• Add unbound controls, graphics, and calculated fields to a form; create multiple item forms, split forms, datasheet forms, and subforms.
• Add headers and footers in a report, use functions to add calculated values in a report, print table objects and database documents, and create labels.
• Create and modify charts in forms and reports.
• Create a PivotTable, modify a PivotTable, and create a PivotChart and a PivotTable form.

Course contents

• Relational databases • Database normalization • Relating tables • Implementing referential integrity
• Related tables • Lookup fields • Modifying lookup fields • Subdatasheets
• Complex queries • Joining tables in queries • Calculated fields • Summarizing and grouping values
• Advanced form design • Adding unbound controls • Adding Graphics • Adding calculated values • Adding combo boxes • Advanced form types
• Reports and printing • Customized headers and footers • Adding calculated values • Printing • Labels
• Charts • Charts in forms • Charts in reports
• PivotTables and PivotCharts • PivotTables • Modifying PivotTables • PivotCharts • PivotTable forms

Prerequisites

• Before taking this course, you should be familiar with personal computers and the use of a keyboard and a mouse. Furthermore, this course assumes that you've completed the following courses or have equivalent experience: Windows XP: Basic, or Windows Vista: Basic and Access 2007: Basic.

Target Audience

• You should be comfortable using a personal computer and Microsoft Windows XP or later. You should also have some experience using Access 2007. You will get the most out of this course if your goal is to become proficient using more advanced Access features and functions, such as relating tables, referential integrity, joins, queries, forms, reports, charts, PivotTables, and PivotTables charts and forms.

Certification Track

• This course is designed to help you pass the Microsoft Certified Application Specialist exam for Access 2007. For comprehensive certification training, you should complete all of the following courses: Access 2007: Basic, Access 2007: Intermediate, and Access 2007: Advanced.

 

For further details, or to book a course, please contact us:
email:        training@ictwizard.com
telephone:  01382 453447
 

Our Access courses include:

Microsoft Access 2007 Foundation
 
Microsoft Access 2007 Intermediate
 
Microsoft Access 2007 Advanced
 
Microsoft Access 2003 Foundation
 
Microsoft Access 2003 Intermediate
 
Microsoft Access 2003 Advanced
 
Access VBA

ICT Wizard courses:

• on your site or locations throughout the UK
• Computer training courses in Aberdeen, Dundee, Glasgow, Edinburgh and London
• delivered by Certified Master Instructors.