Overview
This course is an overview of the relational database, Microsoft Access 2003. 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
Creating New Databases and Tables
Planning a New Database
Creating a New Database
Creating a Database Table
Setting Field Properties
Setting up Primary Keys
Moving Around a Table and Entering Data
Copying, Moving and Deleting Data
Locating, Sorting and Filtering Data
Setting Relationships between Tables
Designing Forms
Why Create a Form?
Types of Form
Using the Form Wizard
Changing Forms in Design View
Adding Fields to Forms
Form and Control Properties
Using Select Queries
What is a Query?
Creating a Query in Design View
Saving and Printing Queries
Queries with Multiple Tables
Calculations and Summaries in Queries
Reporting
Why Design a Report?
Using Report Wizards
Modifying Reports in Design View
Some Report and Section Properties
Data Access Pages
What are Data Access Pages?
Creating a Data Access Page
Course Fees
Microsoft Access 2003 Introduction
Microsoft Access 2003 Advanced
Microsoft Access 2003 Queries & Reports |
.gif)