MS Access

Your training in and use of Microsoft® Office /Access 2007 has provided you with a solid foundation in the basic skills for working in Microsoft® Office Access 2007. 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

Expected Accomplishments

• Modify the design and field properties of a table to streamline data entry and maintain data integrity.
• Enhance the capabilities of a form.
• Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
• Customize reports to organize the displayed information and produce specific print layouts.
• Share data across different applications
• Restructure data into appropriate tables to ensure data dependency and minimize redundancy.
• Write advanced queries to analyze and summarize data.
• Create and revise Access macros.
• Maintain your database using tools provided by Access

Course Outline

• Controlling Data Entry
• Joining Tables
• Creating Flexible Queries
• Improving Forms
• Customizing Reports
• Sharing Data Across Applications
• Structuring Existing Data
• Writing Advanced Queries
• Simplifying Tasks with Macros
• Making Effective Use of Forms
• Making Reports More Effective
• Maintaining an /Access Database

Who can benefit

• Personnel responsible for maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications.

Related Training

• None

Modes

• Lectures, tutorial exercises, animations using computer based learning programs.

Prerequisites

• To ensure the successful completion of Microsoft Office Access 2007: the completion of the Basic Access