Byron Employment

Byron Employment. Over 154,200 Jobs Australia Wide.

Delivery Method

  • Online
  • Price: $340.00

Microsoft Access 2003 - Intro to Designing a Database will provide you with the skills to develop and maintain a relational database. Upon completion of this course you will be able to design a database, design tables for use in the database, enter data into the table, use form wizards, create a variety of different queries, create and print reports, create a main menu, create macros and attach them to buttons on forms and mail merge.

What is a Virtual Online Classroom?

The Virtual online classroom is a new innovative classroom available with just a simple Internet connection.

You will learn at the comfort of your desk with the experience and value of interacting with others.

The virtual classroom is a real-time, web-based classroom environment for distant learning. The live classroom adds live discussion and dynamic interaction to your training.

It engages students, promotes active learning and improves performance. The live classroom eliminates expensive, inconvenient travel and teleconferencing - while maintaining the effectiveness of face-to-face meeting and training.

Training Method

Training is conducted by professional trainers, using hands on exercises and user practise to consolidate concepts.

Prerequisite

Access 2003 - Using a database course or equivalent experience. Windows Getting Started course or equivalent. Participants must have good mouse skills.

Course Content

Getting Started

  • Revision of the Basics

 

Desiging a Database

  • Planning the Design
  • The Training Scenario
  • Normalisation
  • Naming Conventions


Designing the Tables

  • Table design
  • Setting Field Properties
  • Defining Field Properties
  • Table Relationships
  • Creating the Relationships

 

Entering Data

  • Overview of Data Entry
  • Importing Data
  • Finding Records
  • Changing Field Settings

 

Queries

  • Introduction
  • Query Design View
  • Creating a Query and Adding Tables
  • Joining Tables
  • Queries Using Criteria
  • Parameter Queries
  • Calculated Fields

 

Forms

  • Introduction to Forms
  • Form Wizards
  • Form Design

 

Reports

  • Introduction
  • Creating a Report with a Wizard
  • Print Preview and Sample Preview
  • Print a Report
  • Mailing Labels

 

Creating the Main Menu

  • The User Interface

 

Macros

  • Using Macros
  • Planning Macros
  • Creating Macros
  • Placing Macros on Forms

 

The Application

  • Combo Boxes
  • Combo Boxes Powered by Queries

 

Mail Merge

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (03) 9372 9381
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (03) 9372 9381 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search