Microsoft Access 2007: Intermediate

Request info

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

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2025-02-09' ) ) AND ((wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (101) AND ((wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC