Course aim
This course is an introduction to the relational database, Microsoft Access 2003. The course comprises a mixture of demonstrations, tutor-led examples and student exercises.

Who should attend
Delegates should be familiar with the Windows environment. No prior knowledge of database terminology or Microsoft Access is assumed. The course includes no programming.

Training style
Informal and participative using a combination of trainer input, discussion and practical exercises. This approach ensures the training meets the needs of both the group and individual participants.

Course contents

The Access Environment
Introduction to Database Terminology
Starting Access and Opening a Database
Database Objects
On Line Help

Using Database Tables
Opening a Table in Datasheet View
Moving Around a Table and Entering Data Copying,
Moving and Deleting Data
Undoing Changes
Changing the Layout and Appearance of the Data Sheet
Finding and Sorting Data
Filtering Data by Selection
Filtering Data by Form
Saving a Filter as a Query

Creating New Databases and Tables
Planning a New Database
Creating a New Database
Creating a Database Table
Setting Default Formats
The Input Mask
Setting Default Values For New Records
Validating Data Entry
Setting Up Primary Keys and Indexing Fields
Saving and Modifying Table Structures
Using the Lookup Wizard
Setting Relationships between Tables
Referential Integrity
Inserting SubDataSheets
Import and Link Tables from other applications

Designing Forms
Why Create a Form?
Types of Form
Using AutoForm and the Form Wizard
Changing Forms in Design View
Adding Fields to Forms
Creating Forms based on Multiple Tables
Changing SubForms
Form and Control Properties
Form Design Menus
Setting Filters on Forms
Adding Command Buttons and other Control
Objects to Forms

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
Joining Tables in a Query
Calculations and Summaries in Queries
Using Queries in Forms and Reports

Reporting
Why Design a Report?
Using AutoReport
Using Report Wizards
Modifying Reports in Design View
Sorting and Grouping Data
Some Report and Section Properties
Mailing Labels
Merge It with Microsoft Word

Data Access Pages
What are Data Access Pages?
Types of Data Access Pages
Using Data Access Pages in Internet Explorer
Using Data Access Pages in Microsoft Access
Creating a Data Access Page
Changing Data Access Pages in Design View
Page Design Tools

Related Courses
Microsoft Access 2003 Overview
Microsoft Access 2003 Advanced
Microsoft Access 2003 Queries & Reports


How to book
Please call us now on 020 8658 6994 or email us at admin@alphatraining.com

Home

© Alpha Training, Telephone +44 (0)20 8658 6994, Email admin@alphatraining.com