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 13 / 795 Beaufort St, Mt Lawley, Perth, WA.

• Nationally recognised microsoft access training

• Small group & one on one training
(recommended 5 students per class)
(maximum of 10 per class)

• A 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 11 years training experience)

• Our trainers are known for their friendly and helpful 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.

Session 1: Creating an Access Database

What is assumed of the students?

• Students have basic keyboard skills.
• Students have basic mouse skills.
• Students have a basic knowledge of Windows.

Note that this course is well suited to users who have a basic existing level of experience with microsoft access (although this is certainly not a requirement). If you would like to learn more about access as well understand database concepts in order to start building (or modify an existing) access database, this course is for you.

1.1 Microsoft Access Components
1.2 Creating a New Database

• Starting with a New Blank Database
• Using a Database Template

1.3 Working with Database Objects

• Exploring Database Objects
• Opening Database Objects Using the Shortcut Menu

1.4 Moving Among Records
1.5 Formatting Datasheets
1.6 Modifying a Toolbar

Session 2: Building Tables and Queries

2.1 Creating and Modifying Tables

• Creating a New Table in Design View
• Adding Fields to a Table
• Entering Field Descriptions
• Deleting and Rearranging Fields
• Assigning Key Fields for a Table

2.2 Using Input Masks to Control Field Entry
2.3 Creating Lookup Fields for Easy Entry
2.4 Modifying Other Field Properties
2.5 Creating and Modifying Queries

• Creating a Select Query
• Modifying a Query in Design View

2.6 Adding Calculated Fields to Select Queries

Session 3: Organizing Access Data

3.1 Creating and Modifying Forms

• Creating Forms for Painless Data Entry
• Modifying Form Properties

3.2 Viewing and Organizing Information

• Working with Database Records
• Sorting and Filtering Records

Session 4: Defining Relationships

4.1 Creating Relationships
4.2 Setting Referential Integrity

Session 5: Reporting & Exchanging Data

5.1 Producing Reports

• Creating and Formatting Reports
• Creating Reports Using the Report Wizard
• Formatting Reports & Report Objects in Design View
• Adding Calculated Controls to Reports
• Previewing and Printing Reports

5.2 Integrating with Other Applications

• Importing Data from Other Applications
• Exporting Data to Other Applications
• Creating a Simple Data Access Page for the Web

home

Onsite training at our clients premises. We come to you !! Alternative venues available.

We provide laptop computers for the duration of the course. No strain on your IT resources.

All courses come with a quality manual, workbook & exercise cdrom, unlike other providers.

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.