My instructor was very effective in utilizing the 2 days of training. He was exceptionally knowledgeable of the... More Testimonials »
Home > Microsoft > Microsoft Access > Advanced Access 2010

Advanced Access 2010

Access 2010

Delivery Options

Class Date and Time Price Pricing Information
$675.00
or 3 vouchers vouchers
$675.00 or 3 vouchers vouchers
Register Now
$675.00 or 3 vouchers vouchers
Register Now

Class Description

Class Overview

This Advanced Access 2010 training class targets people who intend to design databases at an advanced level and/or improve existing Access databases.

Class Goals

  • Learn to streamline data entry and maintain data integrity.
  • Learn to join tables to retrieve data from unrelated tables.
  • Learn to create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries
  • Learn to write advanced queries to analyze and summarize data.
  • Learn to improve forms.
  • Learn to customize reports to organize the displayed information and produce specific print layouts.
  • Understand how to maintain databases using Microsoft Office Access 2010 tools.
  • Learn to share data between Access and other applications.
  • Learn to restructure data into appropriate tables to ensure data dependency and minimize redundancy.
  • Learn to create and revise Microsoft Office Access 2010 macros.

Class Outline

  1. Controlling Data Entry
    1. Constrain Data Entry Using Field Properties
    2. Establish Data Entry Formats for Entering Field Values
    3. Create a List of Values for a Field
  2. Joining Tables
    1. Create Query Joins
    2. Join Tables with No Common Fields
    3. Relate Data within a Table
  3. Creating Flexible Queries
    1. Set the Select Query Properties
    2. Retrieve Records Based on Input Criteria
    3. Create Action Queries
  4. Improving Forms
    1. Restrict Data Entry in Forms
    2. Organize Information with Tab Pages
    3. Add a Command Button to a Form
    4. Create a Subform
    5. Display a Summary of Data in a Form
    6. Change the Display of Data Conditionally
  5. Customizing Reports
    1. Organize Report Information
    2. Format Reports
    3. Control Report Pagination
    4. Summarize Report Information
    5. Add a Subreport to an Existing Report
    6. Create a Mailing Label Report
  6. Sharing Data Across Applications
    1. Import Data into Access
    2. Export Data to Text File Formats
    3. Export Access Data to Excel
    4. Create a Mail Merge
  7. Structuring Existing Data
    1. Restructure the Data in a Table
    2. Create a Junction Table
    3. Improve the Table Structure
  8. Writing Advanced Queries
    1. Create SubQueries
    2. Create Unmatched and Duplicate Queries
    3. Group and Summarize Records Using Criteria
    4. Summarize Data Using a Crosstab Query
    5. Create a PivotTable and a PivotChart
  9. Simplifying Tasks with Macros
    1. Create a Macro
    2. Attach a Macro
    3. Restrict Records Using a Condition
    4. Validate Data Using a Macro
    5. Automate Data Entry Using a Macro
  10. Creating Effective Reports
    1. Include a Chart in a Report
    2. Print Data in Columns
    3. Cancel Printing of a Blank Report
    4. Publish Reports as PDF
  11. Maintaining an Access Database
    1. Link Tables to External Data Sources
    2. Manage a Database
    3. Determine Object Dependency
    4. Document a Database
    5. Analyze the Performance of a Database

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following areas is required:

  • Introduction to Access 2010

Courses that can help you meet these prerequisites:

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

Associated Certifications

Quick Links
  1. Watch Presentation
  2. Free Demo
  3. Purchase Vouchers
  4. Partners
  5. Remote Courses
  6. Make Payment
  7. Contact Us
  8. Sitemap
  9. Privacy Policy
Courseware
  1. Purchase Courseware
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
  1. Where We've Trained
  2. We have trainers all over North America.
Compare Us
Compare Webucator to leading Competitors
Training Options
  1. Live eLearning Public Classes
  2. Private Training
  3. Self-Paced eLearning
Microsoft Partner
  1. Microsoft Certifications
  2. Certified Microsoft Courses
  3. Software Assurance Training Vouchers
Watch 3-minute Demo Video
of Live Online Training: Learn the benefits of online training with Webucator
Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.
© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723