Microsoft® Office Access® 2007 Online Learning Subscription

One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked and managed using a single relational database application and its associated tools.

Level 1 Course Description:
In this course, you will examine the basic database concepts, create and modify databases and its various objects. This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes. The Level 1 course is for the individual whose job responsibilities includedesigning and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access 2007 can also take this course.
Estimated Level 1 time of completion: 7 hours 30 minutes

Level 2 Course Description:
In this course, you will consider how to maintaindata consistency, how to customize database components and how to share Access data with other applications. Level 2 is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program and 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. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access 2007 can also take this course.
Estimated Level 2 time of completion: 6 hours 15 minutes

Level 3 Course Description:
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing the forms and reports, and maintaining a database. This course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft Office Specialist Certification for Microsoft Office Access 2007, and it is a prerequisite to take more advanced courses in Microsoft Office Access 2007.
Estimated Level 3 time of completion: 5 hours 30 minutes

• Course type: Self-paced
• 90-day subscription
• Also available with this subscription: Access 2003 courses
• Within 24-48 hours, you will receive an email that provides an access code and directions on how to register and access your learning subscription^*

^* Please be sure to enter an accurate email address when you order so that your learning subscription can be provided as quickly as possible.

Hardware and Software Required:

Browser Microsoft Internet Explorer 6.0

Browser Firefox 1.x

Browser Safari 1.x

Operating System MS-Windows 2000

Operating System MacOS 10.3.x