Access 2003, Intermediate AC-012

Course Overview

To complete a basic application made of tables, queries, forms, and reports as well as macros and menus.


Prerequisites

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

Syllabus

Day 1

Advanced Query Design:

  • Creating Crosstab Queries;
  • Using the Wizard;
  • Working in Design View;
  • Creating queries that accept parameters;
  • Creating different types of parameters;
  • Choosing different types of parameters in the same query;
  • Creating and running Action queries;
  • Creating a Make-Table query;
  • Creating an Append query;
  • Creating a Delete query;
  • Creating an Update query.

Advanced Form Design:

  • Understanding form structure;
  • Types of forms;
  • Modifying object properties;
  • Understanding the notion of bound and unbound objects;
  • Creating a form in design view;
  • Creating a form that uses data from a table or query;
  • Using the Field List;
  • Identifying Toolbox buttons;
  • Using Toolbox tools;
  • Using formatting tools on a form;
  • Aligning objects on a form;
  • Making controls the same size;
  • Applying, creating, modifying, and removing autoformats;
  • Applying conditional formatting rules to controls;
  • Changing the tab order.

Day 2

Advanced Report Design:

  • What is a control?;
  • Modifying control properties;
  • Understanding dependance and independance;
  • Using the Design View and report wizards;
  • Creating a basic report in Design View;
  • Creating a report with grouping;
  • Using wizards to create a report;
  • Applying conditional formatting;
  • Solving printing problems;
  • Using object properties;
  • Filtering and sorting data in a report;
  • Adjusting the print parameters of a section;
  • Changing the format of a field.

Creating Macros:

  • The concept of a macro;
  • Defining macros;
  • Identifying the macro design window;
  • Defining an event;
  • Developping macros in Access;
  • Developping a simple macro;
  • Developping a group of macros;
  • Developping a conditional macro;
  • Using macros with objects;
  • Assigning macros to command button’s properties;
  • Assigning macros to form’s properties.

Appendix A:

Complete definition of macro actions.


Share

[ssba]


Duration : 2 days
Regular Rate : $ 290
Preferential Rate : $ 220
Notes :


Upcoming Dates

[ESPRESSO_TICKET_SELECTOR event_id=13328]

Duration : 2 Days
Regular Rate : 290.00 $
Preferential Rate : 220.00 $
Note :
Upcoming Dates :
price
qty