Access 2003

Introduction (E455)

an eWord company

 

Microsoft Office courses are conducted using 2003, however these courses are suitable for users of versions 2000 and XP/2002.

 

 

General Course Information

In this 2 day program, participants will be introduced to the fundamentals of database design and conventions and will be provided with the skills to use Microsoft Access effectively.

 

You will learn to

Ø  Use databases and database objects

Ø  Create and work with tables

Ø  Set field properties

Ø  Understand the concept of Normalisation

Ø  Create relationships

Ø  Analyse a Table

Ø  Find, filter and sort records in a database

Ø  Create Queries to analyse and view data

Ø  Create basic forms and reports

Ø  Use the design view

 

What skills you need

No prior knowledge of Microsoft Access is assumed, however those attending this course should be competent in the use of the keyboard, mouse and working in the Windows environment.

Electus training

Electus is a South Australian company with 20 years of experience in training.  Trainers and facilitators at Electus are chosen for their expertise, practical and broad experience in their field and a relaxed and friendly manner.

 

Training includes

Each participant receives a training reference manual/workbook and supplementary training materials. 

Refreshments and lunch are provided.

 

 

Duration

2 days

9:00am-4:15pm

 

 

Who needs to come

Anyone who needs to learn the basics of creating a database. Attendees will gain an overview of database theory and will work with Tables, Queries, Report and Form Wizards.

 

Nationally Recognised Qualification

You can choose to have this course assessed towards a unit of competency for a nationally recognised qualification.

 

Regular venue

37 Angas Street

Adelaide SA

(near Victoria Square)

 

 

How to book

Contact Electus by
phone: (08) 8221 5517
fax: (08) 8221 5518
email: mail@electus.com.au

 

 

Course dates

Visit www.electus.com.au for the latest course schedule or ring us on (08) 8221 5517.

 

 

 

Electus– Now offering 44 nationally recognised qualifications                                                           37 Angas Street, Adelaide SA 5000

                                                                                                                                                                                        Telephone: 08 8221 5517

                                                                                                                                                                                          Facsimile: 08 8221 5518

                                                                                                                                                                                 Email: mail@electus.com.au

                                                                                                                                                                                              www.electus.com.au

 

 

 

Access 2003 Introduction

 

 

 

Course Content

Exploring Access

·    Starting and exiting Access

·    Opening a Database

·    Changing Menu and Toolbar Options

·    Using Database Objects

·    Using the Database Window

Using On-Line Help

·    Working with Online Help

Creating Tables

·    Creating a New Database

·    Designing Tables

·    Creating in Design View

·    Using Design View

·    Adding Field Names

·    Assigning Data Types

·    Adding a Field Description

·    Setting a Primary Key

·    Using the Table Wizard

Working with Tables

·    Using Datasheet View

·    Navigating Fields in Tables

·    Adding Records

·    Moving through Records

·    Selecting Records

·    Editing, Saving and Deleting Records

Setting Field Properties

·    Using Field Properties

·    Limiting Field Size

·    Setting Number Formats

·    Date/Time Formats

·    Yes/No Formats

·    Setting Default Values

·    Setting Validation Rules

·    Creating an Input Mask

Editing Tables

·    Changing the Row Height

·    Changing the Column Width

·    Changing the Font

·    Changing a Cell Effect

·    Selecting Columns

·    Moving Columns

·    Hiding/Unhiding Columns

·    Freezing Columns

·    Importing Data

Normalisation & Analysing Tables

·    Normalisation

·    Analysing a Table

·    Using Relationships in Splits

·    Using the Table Analyser Wizard

·    Using the Performance Analyser

Creating Relationships

·    Using Related Tables

·    Creating a Relationship

·    Setting Referential Integrity

·    Viewing Subdatasheets

·    Deleting the Join Line

Modifying Tables

·    Inserting/Deleting Columns

·    Renaming Columns

·    Inserting a Lookup Column

·    Inserting a Hyperlink Column

·    Creating a Many-to-Many Relationship

Finding and Filtering Data

·    Sorting Records

·    Finding Records using Wildcards

·    Using Replace

·    Using Filter by Selection

·    Applying/Removing a Filter

·    Using Filter Excluding Selection

·    Using the Filter For Feature

·    Using Filter by Form

Using Simple Queries

·    Using Queries and RecordSets

·    The Simple Query Wizard

·    Creating a Query in Design View

·    Opening and Running a Query

·    Adding a Table to a Query

·    Joining Tables in a Query

Modifying Query Results

·    Sorting and Printing a Query

·    Adding Criteria to a Query

·    Adding a Record using a Query

·    Printing a Query

Using Operators in Queries

·    Using Comparison Operators

·    Using an And Condition

·    Using an OR Condition

·    Using the Between...And Operator

·    Using the Expression Builder

·    Using Wildcard Characters

Designing Advanced Queries

·    Setting Top Values

·    Creating a Calculated Field

·    Creating a Function Query

·    Creating a Parameter Query

·    Creating a Concatenation in a Query

·    Filtering a Query

Creating Basic Forms

·    Using Forms

·    Using The Form Wizard

·    Viewing Records in a Form

·    Printing Records in a Form

·    Basing a Form on a Query

·    Using AutoForm

·    Adding a Record using a Form

Using Design View

·    Hiding the Ruler

·    Disabling Snap to Grid

·    Displaying the Field List

·    Adding a Field

·    Moving Part of a Control

·    Aligning and Spacing Controls

·    Using the Toolbox

·    Adding a Label

·    Adding an Image

·    Adding a Rectangle and a Line

·    Editing an Unbound Control

Creating Basic Reports

·    Using Reports

·    Using the Report Wizard

·    Working in Print Preview

·    Printing Specific Pages

·    Grouping and Summarising Report Data

·    Basing a Report on a Query

·    Using AutoReport

 

 

Electus– Now offering 44 nationally recognised qualifications                                                           37 Angas Street, Adelaide SA 5000

                                                                                                                                                                                        Telephone: 08 8221 5517

                                                                                                                                                                                          Facsimile: 08 8221 5518

                                                                                                                                                                                 Email: mail@electus.com.au

                                                                                                                                                                                              www.electus.com.au