Access Module 3 - Data Manipulation Techniques, Thales Training Consultancy

ACCESS MODULE 3 - DATA MANIPULATION TECHNIQUES

Duration:

1 day

Price:

£175.00

Locations Available:

Basingstoke
05 Aug 08
12 Nov 08

Crawley
21 May 08*
07 Jul 08
11 Aug 08*

Versions:

97, 2000, XP and 2003

Suitable for:

This course is designed for existing users of Microsoft Access who need to use more data manipulation techniques within their databases or for importing and tidying up data.

The student should have had some exposure to designing and using Access databases.

Objectives:

By the end of the course delegates will be able to:

Create complex queries to extract information
Create action queries to change information
Create de duplication queries
Create reports to group and sub total data
Export information to other packages

Course Outline:

The Database Structure

Relational databases

Importing Data

Excel files
Text (CSV) files

Query Review

Extracting data using select queries
Calculations in queries

Further Select Queries

Top values queries
Unique values queries
Multi table queries
Linking tables in queries

Summary Queries

Adding totals to your queries
Building crosstab queries

Action Queries

Using make table queries
Using append queries
Using delete queries
Using update queries

De-Duplication Techniques

Using the duplicates query wizard
Eliminating duplicates using an append query
Finding differences between tables

Advanced Reporting Techniques

Grouping reports
Totals and subtotals
Counting
Concatenating fields
Conditional text

Exporting Data for use in Word and Excel

Exporting data to Word
Exporting data to Excel