Access Training in Perth
Find out why Mobile MOUSe / Scope Computer Vision is fast becoming
the preferred access
training provider for some of WA's largest companies.
If you are looking for ADVANCED Microsoft
Access Training or database development visit Business
Database Australia at this website address... www.businessdatabases.com.au

•
We come to you with our laptop computers and projection equipment
• Our
Access training in Perth is conducted at your
premises (office / factory) or...
• Alternatively, our microsoft
access courses can be delivered at Unit 19 / 1904 Beach
Rd, Malaga, Perth, WA.
• Nationally recognised microsoft
access training
• Small
group & one on one training
(recommended 5 students per class)
(maximum of 14 per class)

•
A detailed high quality manual -> download
a sample
• Free downloadable practice files
• Free online support
• A certificate of attendance (on request)

We currently offer one course level of
Access training (We do plan on introducing
an advanced course in the near future).
• Access
Essentials (our introductory and intermediate access
course )

Option
1
AT OUR premises |
| Enrol 1 Student........................................................... |
$
255.00 |
| Enrol 2 Students.......................................................... |
$ 240.00 ea.
|
| Enrol 3 Students.......................................................... |
$ 230.00 ea.
|
| Enrol 4 Students.......................................................... |
$ 220.00 ea.
|
| Enrol 5 Students.......................................................... |
$ 215.00 ea.
|
| |
|
| NOTE:
Hassle Free - FREE PARKING at our premises |
|
| |
|
Option
2
AT OUR premises |
| Buy 10 Vouchers (single enrolment
1 day courses)......... |
$ 2000.00 |
| |
|
| NOTE:
Hassle Free - FREE PARKING at our premises |
| |
|
Option
3
AT YOUR or OUR premises (MAX OF 14 per GROUP) |
| Enrol up to 5 students for the day.................................. |
$ 1075.00 |
| This
special enrol up to 5 rate is only applicable to Essentials
courses and does not cater for Microsoft Access. |
| |
|
| Enrol up to 10 students for
the day................................ |
$ 1575.00 |
| Each extra enrolment
over 10 students (per head).......... |
$ 100.00 ea. |
| |
|
Option
4
REGIONAL |
| Regional / Country Training.......................................... |
Phone |
| |
|
| Other
Options |
|
| One on One training (price
starting from)....................... |
Phone |
| Hourly Rate (starting at)............................................... |
Phone |
| One on One training (price
starting from)....................... |
Phone |
| Hourly Rate................................................................. |
Phone |
| |
|
| *
Prices quoted are for Perth Metro (phone for regional pricing) |
| * ALL ICA COURSES are
GST FREE / EXEMPT |
|
| * ALL OTHER COURSES
are GST INCLUSIVE |
|
| * If
no parking is freely available, a parking fee will be levied. |
| |
|
• The more candidates you enrol, the cheaper
the access
course
• Our pricing structure is great for companies
and friends
• No hidden fees !!! All inclusive (note the
point below)
• * Depending on the training location, a small
surcharge may apply (usually only applicable for one-on-one onsite
training)

• One full day (9am - 4pm)

• Our access
course is based on Certificate I in Information
Technology, specifically ICAU1131B - Operate a Database
Application
• The course is also structured to Microsoft
Office Specialist (MOS) content
• All of our Nationally recognised courses
are offered in association with Scope
Vision. Scope
Vision have won numerous National and State business awards.
Visit Scope
Vision. Courses are based on Certificate I in Information
Technology.

Not sure which course is the right one for you? Take one of our
free - zero obligation self
assessments here.

•
All courses are taught by experienced, certified and qualified instructors,
(minimum of 15 years training experience)
• Our trainers are known for their knowledge
and helpful, friendly approach
• Each course comes with six months of free
online support
Remember, our pricing structure is unique. The more people you
enrol (we recommend a maximum of 5 students per class, but will
train up to 10 in a class) the cheaper our courses become (which
is great for companies and friends).
If you have any questions, queries or comments, please do not hesitate
to contact us.

What is assumed of the Students
• Students have strong fundamental keyboard skills.
• Students have strong fundamental mouse skills.
• Students have a strong fundamental knowledge of Windows.
This course is designed for people who currently edit or manage
simple databases. Anyone who is looking for a starting point to
design their own database or who would like to get their head around
relational database concepts is an ideal candidate to attend this
course.
Please note that this course is not intended for users
new to computers. This is not a “Data Entry” course.
Attendees should already have strong fundamental keyboard and mouse
skills.
Venue and Duration
Venue:
Onsite (your premises) or Inhouse (our premises)
Duration:
Access 2003 - 1 Full Day (9am - 4pm)
Access 2007 - 2 Full Days (9am - 4pm)
Access 2010 - 2 Full Days (9am - 4pm)
Part One - Creating an Access Database
• Critical Fundamental Database Concepts
• Microsoft Access Interface
• Creating a New Database
• Starting with a new blank database
• Using a database template
• Working with Database Objects
• Exploring database objects
• Opening and accessing database objects
• Database objects views
• Moving Among Records
• Formatting Datasheets
• Modifying a Toolbar / Quick Access Toolbar
Part Two: Building Tables and Queries
• Creating and Modifying Tables
• Adding fields to a table
• Deleting and rearranging fields
• Field data types
• Assigning key fields for a table
• Using Input Masks to Control Field Entry
• Creating Lookup Fields for Easy Entry
• Modifying Other Field Properties
• Creating and Modifying Queries
• Query criteria
• Creating a select query
• Creating a crosstab query
• Creating an make table / update / append query
• Calculated Fields in Queries
• Sorting and filtering records
Part Three: Organizing Access Data
• Creating and Modifying Forms for data entry
• Creating and Modifying Forms buttons and controls
• Form properties for display and protection of data
• Viewing and Organizing Form Information
• Working with database records
• Sorting and filtering records
Part Four: Defining Relationships
• Creating Relationships based on keys
• One to one relationships
• One to many relationships
• Many to many relationships
• Setting Referential Integrity
• Cascade updates
• Cascade deletes
Part Five: Reporting & Exchanging Data
• Producing Reports
• Creating and formatting reports
• Creating reports using the report wizard
• Formatting reports and report objects in design view
• Sorting and filtering report data
• Adding calculated controls to reports
• Previewing and printing reports
• Integrating with Other Applications
• Importing data from other applications
• Exporting data to other applications
• Creating a data page for the web
home |