Course Outline - Microsoft Teams for End Users

    Microsoft Access Advanced

    Course Duration: One Day

    Target Audience:

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

    Course Objectives:

    To acquire more advanced knowledge of Access, including relational database design, macros, VBA, database security and integration with other Microsoft Office applications.

    Course Outline:

    Introduction and Overview

    • Objectives
    • Programme Overview
    • Explore the Ribbon

    Advanced Database Design

    • Developing Applications
    • Naming Conventions
    • Input Masks
    • Validating and Restricting Data
    • Indexes

    Relational Databases

    • Relational Databases
    • Database Capabilities
    • Relational Database Characteristics
    • Different Types of Relationship
    • Creating a One-to-Many Relationship
    • Primary Keys
    • Referential Integrity

    Macros

    • Create Macros
    • Adding Actions and Arguments
    • Creating Macro Groups
    • Attach Macro to Command Button
    • Customising Toolbars with Macros

    Toolbars / Switchboard

    • Creating Toolbars
    • Customising Toolbars using Macros
    • Creating a Switchboard
    • Modifying a Switchboard
    • Start Up Options

    VBA

    • The VB Window
    • Module Types
    • Variables and Variable Scope
    • Object Properties, Methods and Events
    • Functions and Procedures
    • Conditional Logic and Looping Constructs

    Importing, Linking and Exporting

    • Importing Data
    • Linking Data
    • Importing from another Access Database
    • Importing from a Spreadsheet
    • Exporting Data
    • Automate Importing, Exporting or Linking
    • Start Up Options
    • Export linked data source information to Excel

    Database Management Tools

    • Compact and Repair Database
    • Compact on Close
    • Table Analyser

    Using the ‘Tell me what to do…’ function

    Discussion and Question Time

    • Recap of Topics Covered
    • Question Time
    View Schedule
    Contact Us