COURSES | PRICING | CALENDAR | ENROL | CONTACT | SELF ASSESSMENT | DOWNLOADS | FEEDBACK  
 
  EXCEL | WORD | ACCESS | OUTLOOK | PROJECT | POWERPOINT | VISIO | INFOPATH | PUBLISHER | SHAREPOINT | ACROBAT | PC BASICS |ONLINE COURSES
  TIME MANAGEMENT | PROJECT MANAGEMENT | CONSULTING SERVICES | ONSITE TRAINING | OUR VENUE
 
» QUICK LINKS
 

ACCESS TRAINING COURSES PERTH - WESTERN AUSTRALIA

Outline | PDF | Calendar | Enrol | Enquire | Pricing

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

If you are looking for database development Mobile MOUSe offers Microsoft Access consulting services and Database Design. Email Us for more information or visit on Access Database Consulting Services page.

ACCESS COURSE VERSIONS:

Our Access Training is available in the following Access course versions:

» Access Essentials (2003)
» Access Essentials (2007)
» Access Essentials (2010)
» Access Essentials (2013)

ACCESS ESSENTIALS COURSE OVERVIEW
Skill Level: INTRO - Intermediate

THIS COURSE IS TAILORED TOWARDS STUDENTS OBTAINING THE MICROSOFT OFFICE SPECIALIST CERTIFICATION (MOS).

This Microsoft Access 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 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.

WHO SHOULD ATTEND THIS COURSE

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.

COURSE DURATION AND TRAINING VENUE

DURATION: 2 full days (9am to 4pm)
VENUE: Onsite (your premises) or Inhouse (our premises)

MINIMUM ATTENDANCE REQUIREMENTS

• This course is not intended for new users to computing.
• This is not a “Data Entry” course.
• Attendees must have keyboard and mouse skills.

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

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
• Creating a data page for the web

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 switchboard

 

[back to the top]

 

LEARN ABOUT OUR ONSITE TRAINING



ABOUT OUR ACCESS COURSE

 

Our access training in Perth is conducted at your premises (office / factory) or... alternatively, our access Courses can be delivered at Unit 1 / 41 Action Rd, Malaga, Perth, WA.


With our onsite access training options, we come to you with our laptop computers and projection equipment to deliver our access course.

 

Our Microsoft access training is structured to Microsoft Office Certification, in addition, every access course comes with free online support.

 

COURSE PRICING


Our pricing structure is unique. The more people you enrol in an access course, the cheaper the access course becomes (which is great for companies). More info...

 

For all of the reasons above (and more), Australias' biggest companies acknowledge the features and benefits of training with Mobile MOUSe. Our professional approach and intricate knowledge of the features and abilities of access have saved our clients millions of dollars after they implemented the features we have made them proficient in. More info...

 

OUR TRAINERS

 

Our trainers are known for their knowledge and helpful, friendly approach. All of our access courses are taught by experienced, certified and qualified instructors, who individually have a minimum of 15 years training experience.

 

EACH STUDENT RECEIVES


• The best Access training in Perth and Western Australia
• A detailed high quality manual -> download a sample
• Free downloadable practice files
• Online support
• A certificate of attendance (on request)
• Zero Hassle, FREE PARKING when attending at our premises

 

 

[back to the top]

» CALENDAR

Click the image below to view our current perth training schedule and potentially book your classroom seat(s).

 

Mobile MOUSe course calendar

» 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...

» CERTIFICATION

Mobile MOUSe is an authorised testing center for the range of internationally recognised Microsoft Office Certifications.

 

Microsoft Office Certification

 

More info...

» VENUE & ROOM HIRE

Need a meeting or training room? Options range from a day to a years lease.

 

More info...

 

 

 
Email Mobile MOUSe
Read our terms and conditions...