00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

    Microsoft Access Advanced

     

    Description

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

    Price: €300 per person

    Dates

    • Book a place on this course and pay with your credit card.08 June 2018 , 1 Day
    • Book a place on this course and pay with your credit card.19 September 2018 , 1 Day
    • Book a place on this course and pay with your credit card.14 December 2018 , 1 Day

    TARGET AUDIENCE

    Aimed at users who have a good working knowledge of Microsoft Access and who would like to reach an advanced level.

    PREREQUISITES

    A good working knowledge of Microsoft Access

    GOALS AND OBJECTIVES

    Having completed this course, participants will have an advanced knowledge of Access, including relational database design, macros, VBA, database security and integration with other Microsoft Office applications.

    Course Outline
    Click here to download course oultline

    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
    Startup 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
    Startup Options
    Export linked data source information to Excel

    Database Management Tools
    Compact and Repair Database
    Compact on Close
    Table Analyzer

    Using the ‘Tell me what to do…’ function

    Course Summary and Review
    Recap of Topics Covered
    Question Time

Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.