Access 2003 Developers training course (3 days)

Have you been given the task of designing and developing a database in Microsoft Access? Finding it difficult to know where to start? This three-day course assumes no prior knowledge of Access, and covers all the basics of Access, including how to design your database, creating tables, creating Access queries, and using Access forms, reports and macros. In fact the only thing this course does not cover is Visual Basic (which we cover in a separate two-day course).

Click here to show prices, dates and venues for this course

Access 2003 Developers training - Course Contents

The contents of our Access 2003 Developers course are as follows (any items marked with a * will be covered if time allows):

Designing a database

Identifying the tables
What are relationships?
Setting a primary key

Creating tables

Defining fields
Types of field
Entering data

Drawing relationships

Creating relationships
Referential integrity

Importing data

Importing from Excel
Linking to Excel spreadsheets
Problems with importing

Creating queries

The query design grid
Sorting
Setting criteria
Combining criteria

Advanced queries

Grouping and totalling
Creating expressions
Parameter queries

Joins

Creating ad hoc joins
Types of join

Action queries

Making tables
Updating records
Appending records
Deleting records

Crosstab queries

Columns, rows and values
Overriding column headings

SQL Queries (*)

Union queries
Pass-through queries

Creating forms

Using the form wizard
Using forms to enter data
Form design
Creating controls

Creating subforms

Creating tabular forms
Merging forms and subforms
Tidying up subforms

Creating reports

Using the report wizard
Using print preview
Report design

Basic VBA macros

Creating macros
Using Project Explorer
Writing comments
Indenting code

Uses of macros

Form validation
Criteria forms
A simple menu system

The VBA code editor

Two ways to create modules
Using Project Explorer
Basic subroutines and comments

Click on any link above to show free exercises for the topic in question. In order to attend this course you should already be a confident computer user. Most people find Access harder to learn than Excel or Word (for example). There will be a maximum of 6 people on each course, and each person will have their own computer.

Access 2003 Developers training course (3 days)

Access 2003 Developers training - Course Contents

Top menu

Microsoft Office

SQL Server training

.NET / SharePoint

Training venues

SITE MAP

Microsoft Office training and consultancy

SQL Server training and consultancy

.NET and SharePoint training

Computer training venues