Course duration: 1 Day
Certification: Access 2007 Microsoft Certified Application Specialist
Course Description
You have the basic skills needed to work with Microsoft Access™ 2007 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customise database components, and how to share Access data with other applications.
Course Objective
You will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Access™ 2007 with other applications.
Audience
Microsoft Access 2007: Level 2 is designed for students who would like to learn intermediate-level operations of the Microsoft Access program. The Level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. This course is also a prerequisite to taking more advanced courses in Access 2007.
Prerequisites
To ensure the successful completion of Microsoft Office Access 2007: Level 2, the completion of the Microsoft Access 2007: Level 1 course or equivalent knowledge is recommended.
Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Certification
This course is one of a series of courses that addresses Microsoft Certified Application Specialist skill sets. The Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Application Specialist certification.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
Modify the design and field properties of a table to streamline data entry and maintain data integrity.
Retrieve data from tables using joins.
Create flexible queries to display specified records, allow for user-determined Query criteria, and modify data using queries.
Enhance the capabilities of a form.
Customise reports to organize the displayed information and produce specific print layouts.
Share Access data across other applications.
Course Content
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