Byron Employment

Byron Employment. Over 148,685 Jobs Australia Wide.

Delivery Method

  • Classroom

Duration

3 half days

Prerequisite

Experience with Microsoft Windows and use of a mouse. .

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

Forms from Scratch

  • Forms from scratch overview
  • Creating a new form
  • Working with the form layout
  • Attaching a data source
  • Adding fields
  • Selecting objects on a form
  • Moving objects and fields
  • Aligning and spacing objects
  • Saving the form
  • Auto formatting the form
  • Adding and formatting a label box
  • Changing for form behaviours
  • The view property
  • Quick Review

Display Controls

  • Overview of display controls
  • Creating a blank form
  • Adding unbound controls
  • Attaching a field to an unbound control
  • Adding a tab control
  • Adding fields to a tabbed control
  • Running the form
  • Running the subform
  • Enhancing the appearance
  • Quick Review

Selection Controls

  • Controls for selecting data
  • Adding a combo box
  • Using a combo box
  • Creating an option group
  • Using an option group
  • Adding a list box
  • Using a list box
  • Changing a control
  • Quick Review

Expressions

  • Expressions overview
  • Using the expressions builder
  • Creating expressions by typing
  • Using functions in expressions
  • Nesting functions
  • Disguising information controls
  • Using data from sub-forms in expressions
  • Creating expressions from a subform
  • Hiding error messages
  • Naming controls
  • Using expressions in calculations
  • Quick Review

Querying Techniques

  • Querying techniques overview
  • Understanding the jet engine
  • Understanding intellijoin
  • Understanding autojoin
  • Changing join types
  • Using expressions in queries
  • Changing field properties
  • Changing query properties
  • Analysing query performance
  • How to improve query performance
  • Quick Review

Cross Tabulation

  • Cross tabulation overview
  • Examining the data
  • Creating a cross Tabulation
  • Cross tabulating related tables
  • Using criteria in cross tabs
  • Creating a manual cross tab
  • Using expressions in cross tabs
  • Quick Review

Database Security

  • Security Overview
  • Setting a database password
  • Hiding objects
  • Understanding user-level security
  • The security process
  • Creating a new workgroup file
  • Creating the administrator
  • Removing the admin user
  • Logging on as the system administrator
  • Securing the database
  • Adding groups and users
  • Assigning permissions
  • Testing the security
  • Joining another workgroup
  • Quick Review

Creating an Application

  • Creating an application
  • Creating a form template
  • Using the form template
  • Using macros to automate operations
  • Macros that open forms
  • Macros that run reports
  • Macros the open tables and queries
  • Assigning macro actions to menu forms
  • More complex macros
  • Closing forms
  • Creating a dialog box
  • Using the switchboard manager
  • Automating the start up
  • Quick Review

Visual Basics

  • Visual basic overview
  • Creating a simple procedure
  • Running the macro
  • Creating a more complex procedure
  • Navigating around the module
  • Quick Review

Conclusion

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