About This Training Course

This Perth Microsoft Access Training - Introduction 2010 Course aims to give new users the skills to create and maintain database tables, queries, screen forms and reports using this powerful database management program.

Subjects Covered

This Microsoft Access Training - Introduction 2010 Course will cover the following subjects:

ACCESS 2010
• The Ribbon
• The backstage area
• The Quick Access Toolbar

DATABASE CONCEPTS
• Database management
• Scoping your Database
• Relational Database concepts
• Database Objects

DATABASE TABLES
• Working with database tables
• Design and create database tables
• Working with Lookup Tables
• Working with Table Structure
• Creating calculating fields in a table
• Using the primary key
• Adding/editing information to a table
• Working with Transactional records
• Sorting and filtering data on a table

SELECT QUERIES
• Query concepts
• Designing a select query
• Setting query criteria
• Using wildcards in query criteria
• Create calculations in queries

WORKING WITH FORMS AND REPORTS
• Create a Form using the Form Wizard
• Create a Report using the Report Wizard
• Working with grouped Reports
• Creating statistical Reports
• Printing Reports

Training Course Outcomes

At the end of the Microsoft Access Training - Introduction 2010 Course, participants will have an understanding of important database management concepts and be able to create and maintain database tables, queries, screen forms and reports using Microsoft Access.

Prerequisites

A familiarity with the computer keyboard and Windows is desirable.

Other Information

Put MICROSOFT on your resume!
ATI-Mirage in Perth is an Authorised Testing Centre for Microsoft Office Applications - enabling YOU to gain Microsoft Office Specialist certification, a globally recognised credential which PROVES the skills you have gained in desktop computing and helps you to achieve higher productivity and efficiency than your peers!

If you need further information contact Startnextweek.com.au on 1300 728 102