How Live Online Classes Work
Watch A Short Video Overview of Instructor-Led Online Classes

Microsoft Silver Learning Partner
microsoft-silver-learning-partner
What Students are Saying...

This was a very thorough class and the instructor was extremely knowledgeable and easy to follow. He was able to answer all my questions and provide relevant examples. I would highly recommend.

Course: Microsoft Project 2010 Training Student: Ellen L., Advanced Testing Laboratory

Dan was a great instructor.He was very personable and knowledgeable. His examples of real world applications of Javascript tied everything together for me.

Course: Javascript Training Student: Jim J., R.W. Baird

This was an excellent learning experience. I started the class with some knowledge of the content, so the pace worked very well for me.

Course: T-SQL with SQL Server 2008 Training Student: Debbie M., Pharmacist Mutual Insurance

The instructor was very knowledgeable and pleasant to work with – Thank You.

Course: Adobe InDesign CS5 Training Student: Kathy G., Choctaw Nation Health Services

Enjoyed the class. Rodney was accommodating, yet stayed on task. Gave plenty of time to ask questions to any level of detail we wanted.

Course: Microsoft Project 2003 Training Student:: David C., Siemens Energy, Inc.

Jen was one of the best instructors I have ever worked with in my past 45 years.

Course: Microsoft Access 2010 Advanced Training Student: Robert C., TNS Global

Jennifer was absolutely fantastic! She was a consummate professional, and I would highly recommend her to anyone that is interested in this course or any of the others that she delivers. Thank you, Jennifer!

Course: Microsoft PowerPivot 2013 Training Student: Jim M., The Bill and Melinda Gates Foundation

Free Demonstration
News and Discounts
Subscribe to receive news about our new courses and valuable training discounts!
 
First Name
Last Name
Email
   

Microsoft Access 2010 Advanced Training

How To Take This Class:

Live Instructor-Led Online Class
Cost: $225.00

  • Live class with an instructor
  • Hands-on exercises and student labs
  • Classes never cancelled due to low enrollment
  • Six months of instructor email support
  • Course manual and headset shipped to you
  • Money-back guarantee
Onsite Group Training
Cost: Based on number of students

  • For groups as small as 3 people
  • Expert instructor comes to your location
  • Hands-on exercises and student labs
  • Customization at no extra charge
  • Six months of instructor email support
  • All-inclusive pricing
  • Money-back guarantee

    > Request Group Pricing Proposal





Course Duration:

1 Day

What Students Receive:

Each student will receive:

  • A printed courseware manual for use during and after class.
  • Access to a searchable, electronic version of the courseware manual for reference after class (available for 12 months after class.)
  • A PC headset for communicating with your instructor and fellow students during your Microsoft Access 2010 Training Class
  • A course completion certificate upon successful completion of your Microsoft Access 2010 Training course
  • Six months of post-class email support from a Microsoft Access Instructor

Course Description:

Your training in and use of Microsoft Office Access 2010 has provided you with a solid foundation in the basic and intermediate skills of working in Microsoft Office Access 2010. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this Microsoft Access 2010 Training 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.

Course Objectives:

Upon successful completion of 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.
  • Display data more effectively in a form.
  • Customize reports by using various Microsoft Office Access 2010 features, making them more effective.
  • Maintain your database using tools provided by Microsoft Office Access 2010.

Course Audience:

This Microsoft Access 2010 Training 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 Prerequisites:

Students should have completed, or have experience with, topics covered in the Microsoft Access 2010 Introduction Training and Microsoft Access 2010 Intermediate Training courses.

Course Syllabus:

  1. Structuring Existing Data
    • Restructure the Data in a Table
    • Create a Junction Table
    • Improve the Table Structure
  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
  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
  4. Creating Effective Reports
    • Include a Chart in a Report
    • Print Data in Columns
    • Cancel Printing of a Blank Report
    • Publish Reports as PDF
  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