Byron Employment

Byron Employment. Over 71,908 Jobs Australia Wide.

Delivery Method

  • Classroom

Course Overview

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

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
CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (08) 8941 2344
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (08) 8941 2344 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search