Access Logo.png

Microsoft Access

Introduction - 1 Day

• What Is A Relational Database ?

• MS Access Concepts / Terminology
• Creating Database Tables

• Setting Data Types
• Using Validation Rules

• Using Lookup Fields
• Sorting & Filtering Data

• Creating Select Queries
• Designing & Setting Criteria

• Creating & Modifying Forms
• Creating Reports

• Designing & Modifying Reports

Access Logo.png

Microsoft Access

Intermediate - 1 Day

• Importing Data

• Creating Input Masks / Expression Builder
• Adding Combo Boxes To A Form

• Multi-Table Forms

• Cross-Tab Queries

• Summary Queries
• Using Calculations In Queries

• Action Queries
• Applying Sorting And Grouping To Reports

• Performing Calculations On Reports
• Using The Chart Wizard

• Creating Mailing Letters / Labels

Access Logo.png

Microsoft Access

Advanced - 1 Day

• Building Relational Databases

• Types Of Relationship Links
• Bound And Unbound Controls

• Creating Calculated Controls
• Using Tab Pages

• Creating Option Groups
• Creating / Modifying Macros

• Creating Command Buttons
• Designing Application Menus

• Compacting Databases
• Setting Passwords / Start-Up Defaults

• Autoexec Macro

Access Logo.png

Microsoft Access

Access VBA User - 1 Day

• Introducing Visual Basic for Applications

• Creating / Running a Macro
• Converting a Macro To VBA

• Using / Declaring Variables
• Understanding Data Types

• Using Message Boxes
• Designing Navigation Forms

• Creating Command Buttons
• Code - Updating Records

• Code - Running Reports
• Creating User Defined Menus

• The Autoexec Macro
• Understanding / Using Conditions

• Using Calendar Controls

Access Logo.png

Microsoft Access

Access VBA Professional - 1 Day

• Designing Structures

• Using the If...End If Decision Structures
• Using the For...Next Structure

• Error Trapping
• Stepping Through a Procedure

• Creating Run Time Events
• Automatically Running Code

• Opening Other MS Applications
• Exchange Data With External Applications

• The DoCmd Object


Ideally, this course would allow time for the Users to develop their own Code, in a Database, which they bring along to the training day.