Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


Microsoft Access 2010 Level 2 - Advanced Database Design

GK# 8255

Course Overview


In this clinic with hands-on labs, you will gain the knowledge and skills to work with intermediate features and functionality relating to Microsoft Access 2010 databases.

What You'll Learn

  • Understand the databases that will be used during the course
  • Enhance tables by creating lookups
  • Create various types of advanced queries
  • Create advanced forms by adding controls, subforms, calculations, and graphic images
  • Create advanced reports by adding controls, grouping, subforms, calculations, graphic images, and charts
  • Work with and create web-based objects


Viewing outline for:

Classroom Live Outline

1. Database Overview

  • Database Basics
  • Review Exercise

2. Enhancing Tables

  • Copying a Database Object
  • Lookup Fields
  • Creating a Lookup
  • Review Exercise

3. Advanced Queries

  • Query Overview
  • The Query Wizard
  • Nested Queries
  • Query Joins
  • Make Table Queries
  • Append Queries
  • Summary Queries
  • Crosstab Queries
  • Review Exercise

4. Advanced Forms

  • Form Design
  • Controls
  • Form Properties
  • Subforms
  • Advanced Calculations
  • Customizing Forms
  • Review Exercise

5. Advanced Reports

  • Designing Reports
  • Sorting and Grouping
  • Layout Properties
  • Calculations
  • Subreports
  • Graphic Reports
  • Chart Wizard
  • Review Exercise

6. Supplemental Topics: Working with Web Tools

  • Working with Web Pages
  • Hyperlinks



Who Should Attend


Those who are familiar with Microsoft Access 2010

Follow-On Courses

Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Request this course in a different delivery format.