Byron Employment

Byron Employment. Over 145,636 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $680.00

Do you need to

• Develop complex Access 2000 applications

Pre-requisites:

Users should have a sound working knowledge of Access to the standard covered in the Intermediate course

At the end of this course:

You should be able to

• Understand linked tables and create a multiuser

• environment

• Create customised menus, toolbars and Form controls

• Understand and use Auto lookup

• Exchange data with other applications e.g. Excel

• Build Advanced Queries

• Create complex Reports, incorporating subreports and calculated controls

• Create Web enabled pages

• View the Code window

• Manage issues with multi-user databases

• Create advanced macros

Course Content:

Revision of Table Level Validation

• Data Validation

• Field Data Types and Sizes and Properties

• Field Properties

• Table Relationships

• Referential Integrity

Creating a Multi-User Environment

• Separating data from the Application

• Linked Tables

• Multi-user issues and options

Macros

• Creating a Macro

• Using Macro Names

• Creating a Customised Toolbar

• Creating a Conditional Macro

• Creating an AutoExec Macro

• Creating an AutoKeys macro

Enhanced Form Design

• Multi-Page forms

• Creating Dialog Boxes

• Combo Boxes and List Boxes

Using Auto lookup

• Creating an Auto lookup Query

Exchanging Data with Other Applications

• Import / Export Wizards

• Importing / Exporting fixed width text files

• Importing an Excel file

Advanced Queries

• Directional Joins

• Parameter Queries

• Forms Running Parameter Queries

• Query Wizards

• Query Properties

• SQL Specific Queries

Advanced Reports

• Sub Reports

• Linked Child and Link Master Fields Properties

• Referring to a control on a Sub Form or Sub

• Report

• Using Running Sum

Introduction to Data Access Pages

• Create a simple data entry page

• Edit data using a data access page

• Create a grouped data access page using a wizard

• Work with pages in design view

• Create a grouped data access page manually

• Summarise data on a page

• Apply a theme to a page

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 6162 2929
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 6162 2929 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search