Microsoft Access 2010 Advanced

To download course outline click here.

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.