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

Cart () Loading...

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

    $

Microsoft Access 2007 Level 2 - Advanced Database Design

GK# 8655

Course Overview

TOP

In this instructor-led course, you will advance your knowledge of Microsoft Access 2007. You will learn how to insert and delete text to edit a document, then select different views, and print the document. You will create advanced reports using controls, grouping, subforms, calculations, graphic images, and charts. Finally, you will work with and create web-based objects.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Overview of the databases that will be used during the course
  • Insert and delete text to edit a document, then print the document and select different views
  • Enhance tables by creating lookups
  • 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

Outline

TOP
Viewing outline for:

Classroom Live Outline

1. Database Overview

  • Database Overview

2. Enhancing Tables

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

3. Advanced Queries

  • Query Overview
  • The Query Wizard
  • Nested Queries
  • Query Joins
  • Making Table Queries
  • Appending Queries
  • Summary Queries
  • Crosstab Queries

4. Advanced Forms

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

5. Advanced Reports

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

6. Supplemental Topics: Working with Web Tools

  • Working with Web Pages
  • Hyperlinks

Prerequisites

TOP

Those who are familiar with Microsoft Office Access 2007 and who want to advance their skill level

Who Should Attend

TOP

Those who are familiar with Microsoft Office Access 2007 fundamentals and want to expand their skill set

Follow-On Courses

TOP
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.
Enroll