Access 2003, Advanced (VBA) AC-013

Course Overview

Developing database management applications.


Prerequisites

Microsoft Access Intermediate

Syllabus

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;
  •  Differentiating 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.

Share

[ssba]


Duration : 2 days
Regular Rate : $500
Preferential Rate : $440
Notes :


Upcoming Dates

[ESPRESSO_TICKET_SELECTOR event_id=13343]

Duration : 2 Days
Regular Rate : 500.00 $
Preferential Rate : 440.00 $
Note :
Upcoming Dates :
price
qty