Access 2007 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 in much detail is Visual Basic (which we cover in a separate two-day course).

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

Access 2007 Developers training - Course Contents

The contents of our Access 2007 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
Using multivalue fields

Creating tables

Defining fields
The types of field
Entering data

Different field types

Creating attachments
Rich text format fields
Date fields (using calendars)

Importing data

Importing from Excel
Making tables from Excel

Drawing relationships

Creating relationships
Referential integrity

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

Crosstab queries (*)

Columns, rows and values
Overriding column headings

Action queries

Making tables
Updating records
Appending records
Deleting records

Creating forms

Layout and design view
Using the form wizard
Split forms
Creating controls

Creating reports

Using the report wizard
The group, sort and total pane
Report design

Creating subforms

Multiple item forms
Creating subforms
Tidying up subforms

Basic VBA coding

Creating modules
Using Project Explorer
Writing comments
Indenting code

Uses of VBA

Form validation
Criteria forms
A simple menu system

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 2007 Developers training course (3 days)

Access 2007 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