Microsoft Access
Advanced – 2 Days
Pre-requisites
To ensure your success, it is recommended you have completed the Access Essentials Course or possess equivalent
Canberra Level 4, 54 Marcus Clarke Street, Canberra ACT 2601 | Phone: 02 6162 2929
knowledge.
Description
Do you need to:
Expand your knowledge of relational database design
Write advanced queries
Structure existing data
Share data across applications
www.wizardcorporatetraining.com.au
Customise reports
Aim
This course is designed for students wishing to gain intermediate/advanced-level skills or individuals whose job
responsibilities include constructing relational databases, performing database maintenance, creating advanced queries
and reports, or integrating Access with other programs.
Learning Outcomes
At the completion of this course, you should have the skills and knowledge to:
Apply precision to table, query, form and report design
Gain a higher understanding of table design specifics
Restrict end-user access to the various objects within a database
Design an interface for end users to access automated processes
Topics
Key topics covered in this course include:
Customising Tables and Table Relationships Macros
Field properties Record, run and assign macros
Relationships Conditional macros and IF macros
Applied Queries SubMacros
Calculations in queries Database start-up options
Creating multi-table queries Macros Workshop
Find unmatched query Wizard Update combo box contents
Advanced Queries Disable/enable or show/hide controls on Forms
Top value queries Import data from Excel and update tables
Complex calculations Database Tools
Directional join queries Compact, repair, and backup a database
Forms running parameter queries Use the database documenter
SQL specific queries Analyse database performance
Action Query Import and export data
Action query type Switchboards
Create an update, append, delete query Use the switchboard manager
Create forms and queries Create the switchboard form
Report Design and other Reports Create a start-up form
Add custom expressions
Mail merge using Microsoft Word
