Microsoft Access

Skill Level: 1 Introduction

Duration: 1 Day

Description: Most organizations maintain and manage large amounts of information. 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.

In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access™ 2007 relational database application.

Skill Level: 2 Intermediate

Duration: 1 Day

Description: 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.

Skill Level: 3 Advanced

Duration: 1 Day

Description: Your training in and use of Microsoft® Office Access™ 2007 has provided you with a solid foundation in the basic and intermediate skills of working in Microsoft® Office Access™ 2007.

You have worked with the various Access objects, such as tables, queries, forms, and reports. 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 forms and reports, and maintaining a database.