Suite 2/2 Shepherd Street
GPO Box 1815
Darwin NT 0801
Phone: 08-89412344
Fax: 08-89410141
Email: dcainfo@iinet.com.au

 
   
Consulting
Training
Secetarial
Calendar  
 
Home
Access: Intermediate


Course Outline

Duration
3 half days

Prerequisite
Experience with Access Introductory functions.

Objectives
To provide a thorough understanding of the comprehensive concepts and skills that will enable the participant to effectively use Microsoft Access.

Methodology
Group and individual instruction, hands on practical exercises, visual aids, comprehensive course documentation.

Confirmation of Assessment Plan
This will be issued to the trainee at commencement of training session.

Expected Outcome
By the end of the course the participant should be able to use the following functions and features of Microsoft Access.


CONTENT

Review of Basics

Importing Records

  • Importing Overview
  • Importing from Microsoft Excel
  • Importing from a text file
  • Importing from a database
  • Quick Review

    Sorting Data
  • Sorting Overview
  • Sorting data in a Column
  • Sorting contiguous data
  • Sorting non-contiguous data
  • Quick Review

    Parameter Queries
  • Overiew of parameter queries
  • Creating a parameter query
  • Saving a parameter query
  • Running a parameter query
  • Creating a data query
  • Creating a value range parameter query
  • Quick Review

    Calculated Queries
  • Overview of calculated queries
  • Creating calculated fields
  • Formatting calculated fields
  • Nested calculations
  • Using calculated fields
  • Calculations that summarise
  • Grouping summaries
  • Quick Review

    Mailing Labels
  • Overview of mailing labels
  • Using the label wizard
  • Printing labels
  • Creating a query for labels
  • Creating a label report from a query
  • Creating a custom label
  • Quick Review

    Relational Databases
  • Relational database overview
  • Types of relationships
  • Referential integrity
  • Developing a database system
  • Developing the overall concept
  • Mock up report
  • Determining the data fields
  • Entering sample data
  • Normalising the database
  • Achieving first, second and third normal forms
  • Data modelling workshop
  • Quick Review

    Multi-Table Systems
  • Multi-table database overview
  • Creating the tables
  • Importing lookup data
  • Using the lookup data
  • Creating a manual lookup
  • Setting relationships
  • Creating a related query
  • Testing the relationships
  • Quick Review

    Relational Forms
  • Overview of relational forms
  • Creating a relational form
  • Using a relation form
  • Changing the form layout
  • Changing subform column widths
  • Totalling subform values
  • Passing a value to the main form
  • Running the modified form
  • Quick Review

    Relational Reports
  • Relational report overview
  • Creating a relational query
  • Creating a nested query
  • Creating a relational report
  • Modifying a relational report
  • Running a relational report
  • Quick Review

    Access Macros
  • Overview of Access macros
  • Working with a macro
  • Creating simple macros
  • Running macros
  • Placing macros on forms
  • Running macros on forms
  • Adding more macros
  • Quick Review

    Conclusion
  • Where to from here
  • Further reading and consolidation
 
 

Registration
Contact
Tips
Clients
Venue Hire
Testimonials
Training Files