Microsoft Access Essentials

Overview & Objectives:
The skills and knowledge covered in this course are sufficient to create real-world database applications that collect data, permit data to be queried, produce reports and display information in forms

Course Duration:
7 Hours (Part-time or Fulltime available)

Who should attend:
This course is primarily designed for people who need to know how to use Microsoft Access to create databases. It is ideal for people who work in variety of tasks and occupations where the assembly and collection of data is important.

Prerequisites:
This course assumes no prior knowledge of Microsoft Access. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system as you will be required to start applications, work with and copy files, and locate file folders

Methodology:
A hands-on approach is taken during this course. The exercises are designed to impart relevant skills and knowledge by having participants work through real-life examples and scenarios.

Course modules:
Chapter 1 Access 2003 Orientation
Chapter 2 Database Theory
Chapter 3 Database Design
Chapter 4 Relational Databases
Chapter 5 Setting Table Relationships
Chapter 6 Adding Relational Records
Chapter 7 Importing Records
Chapter 8 Working With Records
Chapter 9 Data Validation
Chapter 10 Relational Queries
Chapter 11 Relational Select Queries
Chapter 12 Calculated Fields
Chapter 13 Parameter Queries
Chapter 14 Creating Forms
Chapter 15 Creating Reports
Chapter 16 Using The Switchboard
Chapter 17 Getting Help

Training Fee: Au $299.00 - inc. GST

Course Material:
Material provided by Technology and Management Training