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

Microsoft Access Training

The instructor appeared to be very knowledgeable with regard to all aspects of the course. He was quick to point out features which were new or had changed since previous versions, and called specific attention to information he thought was particularly relevant to us.
Comment from DND

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

May 31 to Jun 2, 2017$1,675.00/person
Sep 6 to Sep 8, 2017$1,675.00/person
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