2007Ó Integrity Computer Solutions.
The
Learning Laboratory
innovate results trust
ABN: 94 081 457 454
11th Floor
Adelaide Bank Building
90 King William Street
ADELAIDE SA 5000
Tel. 1300 731 451
Fax. (08) 8231 2427
www.learnlab.com.au
labinfo@learnlab.com.au
Integrity
Training Solutions
innovate results trust
ABN: 58 309 252 680
Suite 2, Level 1
902 Mt Alexander Road
Essendon VIC 3040
Tel. 1300 731 451
Fax. (03) 9372 9382
www.integritytrainingsolutions.com
info@integritytrainingsolutions.com
A division of...
Microsoft Access Advanced Database Design - Course Outline
Duration
2 day Course
Course Aims
This course will make the user more proficient in the use of Access to develop relational databases.
Learning Outcomes
Upon completion of this course the participant will be able to:
advanced table design work with sub-forms
creating complex queries create complex reports
work with advanced form design work with advanced macros
work with custom controls repairing and compacting
customising startup options using Access with other applications
Training Method
Training is conducted by professional trainers, using hands on exercises and user practise to consolidate concepts.
Prerequisite
The participant will need to be familiar with all the topics covered in the Introduction to database design course and have designed their own database using 1:M relationships.
Course Content
Tables
Design & 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 Macro vs Module
Other Functions
Repairing & Compacting Security
Replica Analyse
Excel Analyse Publish with Word / Merge
Tools, Make MDE File
Add ins