Microsoft Access Intermediate

1 Day
Versions XP, 2003 and 2007

Course Description

This instructor-led, hands-on course teaches the basic skills needed to import data from other applications into a Microsoft Access database, modify tables, create action queries, and export data from Access into other applications such as Excel.

Prerequisites

This course is designed for users who are comfortable using Microsoft Access and need to expand their knowledge. In order to successfully complete this course, we recommend that you first take Softek’s Introduction to Access course or have equivalent knowledge. You should feel comfortable creating basic tables, forms, queries, and reports.

Importing Information from Other Sources

Importing a Spreadsheet

Importing a Text or ASCII File

Importing a Database Table

Appending Records from One Table to Another

Applying Field Properties to Validate Data entry

Creating Lookups or Drop-down Lists

Modifying a Value Lookup List

Using Input Masks

Specifying a Default Value

Enhancing Data-Entry Forms

Updating Fields with Property Changes

Shortcuts for Selecting Objects

Automatically Aligning Multiple Objects

Changing the Tab Order of a Form

Adding Command Buttons to a Form

Automatically Spacing Objects

Creating More Advanced Queries

Using Parameters to Prompt for Criteria

Writing Expressions or Calculations in a Query

Creating Summary Queries

Using Update Queries to Globally Change Data

Running Queries to Archive Information

Enhancing Reports

Creating a Report Using the New Object Feature

Sorting and Grouping Data

Working with Graphic Lines

Keeping Records Together on a Page

Printing Group Headers on the Top of Every Page

Writing Expressions and Calculations on a Report

Exporting Information Out 0f Access

Exporting a Table or Query

Exporting a Report as Text

Using an Access Table or Query as a Mail Merge

 

Is this the right level for you? Take our free assessment! Please contact our office at 202.682.4500 if you have any questions.

Other Helpful Links

Access - Introduction Agenda

Access - Intermediate Agenda

Access - Advanced Agenda

Access - VBA Programming Agenda

Database Design

Top of Page
Softek Services, Inc. Training Consulting Programming