Microsoft Access 2003 - Expert

Overview

Enhance Access databases with automation using Macros and customised Forms and Reports.

Target Audience

This course is aimed at regular users of Microsoft Access 2003 who wish to enhance existing databases with advanced Queries, Reports and Forms.

Prerequisites

It is essential that course participants have successfully completed an Access 2003 Core course, or have gained a similar level of knowledge within the workplace. Specifically participants need to be fully conversant in:

  • Create basic Tables and Queries.
  • Table Relationships and Database Normalisation.
  • Creating basic Forms and Reports.

Objectives

Upon completion users will be able to:

  • Use advanced querying features to interrogate table data.
  • Customise Forms and Reports to include user options and graphs.
  • Design Macros to automate tasks.

Duration

2 days.

Course Content

Advanced Queries

  • Understanding Queries
  • Concatenating Fields
  • Action Queries and Joining Table Queries
  • Using Crosstab and Parameter Queries
  • Creating Make Table Queries
  • Multiple Tables and Relationships
  • Creating an AutoLookup Query

Table and Query Properties

  • Default Values
  • Setting Data Validation

Customising Reports and Forms

  • Using Expressions
  • Creating Calculation Fields
  • Using Inherited Filters
  • Subreports/Subforms
  • Creating User Controls
  • Creating Mailing Labels in a Report
  • Grouping and Sorting Data in a Report

Creating Charts

  • Using Microsoft Graph
  • Using the Chart Wizard
  • Editing and Enhancing Charts
  • Importing and Linking Data from other Applications

Object Linking and Embedding

  • Adding a Picture/Other Objects to a Form or Report
  • Adding Objects and Pictures
  • Editing Objects and Pictures
  • Dragging and Dropping Database Objects

Creating and Using Macros

  • Creating, Saving, Editing and Running Macros
  • Grouping Macros
  • Conditional Macros
  • Assigning Macros to Shortcut Keys and Buttons

Integrating with Other Applications

  • Saving an Object as a Web Page
  • Creating Hyperlinks

Security

  • Working with Replication
  • Setting Passwords for a Database

Back



 
 
 

Download

Download this profile here.
 

What's Next?

Learn to use VBA code to enhance and improve database functionality and performance
Microsoft Access 2003 VBA
 

Also Available

Microsoft Access 2003 Core