SETC Training844-434-7382
 Find a Course: 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

Microsoft Access Training

Our instructor did a truly excellent job of conveying the material. Our students were already familiar with the technology and moved through the material quickly. I was especially impressed with the ability of the instructor to go "off course" and provide extra material on-the-fly at our request. They did an amazing job. Very friendly, very knowledgeable with excellent teaching skills.
Comment from OSFI

1. Title

  • Microsoft Access Level 1: Mastering Tables, Data Validation, Reporting and Presentation (ACCBAS, 3 days)
    View PDF

2. Course Pre-requisites

  • Previous experience with databases

3. Target Audience

  • Business professionals who want to learn how to create relational databases with Microsoft Access

4. Dates and Pricing

Nov 6 to Nov 8, 2017$1,675.00/person

5. Outline

Module 1: About Microsoft Access

Topic 1: Understanding MS Access Database Components

Topic 2: Setting up the Environment

Topic 3: The Structure of an Access Solution

Topic 4: About Data Normalization

Topic 5: About Queries and Reports

Topic 6: About User Forms

Topic 7: About Macros and Code

Topic 8: Putting it All Together

Topic 9: Exercise: The components of a Microsoft Access solution

Module 2: Creating Tables

Topic 1: About the Design of a Database

Topic 2: The Importance of Data Normalization

Topic 3: Creating Tables

Topic 4: Choosing Field Types

Topic 5: Working with Dates and Currencies

Topic 6: Implementing Domain Integrity: Checks and Defaults

Topic 7: Implementing Primary Keys

Topic 8: Implementing Foreign Keys

Topic 9: The Importance of Indexing

Topic 10: Exercise: Creating a normalized table structure

Module 3: Writing Single Table Queries

Topic 1: Writing Single Table Queries

Topic 2: Filtering and Sorting Data

Topic 3: Working with Calculated Fields

Topic 4: Formatting Outputs

Topic 5: Using Built-In Functions

Topic 6: About Grouping Data

Topic 7: Calculating Aggregate Data

Topic 8: Writing SQL Queries Manually

Topic 9: Exercise: Writing useful data queries

Module 4: Writing Multi-Table Queries

Topic 1: Understanding Joins and Join Types

Topic 2: Performing an Inner Join

Topic 3: Performing an Outer Join

Topic 4: About Sub-Queries

Topic 5: About Correlated Sub-Queries

Topic 6: Writing Multi-Table Queries Manually

Topic 7: A Few Performance Considerations

Topic 8: Exercise: Retrieving related data elements

Module 5: Building Reports

Topic 1: Report Basics: Linking Reports and Queries

Topic 2: Creating Enterprise Reports: Header, Footer and Data

Topic 3: Displaying Records in a Report

Topic 4: Grouping Data

Topic 5: Displaying Aggregate Data

Topic 6: Formatting the Report

Topic 7: A Few Useful Tips

Topic 8: Exercise: Building useful reports

Module 6: Creating Forms

Topic 1: Form Basics: Creating a Workflow

Topic 2: Creating a Form and Linking it to a Query

Topic 3: Adding Display Controls

Topic 4: Adding Input Controls

Topic 5: Adding User Interaction Controls

Topic 6: Validating Data Inputs

Topic 7: Implementing Behaviours through Macros

Topic 8: Launching Other Forms

Topic 9: Exercise: Creating user centric data forms

Module 7: Working with Macros

Topic 1: Macro Basics

Topic 2: About the Macro Editor

Topic 3: Creating Basic Macros

Topic 4: Manipulating Forms in Macros

Topic 5: Working with Data in Macros

Topic 6: Creating Automation Macros

Topic 7: Exercise: Creating macros that support your needs

Module 8: Writing Custom Code

Topic 1: About Modules and Class Modules

Topic 2: Creating Support Functions

Topic 3: Working with Strings

Topic 4: Working with Numbers

Topic 5: Implementing Conditional Logic

Topic 6: Calling Native Access Functions and Procedures

Topic 7: Exercise: Writing useful functions

Module 9: Working with Class Modules

Topic 1: The Need for Objects

Topic 2: Creating a Class Module

Topic 3: Creating Properties

Topic 4: Creating Methods

Topic 5: About Object Initialization and Termination

Topic 6: Using Objects to Implement Custom Behaviours

Topic 7: Exercise: Creating Support Obejcts

Module 10: Coding Forms

Topic 1: Adding Code to Forms

Topic 2: Implementing Custom Form Behaviours

Topic 3: Creating Master – Detail Forms

Topic 4: Loading Default Forms

Topic 5: Controlling the User Experience through Code

Topic 6: Exercise: Creating Data Access Forms

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette