| |
Get
Started Here
Microsoft Access is the
world’s most popular
database program.
One-on-One Personal
Computer Training provides
advanced Access 2003
training that will enable
the student to become
productive with the
product
Learning Outcomes
This course is designed
for people who are already
familiar with the basic
features of Access 2003
At the end of the course,
the student will be able to:
Understand the purpose and
use of spreadsheets
-
Understand
database concepts and
terminology
-
Plan
and develop advanced
databases
-
Create
sophisticated tables,
forms, queries and
reports
-
Work
with relationships,
properties and
controls
-
Add
graphics objects
-
Include
subdatasheets,
subforms and
subreports
-
Import,
export and link data
-
Create
web pages and data
access pages
-
Create
macros and use them in
events for forms and
reports
-
Customise
toolbars and menus
-
Create
automated applications
with Access
-
Employ
productivity tools
such as AutoLookup,
the Expression Builder
and wizards
Structure
The course is organised
in a series of lessons, each
of which addresses a
particular functional area
of the product. Basic
concepts are introduced
first. Later materials build
on these basics until the
student has a sound grasp of
the principles involved.
Each lesson starts with a
list of learning outcomes
for the lesson. Subject
matter in the lesson is
interspersed with practical
exercises to illustrate the
material covered. At the end
of each lesson there is a:
-
Summary of the lesson,
including a list of the
skills learned and
important terms
-
Questionnaire to test
the student's
understanding of the
lesson
-
Case study for revision
or for fast students.
-
The manual includes a
table of contents, an
index, a glossary of
important terms, tips
and review exercises.
Training Options:
1. One-on-One Training is
available for Microsoft
Excel in
Townsville for just $545 per
day.
For more information on your
training options simply call
the One-on-One Learning
Centre on 1800 66 00 00
|
Contents
Level 3 (1 -Day Course)
-
Relationships,
primary key, joins,
referential integrity
and cascade options
-
AutoLookup,
filtering and indexes
-
Field
and table properties
-
Operators,
expressions and
functions
-
Calculations
in forms and reports
-
Selecting
records in queries
-
Multi-table
forms
-
Form
properties, form
sections, form tabs
and form appearance
-
Option
groups, combo boxes
and command buttons
-
Creating
forms and reports
without a Wizard
-
Editing
and formatting reports
-
Sorting
and grouping
-
Form
letters with Access
and Word
Level 4 (1-Day Course)
-
Subdatasheets,
subforms and
subreports
-
Crosstab
queries, parameter
queries, query Wizards
and action queries
-
Importing,
exporting and linking
-
Bound
and unbound objects
-
Hyperlinks,
static web pages and
data access pages
-
Creating,
running and editing
macros
-
Macro
groups and conditions
for actions
-
Using
macros for events in
forms and reports
-
Command
buttons and customised
toolbars
-
Introduction
to automated
applications
-
Switchboards,
dialogue boxes, menus
and toolbars
Prerequisites
Students should already be
familiar with PCs and have
undertaken the Microsoft
Access Core Training Course
Downloadable Brochure:
Microsoft Access 2003
Advanced Course
Microsoft
Advanced Access
Small Group Training Dates:
Note: A maximum of Ten
people currently attend in
any of our small group
courses
|
Date - Course Name -
Amount |
Book Now |
| 18/10/2010 - Microsoft Access 2003 Level 3 - $255.00 |  | | 19/10/2010 - Microsoft Access 2003 Level 4 - $255.00 | | | 13/12/2010 - Microsoft Access 2003 Level 3 - $255.00 | | | 14/12/2010 - Microsoft Access 2003 Level 4 - $255.00 | |
|
|
