Access 2007 Querying training course (1 day)

Does your computer system generate large amounts of data, which you find is just too cumbersome to analyse? This course assumes no knowledge of Access, and shows how to use Access queries to manipulate data (whether this is held in Access, Excel or some other format). Database design, tables, forms and reports are also normally briefly covered.

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

Access 2007 Querying training - Course Contents

The contents of our Access 2007 Querying 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

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

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

Click on any link above to show free exercises for the topic in question. In order to attend this Microsoft Access training 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 Querying training course (1 day)

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