Introduction to Access

Duration: TWO DAYS

Pre-requisites:

Delegates should have a basic understanding of PCs, use of the keyboard and mouse, plus a working knowledge of the Windows environment, gained either from the workplace or by attending an introduction to Windows course

Course Objectives:

After attending the course, delegates should understand the concepts of relational database design, be able to build and modify a database and use the query and report features to obtain information from the database 

Course Content:

Access basics

Designing a database

Creating a database using the Wizard

Creating a database from scratch

Compacting (copying) a database

Opening an existing database 

Working with tables: 

Creating and saving a table

Using indexes and primary key fields

Defining relationships between tables:

Relationship types

Cascading options

Referential integrity

Working with table data

Viewing the table structure

Printing a datasheet   

Forms: 

Creating forms

Creating a custom form

Using the form 

Queries: 

Creating a select query

Criteria in queries

Filtering by selection

Parameter queries

Joining tables in a query

Calculated queries 

Reports:

Creating an AutoReport

Creating a labels report

Creating a report with the AutoReport Wizard

Designing the report

Sorting and grouping data

Headers and footers

Previewing a report 

Office links: 

Merging, publishing and analysing