Microsoft Access 2003 Advanced (Available in French and English)

Optimize database management by adding various types of synchronized drop down lists. Learn to work with SQL queries and get acquainted with programming. Create more efficient queries and more complex reports with SQL and VBA programming languages.

Course Outline

Optimize database management by adding various types of synchronized drop down lists. Learn to work with SQL queries and get acquainted with programming. Create more efficient queries and more complex reports with SQL and VBA programming languages. These powerful tools included in Microsoft Office Access will provide you with a quick and efficient way to target specific data information.

Course Outline Day 1: Optimization:
    Creating synchronized drop-down lists;
        Creating the first drop-down list;
        Creating the second drop-down list;
        Using synchronized drop-down lists;
        Creating a macro to update the second drop-down list;
        Creating an event procedure to update the second drop-down list;
    Using the "Column" property;
        Using the "Column" property;
    Using the Nz function;
        Using the Nz function;
    Inserting and using an Excel spreadsheet in a form;
        Inserting an Excel spreadsheet in a form;
        Using an Excel spreadsheet in a form;
    Advanced form uses;
        Creating the query;
        Creating the subform;
        Creating the calculation.

Introduction to SQL Queries:
    Defining SQL language;
        The benefits of SQL language;
        Accessing SQL language;
    Creating simple SQL language statements;
        Using the SELECT statement;
        Using the FROM clause;
        Using the WHERE clause;
        Using the GROUP BY clause;
        Using the HAVING clause;
        Using the ORDER BY clause;
        Using the ALL, DISTINCT, DISTINCTROW and TOP predicates;
    Creating complex SQL expressions;
        Using the UNION operation;
        Using the SELECT... INTO statement;
        Using the UPDATE statement;
        Using the DELETE statement;
        Using the INSERT INTO statement.

Day 2: Basic Programming:
    Using modules;
        Creating a module;
        Differenciating the types of procedures;
        Creating custom functions;
    Understanding the notions of variable and constant;
        Activating the Explicit by default option;
        Creating and using variables;
    What is a constant?;
        Creating and using constants;
    Managing objects, their methods, and their properties;
        Defining properties;
        Defining methods;
        Understanding the notion of object;
        Using the Object browser;
        Using the DoCmd object;
    Controlling your programs;
        Getting acquainted with the various forms of the If statement;
        Mastering the SELECT CASE instruction.

Complex Programming:
    Using the ActiveX Calendar control;
        Creating the Calendar control;
        Entering the necessary VBA code to use the Calendar control;
    Using error management in VBA;
        Using the On Error statement;
    Using a multiple selection list box;
        Creating a multiple selection list box;
        Creating a list box to display the result;
        Creating a command button to display the result;
        Creating the necessary code to display the result.

All scheduled courses are available in both English and French on identical dates.

Additional Details

Pre-Requisites

Microsoft Access 2003 Intermediate as well as some experience in application design in Access 2003.

Certificates offered

Certificate of completion

Cancellation Policy

All registration cancellations made within five (5) working days of the date of the course are billable at 100%. Synesis reserves the right to cancel any public courses due to lack of sufficient participants.

Map & Reviews

Synesis
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

I would DEFINITELY recommend this to my co-workers.

Reviewed by Bessy S. 2011

   

The classroom was cold

Reviewed by Abiola B. 2011