Skip to content | Change text size
 

Microsoft Access 2010 Module 1

2 days

Target group:

Academic and general staff who are interested in learning how to use Microsoft Access 2010 to create and manipulate databases

Group size:Maximum 12 - Minimum numbers do apply
Level Introductory program:
  • No prior knowledge of Access is assumed
  • Use of Windows operating system and working with files and folders
    • Schedule:
    Date:Wednesday 2 May, Thursday 3 May 2012 ***FULL***
    Time:9.30am - 4.30pm
    Venue:Blue Gum Room, Building 2, Level 3, 195 Wellington Road, Clayton
    Apply by:Wednesday 25 May 2012
    Schedule:
    Date:Thursday 26 July, Friday 27 July 2012
    Time:9.30am - 4.30pm
    Venue:Blue Gum Room, Building 2, Level 3, 195 Wellington Road, Clayton
    Apply by:Thursday 21 July 2012
    Schedule:
    Date:Tuesday 18 September, Wednesday 19 September 2012
    Time:9.30 am - 4.30pm
    Venue:Blue Gum Room, Building 2, Level 3, 195 Wellington Road, Clayton
    Apply by:Tuesday 11 September 2012
    Cost: $350
    Catering:

    Morning and afternoon tea is provided.

    To apply:Online Application Form

    Overview

    This workshop will cover the basic requirements to create and use an Access database.

    Course Content

    • Introduction to Access 2010
    • Designing a Lookup Database
    • Relational Database design
    • Creating a Relational Database
    • Sorting and Filtering
    • Data Validation
    • Formatting Tables
    • Adding records to a Table
    • Adding Transactional Records
    • Working with Records
    • Modifying Table Structures
    • Creating Queries
    • Querying Techniques
    • Creating and using reports
    • Creating and using Forms

    Learning Approach

    • Hands-on workshop
    • Practice exercises

    Handouts

    A booklet of notes will be provided.