Microsoft Power BI

    Microsoft Access Intermediate

    Course Duration: One Day

    Target Audience:

    Aimed at users who have a good working knowledge of Microsoft Access.

    Course Objectives:

    To acquire more in-depth knowledge of Access, including relational databases, complex queries, macros, switchboards, and integration with other Microsoft 365 applications.

    Course Outline:

    Introduction and Overview

    • Course Objectives
    • Course Overview
    • Database Concepts
    • Flat Files vs. Relational Databases
    • Planning and Design
    • Exploring the Ribbon

    Advanced Table Design

    • Field Data Types
    • Field Properties
    • Creating Input Masks
    • Validating and Restricting Data
    • Setting the Primary Key

    Relational Databases

    • Creating a Relational Model
    • Different Types of Links
    • Key Fields and Indexes
    • Creating One-To-Many Relationships
    • Understanding Referential Integrity

    Access Queries

    • Review Creating Basic Queries
    • Applying a Query to a Database

    Complex Queries

    • Queries with Multiple Criteria
    • Sorting the Query Dynaset
    • Hiding Fields in a Query
    • Creating a Calculated Query
    • Creating a Totals Query

    Creating a Query

    • Creating a Simple Query
    • Using the Query Design Grid
    • Naming a Query for Future Use
    • Modifying an Existing Query

    Action Queries

    • Append Query
    • Make Table Query
    • Update Query
    • Delete Query

    Other Queries Types

    • Queries on Multiple Tables
    • Parameter Query
    • Parameter Query with Wildcards
    • Duplicate / Unmatched Queries

    Access Forms

    • Review of Creating Basic Forms
    • The Layout View and Design View
    • Field Display Types
    • List Boxes and Combo Boxes
    • Option Groups
    • Calculated Controls
    • Using the Expression Builder
    • Adding Command Buttons
    • Creating a Custom Help Screen
    • Main Forms and Sub-Forms
    • Tabbed Forms

    Access Reports

    • Review of Creating Basic Reports
    • Modifying the Controls in a Report
    • Grouping and Sorting Records in a Report
    • Calculations in Reports
    • Reports on Multiple Tables and on Queries
    • Creating Main Reports and Sub-Report

    Access Templates

    • Asset Tracking
    • Contacts
    • Event Management
    • Students
    • Task Management

    Integration with Other Microsoft 365 Applications

    • Importing and Exporting Data
    • Hyperlink Fields
    • Publish and Merge in Word
    • Analyse in Excel

    The ‘Tell me what to do...’ Function

    Discussion and Question Time

    View Schedule
    Contact Us