Byron Employment

Byron Employment. Over 71,905 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $670.00

Do you need to

Develop complex Access 2002 applications

Pre-requisites

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

Delivery

Classroom

Locations

  • Public Schedule - Canberra, Melbourne, Perth and Sydney
  • Group Bookings - all States and Territories across Australia

Duration

2 days

At the end of this course

You should be able to:

• Understand relational database design

• Enforce data validation

• Create a multi-user environment

• Employ user level security

• Use pivot tables and charts

• Enhance form objects with tab controls and OLE frames

• Understand form properties and use Auto Lookup

• Create macros to power user interfaces and custom toolbars

• Build advanced queries

• Create complex reports

• Understand data access pages

Course Content:

Relational Database Design

 

• Describe principles of good table design

• Discuss relationship types

• Understand and apply referential integrity

• Create multiple field relationships

• Use cascade updating and deleting

Data Validation

 

• Choose appropriate data types and field sizes

• Use field and table properties to enforce data validation

• Use multiple field indexes

Creating a Multi-User Environment

 

• Create and work with a split database

• Understand multi-user issues and options

Security

 

• Secure a database by using a password

• Secure a database using user-level security

• Encrypt/Decrypt a database

PivotTables and Pivot Charts

 

• Create and format a PivotTable

• Create and format a PivotChart

Form Design

 

• Use a tab control

• Work with OLE frame controls

• Understand form properties

• Understand how the Auto Lookup feature works

Macros

 

• Create a macro

• Attach macros to events

• Create a conditional macro

• Use macro names

• Create customised toolbars and menu bars

• Create an autoexec macro

• Create a keystroke driven macro

Advanced Queries

 

• Create directional joins

• Create forms for running parameter queries

• Use query wizards

• Create totals queries

• Use top values queries

• Understand SQL specific queries

Advanced Reports

 

• Use sub reports

• Create a running sum

• Create a multiple-column report

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