Advanced Microsoft Access 2010

After completing this course, students will be able 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® 2010 macros.
• customize reports by using various Microsoft® Office Access® 2010 features.
• maintain their databases using Microsoft® Office Access® 2010 tools.

Intended Audience

This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.

Course Duration

• 1 Day, Instructor-led classroom training (8:30am to 4:30pm)

Module 1: Structuring Existing Data

• Restructure the Data in a Table
• Create a Junction Table
• Improve the Table Structure

Module 2: Writing Advanced Queries

• Create SubQueries
• Create Unmatched and Duplicate Queries
• Group and Summarize Records Using Criteria
• Summarize Data Using a Crosstab Query
• Create a PivotTable and a PivotChart

Module 3: Simplifying Tasks with Macros

• Create a Macro
• Attach a Macro
• Restrict Records Using a Condition
• Validate Data Using a Macro
• Automate Data Entry Using a Macro

Module 4: Creating Effective Reports

• Include a Chart in a Report
• Print Data in Columns
• Cancel Printing of a Blank Report
• Publish Reports as PDF

Module 5: Maintaining an Access Database

• Link Tables to External Data Sources
• Manage a Database
• Determine Object Dependency
• Document a Database
• Analyze the Performance of a Database

The CTCLC Difference

Current Technologies Computer Learning Center uses our own certified instructors that will help guide you to a sucessful completion of your Microsoft Office training and certification. Our Instructors are simply the best instructors you will find. Let our great instructors help you get started in understanding and using your Microsoft Office applications. CTCLC has convenient day or night schedules to fit your needs. We can also do onsite classes with our top notch portable labs.

Our instructors are the very best and give 110% to their Students. We care about every student that we train and we have a Free Resit Policy for all of our courses for the same revision. You will not find a better training experience anywhere.

Current Technologies Computer Learning Center is Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Learning Alliance Member, EC-Council Accredited Training Center, and many others. We offer the highest quality, authorized training that you will find anywhere.

CTCLC Special Discounts

Access10-L3	Advanced Microsoft Access 2010	$299.00
Call (219) 764-3800 for Current Specials

CTCLC Microsoft Access 2010 Certification Path

Required Exam(s)	Recommended Training
Microsoft Certified Application Specialist (MCAS) - Access	Introduction to Microsoft Access 2010
	Intermediate Microsoft Access 2010
	Advanced Microsoft Access 2010