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 Excel Workbooks

Importing Text Files

Importing Access Tables

Appending Records from One Table to Another

Applying Field Properties to Validate Data entry

Creating Lookups or Drop-Down Lists

Creating Table Lookups

Creating Value List Lookups

Modifying Value List Lookups

Creating Input Masks

Specifying Default Values

Enhancing Data-Entry Forms

Updating Fields with Property Changes

Shortcuts for Selecting Objects

Automatically Aligning, Sizing, and Spacing Objects

Changing the Tab Order of Objects

Adding Command Buttons to Forms

Creating More Advanced Queries

Using Parameters to Prompt for Criteria

Writing Expressions or Calculations in a Query

Creating Summary Queries

Working with Update Queries

Globally Change Data

Transfer Matching Data

Running Queries to Archive Information

Creating Make-Table Queries

Creating Delete Queries

Enhancing Reports

Creating a Report Using the New Object/Report Tool

Sorting and Grouping Data

Inserting Graphic Lines

Keeping Records Together

Repeating Group Headers on the Top of Every Page

Writing Expressions and Calculations on Reports

Exporting Information Out 0f Access

Exporting Tables and Queries to Excel

Exporting Reports to Word

Using Access Tables or Queries in 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.