Access 2007 Intermediate

ACCESS 2007 INTERMEDIATE

You have the basic skills needed to work with Microsoft® Office 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 customize database components, and how to share Access data with other applications.

Target Student

Microsoft Office Access 2007: Level 2 is designed for students who would like to learn intermediate-level operations of the Microsoft Office 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 Office Access 2007: Level 1 course or equivalent knowledge is recommended.

Certification

This course is one of a series of ExecuTrain courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office 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 Office Specialist certification.

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.
	customize reports to organize the displayed information and produce specific print layouts.
	share Access data across other applications.