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.
Audience
Microsoft Office Access 2007: Intermediate is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Intermediate 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.
- To ensure the successful completion of Microsoft Office Access 2007: Level 2, the completion of the Microsoft Office Access 2007: Introduction course or equivalent knowledge is recommended.
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.
In order for a class to be successful, all students should share the same general level
of knowledge and experience. If a participant does not demonstrate these, the instructor will take
the necessary steps either to prepare the participant or place him/her in a more appropriate course.
This policy is intended to maintain the high level of quality control that you have come to expect.
<< Back to Schedule
Microsoft Certified Partner Learning Solution