Byron Employment

Byron Employment. Over 145,636 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $530.00

Access 2003 - Advance to Designing a Database will make the user more proficient in the use of Access to develop relational databases. Upon completion of this course you will be able to design advanced tables, create complex queries, work with advanced form design, work with custom controls, customising startup options, work with sub-forms, create complex reports, work wit advanced macros, repairing and compacting and using Access with other applications.

Training Method

Training is conducted by professional trainers, using hands on exercises and user practise to consolidate concepts.

Prerequisite

You will need to be familiar with all the topics covered in the Introduction Database Design course and have designed their own database using 1:M relationships.

Course Content

Tables

  • Design and Concepts
  • Relationships
  • Formatting Table Fields
  • Attaching Tables
  • Exporting Information

 

Queries

  • Action
  • Update
  • Totalling
  • Crosstab
  • Parameters
  • DateAdd
  • Join Types

 

Reports

  • Group/Totals Reports
  • Multiple Grouped Reports
  • Page Breaking
  • Saving a Form as a Report
  • Chart Report

 

Forms

  • Main/Sub forms - including grand totals
  • Other Form Controls
  • Startup Options
  • The Property Sheet
  • Using VBA to automate a command button

 

Macros

  • Macro groups
  • Conditions
  • Popular Actions Described
  • Modules
  • Overview - Purpose
  • Macros vs Module

 

Other Functions

  • Repairing and Compacting
  • Security
  • Replica
  • Analyse
  • Publish with Word/Merge
  • Tools, Make MDE File...
  • Add ins
CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (03) 9372 9381
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (03) 9372 9381 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search