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 )

Code	Course	Duration	Outline
ICAITU131a	Access Essentials	1 day	download view
	Course Enrolment Form		download
CHECK COURSE DATE AVAILABILITY

• 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

Onsite training at our clients premises. We come to you !! Our venue is also available.

At your premises, we provide laptops for the course. No strain on your IT resources.

All courses come with a quality manual and downloadable practice files.

Cost-effective price structure. The more students you enrol, the cheaper the course.

Structured (but flexible) nationally accredited curriculum.

Courses are also designed around Microsoft Office User Specialist certification.

Small personalised groups and one-on-one training.

6 months of free post-course support.

We can also design and provide custom, tailor made courses.

Certified, qualified and experienced trainers.

Training some of the biggest companies in Western Australia.