Overview
This course is for users of databases created in Microsoft Access 2003 who need to manage
the data. The course comprises a mixture of demonstrations, tutor-led examples and student
exercises.
Requirements
Delegates should be familiar with the Windows environment. No prior knowledge of database
terminology or Microsoft Access is assumed. The course includes no programming.
Contents
The Access Environment
Introduction to Database Terminology
Starting Access and Opening a Database
Database Objects
On Line Help
Using Database Tables and Forms
Opening a Table
Opening a Form
Entering Data
Copying, Moving and Deleting Data
Undoing Changes
Locating, Sorting and Filtering Data
Using Select Queries
What is a Query?
The Simple Query Wizard
Creating a Query in Design View
Saving and Printing Queries
Queries with Multiple Tables
Calculations and Summaries in Queries
Using Action Queries
What are Action Queries?
Make Table Queries
Delete Queries
Append Queries
Update Queries
The Query Wizards
Reporting
Why Design a Report?
Using Report Wizards
Modifying Reports in Design View
Sorting and Grouping Data
Some Report and Section Properties
Mailing Labels
Charts
Merge It with Microsoft Word
Analyse It with Microsoft Excel
Course Fees
Microsoft Access 2003 Overview
Microsoft Access 2003 Introduction
Microsoft Access 2003 Advanced |
.gif)