Microsoft Access 2007 Introduction

To download course outline click here.

Introduction 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 include designing 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. In this session you will learn how to:

• examine the basic database concepts and explore the Microsoft Office Access 2007 environment.
• design a simple database.
• build a new database with related tables.
• manage data in a table.
• query a database using different methods.
• design forms.
• generate reports.

Intermediate 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. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access 2007 can also take this course. In this session you will learn how 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 by grouping form controls and making other aesthetic improvements to make forms work more efficiently and intuitively for the user.
• customize reports to organize the displayed information and produce specific print layouts.
• share data across different applications.

Advanced 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. In this session you will learn how to:

• restructure data into appropriate tables to ensure data dependency and minimize redundancy.
• write advanced queries to analyze and summarize data.
• create and revise Microsoft®® Office Access™ 2007 macros.
• display data more effectively in a form.
• customize reports by using various Microsoft® Office Access™ 2007 features, making them more effective.
• maintain your database using tools provided by Microsoft® Office Access™ 2007.

To download course outline click here.