Access - Data Extraction, Thales Training Consultancy

ACCESS - DATA EXTRACTION

Duration:

1 day

Price:

£175.00

Locations Available:

Basingstoke
14 Jul 08
22 Oct 08

Crawley
16 Jun 08*
09 Sep 08
04 Nov 08
05 Nov 08 (*V 2007 only)

Versions : 2000, XP, 2003 and 2007

Suitable For

This course is designed for first time users of Microsoft Access who need to extract data from an existing database. The student should have an understanding of personal computers and a knowledge of windows and familiarity of the keyboard.

Objectives

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

Work with existing Access databases to extract information·
Report out on information in an easy to understand format

Course Outline:

Starting to use Access

Opening Access
Opening a database
Database objects
Keys and indexes
Amending data
Using forms

Working with Data Tables

Sorting data
Searching for information
Filtering data

Creating Simple Queries

Creating select queries
Adding criteria
Creating parameter queries

Calculations in Queries

Adding calculations to queries
Formatting data in queries

Building Multi-table Queries

Deciding which tables to use
Adding tables to the query
Creating links between tables
Join properties

Printing and Reporting

Using the report wizard
Amending reports
Adding calculations
Adding headers and footers

Exporting Data

Exporting to Word
Exporting to Excel
Exporting as a snapshot