Prerequisites
Hands-on knowledge of Microsoft Windows is required with the following pre-requisites:
Able to create a database table
Able to set primary key
Able to create select queries
Able to use the AutoForm feature
Must have attended the Access 2003 (Basic & Intermediate) course
With at least one month experience using a Microsoft database product
Module 1: Overview of Microsoft Access
Relational Database Management System (RDBMS)
Basic Components of Database
Problems Resulting From Poor Design
The Application Designing Process
Module 2: Building Queries
Creating Multiple Table Queries and Setting Join Properties
Setting Query Properties
Designing Action Queries
Using Find Duplicate Query Wizard
Using the Find Unmatched Query Wizard
:: Course ACS03-A ::
Module 3: Designing and Creating Forms
Designing and Creating Forms Without Wizards
Form Properties
Control Types
Control Properties
The Toolbox
Using Expressions in Forms
Using Chart Wizard
Using Pivot Table Wizard
Module 4: Creating Reports
Creating Reports without the Report Wizards
Applying Conditional Formatting
Inserting ClipArt
Module 5: Working With World Wide Web
Creating A Hyperlink Field
Inserting A Hyperlink To A File Or Web Page
Linking To An Object In A Database
Linking To A New Document
Navigating Hyperlinks
Exporting Database Objects To HTML
Creating Data Access Page Using The Page Wizard
Creating Data Access Page In Design View
Adding A Theme To A Page
Grouping A Data Access Page
Viewing A Data Access Page
Module 6: Rolling Out an Application
Creating A Custom Form Toolbar And Menu Bar
Fine-Tuning An Access Application
Creating Main Switchboard Form
Setting Startup Properties
Distributing Upgraded Versions Of An Application
Show Or Hide Database Objects
Compacting And Repairing An Access File
Programme scope, delivery arrangements and suitability are confirmed during enquiry.