Microsoft Office Access 2007 Essential
 

Course Description

In this new course, participants will be taught with the basic functions and new features of Access 2007. Participants will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, as well as reports
 

Objective

At the end of this course participants should be able to:

• Understand what Ribbons, Office button and Quick Access toolbar is all about in Microsoft Office Access 2007
• Use the office assistant and Help functions in Microsoft Office Access 2007.
• Plan and create a database in Access 2007; create individual tables and use Datasheet view or Design view to view records in tables
• Modify a table's design and use the sort, filter, and delete functions in tables
• Set field properties; create input masks; set validation rules; and create single- and multiple-field indexes.
• Create queries, sort and filter the results; modify queries; and perform operations in queries.
• Create, modify, and work with forms; and use them to find, sort, and filter records.
• Create reports by using Auto Report, the Report Wizard, Design view, and queries; and modify and print reports.

Course Duration

7 hours (Full Time) / 9 hours (Part Time)
 

Target Audience

This course is suitable for existing computer users who are migrating from Microsoft Office 2003 to 2007 and who are keen to become proficient in managing records and database.