Send to a Colleague Print Bookmark

Advanced Microsoft Access 2003 - Masterclass

Access 2003 users looking to enhance their skills will learn to design a secured, multi-user database. Create formula-driven validation, analyse data, create queries and more.

Quick Facts

 

$990 incl GST

Duration: 2 Days

Class Size: 10

Level: Advanced

Times: 9.00am - 5.00pm approx

 
 

About the Course

This 2 day course builds on the foundations covered in the Fast Track to Microsoft Access 2003. Learn about advanced data validation, split a database, optimise performance, and gain familiarity with Joins, Union Queries and Cartesian products. Instructors will teach participants about SQL syntax, security features, basic VBA commands, and other advanced features. At the completion of the formal sessions a workshop is conducted where the participants will be encouraged to use their own database model and ideas.

Who should do this course?

This course is designed for people who already have a good understanding of Microsoft Access, and need to upgrade their skills. Upon completion participants should be able to effectively design a secured, multi-user database.

Prerequisites

Students should have completed the FastTrack to Access 2003 course, or have equivalent practical knowledge, including database design, tables, queries, forms and reports.

Course Units

Unit 1: Data Validation
- Using Expressions to Validate Data
- Limitations of Data Validation
Unit 2: Normalising a Database
- First Normal Form
- Second Normal Form
- Third Normal Form
- Bryce-Codd Normalisation
- Breaking Normalisation Rules
Unit 3: Splitting a Database
- Why Split a Database?
- Using the Database Splitter
- Linking Tables Manually
- Updating Links
- Using Multiple Linked Tables
Unit 4: Action Queries
- Make Table Queries
- Append Queries
- Update Queries
- Delete Queries
Unit 5: Aggregate Queries
- Grouping Data
- Analysing Data
  • Sum and Average
  • Count, Min, Max
Unit 6: Cross tab Queries And Pivot Tables
- Analysis Periodic Data Using Pivot Tables
- Using Pivot Tables
- Using Pivot Charts
Unit 7: Table And Query Relationships
- Cascading Updates and Deletes
- Searching for Orphan Records
- Join Types
  • Inner Joins
  • Left and Right Joins
  • Union
- Understanding Access SQL
Unit 8: Database Security
- Database Passwords
- User Level Security
- Creating a Custom Login Page
Unit 9: Introducing Access VBA
- VBA Fundamentals
  • Msgbox and InputBox
  • IF Statement
  • Reacting to User Input
Unit 10: Advanced Form Design
- GUI Design
  • Developing a Standard GUI
  • Screen Size / Resolution Issues
- Applying and Clearing Form Filters
- Modifying where Clause’s
  • AND and OR
  • Including String Delimiters
- Cascading Combo Boxes
- Validating Form Data
Unit 11: Building a Reporting System
- Passing Parameters
  • Via Forms
  • Via Objects
- Parameter Fields
  • Combo Boxes
  • Text Boxes
  • Check Boxes
  • Option Groups
Unit 12: Advanced Reporting System
- Hiding Sections
- 'On NoData’ Event
- Report Formatting Techniques
  • Shading Alternate Lines
  • Custom Numbering Techniques
Unit 13: Extending Beyond Access
- Access ADP Format
- Moving to a Server Model
  • SQL Server 2005
  • MySQL
- Using XML Data within Access
- Using Access Data on the web

Upcoming Courses

Sydney

Level 11, 32 Walker Street
North Sydney
View map

Date: upon demand

Melbourne

Level 12, 379 Collins Street
Melbourne
View map

Date: upon demand

Brisbane

C/- Support Technology, Level 6, 371 Queen Street
Brisbane
View map

Date: upon demand

Canberra

C/O Atlas Business Services, 21 Barry Drive
Turner
View map

Date: upon demand

Adelaide

C/- Mindfull Computer & Seminar, Level 4, 74 Pirie Street
Adelaide
View map

Date: upon demand

Perth

C/- Lansen Consulting Pty Ltd, Level 1, 484 Albany Highway
Victoria Park
View map

Date: upon demand
 

$990 incl GST

Duration: 2 Days

Class Size: 10

Level: Advanced

Times: 9.00am - 5.00pm approx

 
Man and woman sitting at a computer SEEK logo