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
Understanding Data Sources Access Can Import
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 Objects
Automatically Sizing Objects
Automatically Spacing Objects
Adding Command Buttons to Forms
Creating More Advanced Queries
Using Parameters to Prompt for Criteria
Prompting for One Value
Prompting for Two Values
Writing Expressions or Calculations Queries
Sample Expressions
Using Expressions in Criteria
|
Creating More Advanced Queries (Cont.)
Using Expressions to Create Calculated Fields
Creating Summary Queries
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 Reports Using the Report Tool
Sorting and Grouping Data
Inserting Graphic Lines
Previewing Pages in Print Preview
Keeping Records Together
Repeating Group Headers on the Top of Every Page
Writing Expressions and Calculations on Reports
Writing Expressions
Writing Summary Calculations Using the Property Sheet
Exporting Information Out of 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) 747-5000 if you have any questions.
Other Helpful Links
Access - Introduction Agenda
Access - Intermediate Agenda
Access - Advanced Agenda
Access - VBA Programming Agenda
Database Design
|