Access Overview

Who should attend: Those people who are new to Access and who require an overview of this database application.


Course Contents

Day 1


Introduction to Access
- database concepts, uses & benefits
- understanding terminology
Opening a Database
Screen Layout
- understanding the Ribbon
Using a Sample Database
- displaying data in a table
- using a form to view data
- selecting data from the database using a query

Break

Creating a New Table in a Database
- defining fields
- setting field properties
- understanding keys and indexes
Modifying the Structure of a Table
- inserting a new field
Working in Datasheet View
- finding & replacing data

Lunch

Creating Forms
- using the Form tool
- applying a Theme
Using the Form Wizard
- modifying the form layout
- adding objects to the form
Filtering Data in a Form
Setting Conditional Formats in a Form

Break

Querying the Database
- understanding the QBE grid
Creating Select Queries
- entering criteria expressions
- using Parameters in queries
- applying a total row

Day 2

Creating Update Queries
- updating groups of rows
- updating multiple fields
Creating a New Table
- using a Make Table query
Creating Append Queries
- inserting data from another table
Creating Delete Queries
- deleting groups of rows
- deleting inactive data

Break

Report Writing
Using the Report Tool
Using the Report Wizard
- grouping data in a report
- summarising data in a report
Modifying a Report
- understanding sections
- sorting data within a report

Lunch

Linking Multiple Tables
Understanding Referential Integrity
- one to one relationships
- one to many relationships
Adding Tables to the Relationship Window
Creating Relationships
- linking fields
Using a Query to Display Linked Records

Break

Handling Multiple Tables in a Form
- what are Subforms?
Using the Form Wizard to Create a Main/Subform
- specifying the Main table
- specifying the Subform table
- adding a total row to the subform
- filtering the subform