Training Courses in Perth for: Excel | Word | SharePoint | Project | Outlook | Time Management | Access | PowerPoint | Visio | Publisher | PC Basics | Acrobat
Mobile MOUSe Mobile MOUSe Training Mobile MOUSe

Welcome to Mobile MOUSe, Perth WA

Access Essentials (Access Training Course Perth)

Course Calendar Calendar | Course Outline PDF Outline | Enrol Enrol | Course Enquiry Enquire | Course Pricing Pricing | Skills Assessment Assessment

Access LogoAccess Essentials Training Summary

Mobile MOUSe is the preferred INSTRUCTOR LED Microsoft Access course provider for Australia's largest companies.

COMPUTER SKILL SET REQUIRED: ADVANCED
TRAINING COURSE DURATION: 2 Days (9am - 4pm)
TRAINING VENUE: Our Premises (In-house Perth) or Your Premises (Onsite)

Minimum Attendance Requirements

• This course is not intended for new users to computing or MS Office
• Attendees must have strong keyboard and mouse skills
• This is not a "Data Entry" course

Training Course Overview

This Microsoft Access Training Course will take you from understanding the concepts and elements of relational database design including one to one, one to many and many to many relationships. You will learn how to plan and normalize a Microsoft Access database as well build a database from scratch right through to the completed product including queries, reports and forms using practical and realistic (and not contrived) examples.

Intended Audience

This Access course is designed for people who currently (or who are / will be required to) 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 Microsoft Access training course.


Mobile MOUSe YouTube Channel Mobile MOUSe Facebook Mobile MOUSe LinkedIn See How We Roll


Access Essentials Course Outline

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 the 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 a make table / update / append query
• Calculated Fields (formulas) in Queries
• Sorting and filtering records

PART THREE - CREATE AND MANAGE 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

Outline (PDF) Enrol Now Onsite Quote

PART FOUR - REPORTING AND EXCHANGING DATA

• Producing Reports
• Creating and formatting reports
• Creating reports using the report wizard
• Formatting reports and report objects
• 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

PART FIVE - FORMS AND THE DATABASE INTERFACE

• Creating and Modifying Forms for data entry
• Creating and Modifying Form buttons and controls
• Form properties for display and protection of data
• Viewing and Organizing Form Information
• Working with database records
• Sorting and filtering records
• Creating a simple switchboard

Related Access Courses in Perth

If you are not sure if this is the right Access course for you, why not take our zero obligation online Access training course skills questionnaire? Alternatively investigate one of our other Access Training Course options below...

Online Microsoft Access Training Courses

General Notes

Our Inhouse Microsoft Access Training in Perth is conducted at Unit 1 / 41 Action Rd, Malaga, Perth, WA or... alternatively, our Access Course can be delivered onsite at your premises (office / factory / regional / minesite).

With our onsite Access training options, we come to you with our laptop computers and projection equipment to deliver the Access course of your choice. We can also deliver custom Access training course (i.e. you choose specific aspect(s) of our Access course that you would like delivered). Our Microsoft Access training is structured to Microsoft Office Certification, in addition, every Access course comes with free online support.

What Students Say

Standard Course Inclusions

Onsite Training (Your Venue)
For all onsite Access Training we supply the following (all at NO EXTRA COST):

• The Laptops (at no extra cost)
• Face to Face Instructor-Led Training
• The Projection Equipment
• All electric cables and Power boards
• Student Manuals
• Free Downloadable Exercise Files
• Post Course Student Support
• Certificate of Attendance (On Request)
• Dynamic, Qualified Experienced trainers
• An Amazing Training Experience :-)

InHouse Training (Our Venue)
For all Access Courses our venue we supply the following at no extra cost.

• State of the Art Training Facilities
• Free Parking
• Free Refreshments
• Student Manuals
• Free Downloadable Exercise Files
• Post Course Student Support
• Certificate of Attendance
• Dynamic, Qualified Experienced trainers
• An Amazing Training Experience :-)

Our Social Media Links

Mobile MOUSe Social Media

Mobile MOUSe YouTube Channel Mobile MOUSe Facebook Mobile MOUSe LinkedIn

Microsoft Certification

Mobile MOUSe is an authorised testing center for the range of internationally recognised Microsoft Office Certifications. Click the graphic below for more information about Microsoft Office Certification.

MOS Testing Centre

Training Facts

There are many myths about training - reasons suggested for postponing skill development. Whether it's a process that is not being followed, technology under utilised – every organisation benefits from training...

More info...

© 2017 - Mobile MOUSe - Microsoft Office Training and Consulting Specialists (Perth - Western Australia) | (08) 9404 7041 | www.mobilemouse.com.au
 
 
Mobile MOUSe YouTube Channel Mobile MOUSe Facebook Mobile MOUSe LinkedIn