in
f
Sign Up for eNews
- First Name
- Last Name
- Email Address
- Nearest Training Location
- Interested In: Microsoft Office Professional Development Adobe Scheduled Courses In-house/Customised Training

Items 0

Total $0.00

Select Courses

Odyssey Training is a national provider of professional, computer and management training and consultancy.

Microsoft Access 2003 Advanced

Upcoming Course Dates
Microsoft Access 2003 Advanced

Brisbane

Show more Brisbane courses

Show less courses

Duration
1 Day (9:00 am – 4:00 pm)
Downloads
Practice Files
Meals Provided
Lunch and refresments
Print-Friendly
Print this page
Delivery Methods
Public, In-house, Closed Group
Skills Assessment
Take the test

Expected Outcomes

• Create advanced queries, forms and reports
• Create pivot tables and charts
• Create user friendly front end access using forms, buttons and macros.
• Use Macros and VBA to automate processes within your database.

Prerequisites

Participants will need to have attended or have a good working knowledge of the topics covered in the Access Introduction and Intermediate level courses.

Who Should Attend this Course

This course has been developed for the Access “Power User” who requires advanced skills in manipulating and presenting data in Access.

Topics Covered [Click to Show All]

Advanced Queries
Attach a Query to a Form
SQL Union Query
Writing Queries in Form Controls
Create a search field in SQL
Creating a form from a query

Advanced Forms/Reports
Referring to Subform/Subreport controls in Form Expressions

Pivot Tables
Creating a PivotTable
Understanding PivotTable Fields
Creating a PivotChart

Introducing VBA
Adding VBA to Form buttons
Adding VBA for Data Validation
VBA to modify control Visibility
Creating a Search routine in VBA

VBA Modules
Write a VBA Module
Attach Module to a Form Control
Create a Form_Load procedure Creating Front Ends and Menus
Creating a Menu
Adding Buttons
Programming Buttons
Adding artwork
Form Properties
Working with Switchboards
Navigation Forms

Database Startup Routines
Controlling Database startup

Advanced Database Management
Compact & Repair
Splitting a Database
Performance Analyser

Computer Training

Microsoft Office 2010

	Introduction	Intermediate	Advanced	VBA
Microsoft Access 2010	Microsoft Access 2010 Introduction	Microsoft Access 2010 Intermediate	Microsoft Access 2010 Advanced	VBA for Microsoft Access 2010
Microsoft Excel 2010	Microsoft Excel 2010 Introduction	Microsoft Excel 2010 Intermediate	Microsoft Excel 2010 Advanced	VBA for Microsoft Excel 2010
Office 2010 New Features	Microsoft Office 2010 New Features
Microsoft Outlook 2010	Microsoft Outlook 2010 Introduction		Microsoft Outlook 2010 Advanced
Microsoft Powerpoint 2010	Microsoft PowerPoint 2010 Introduction		Microsoft PowerPoint 2010 Advanced
Microsoft Project 2010	Microsoft Project 2010 Introduction		Microsoft Project 2010 Advanced
Microsoft Visio Professional 2010	Microsoft Visio 2010 Professional Introduction		Microsoft Visio 2010 Professional Advanced
Microsoft Word 2010	Microsoft Word 2010 Introduction	Microsoft Word 2010 Intermediate	Microsoft Word 2010 Advanced	VBA for Microsoft Word 2010
Introduction to Computers	Introduction to Computers

Microsoft Office 2007

	Introduction	Intermediate	Advanced	VBA
Microsoft Access 2007	Microsoft Access 2007 Introduction	Microsoft Access 2007 Intermediate	Microsoft Access 2007 Advanced	VBA for Microsoft Access 2007
Microsoft Excel 2007	Microsoft Excel 2007 Introduction	Microsoft Excel 2007 Intermediate	Microsoft Excel 2007 Advanced	VBA for Microsoft Excel 2007
Office 2007 New Features	Microsoft Office 2007 New Features
Microsoft Outlook 2007	Microsoft Outlook 2007 Introduction		Microsoft Outlook 2007 Advanced
Microsoft Powerpoint 2007	Microsoft PowerPoint 2007 Introduction		Microsoft PowerPoint 2007 Advanced
Microsoft Project 2007	Microsoft Project 2007 Introduction		Microsoft Project 2007 Advanced
Microsoft Visio Professional 2007	Microsoft Visio 2007 Introduction		Microsoft Visio 2007 Professional Advanced
Microsoft Word 2007	Microsoft Word 2007 Introduction	Microsoft Word 2007 Intermediate	Microsoft Word 2007 Advanced	VBA for Microsoft Word 2007

Microsoft Office 2003

	Introduction	Intermediate	Advanced	VBA
Microsoft Access 2003	Microsoft Access 2003 Introduction	Microsoft Access 2003 Intermediate	Microsoft Access 2003 Advanced	VBA for Microsoft Access 2003
Microsoft Excel 2003	Microsoft Excel 2003 Introduction	Microsoft Excel 2003 Intermediate	Microsoft Excel 2003 Advanced	VBA for Microsoft Excel 2003
Microsoft Outlook 2003	Microsoft Outlook 2003 Introduction		Microsoft Outlook 2003 Advanced
Microsoft Powerpoint 2003	Microsoft PowerPoint 2003 Introduction		Microsoft PowerPoint 2003 Advanced
Microsoft Project 2003	Microsoft Project 2003 Introduction		Microsoft Project 2003 Advanced
Microsoft Visio Professional 2003	Microsoft Visio 2003 Introduction		Microsoft Visio 2003 Advanced
Microsoft Word 2003	Microsoft Word 2003 Introduction	Microsoft Word 2003 Intermediate	Microsoft Word 2003 Advanced	VBA for Microsoft Word 2003

Microsoft Sharepoint 2010

Adobe Publishing and Web

	Introduction	Advanced
Adobe Acrobat 9.0	Adobe Acrobat 9.0 Introduction	Adobe Acrobat 9.0 Advanced
Adobe Acrobat X	Adobe Acrobat X Introduction	Adobe Acrobat X Advanced
Adobe Captivate 5	Adobe Captivate Introduction
Adobe Dreamweaver CS4	Adobe Dreamweaver CS4 Introduction
Adobe Dreamweaver CS5	Adobe Dreamweaver CS5 Introduction
Adobe Illustrator CS4	Adobe Illustrator CS4 Introduction
Adobe Illustrator CS5	Adobe Illustrator CS5 Introduction
Adobe InDesign CS4	Adobe InDesign CS4 Introduction	Adobe InDesign CS4 Advanced
Adobe InDesign CS5	Adobe InDesign CS5 Introduction	Adobe InDesign CS5 Advanced
Adobe Photoshop CS4	Adobe Photoshop CS4 Introduction	Adobe Photoshop CS4 Advanced
Adobe Photoshop CS5	Adobe Photoshop CS5 Introduction	Adobe Photoshop CS5 Advanced

Copyright
Privacy
Collection Statement

Microsoft Certified Silver Learning Partner Odyssey Training is a national Australian provider of professional, technical and management training and consultancy. We run customised training and scheduled training courses in Brisbane, Cairns, Melbourne, Sydney and Townsville. We have been a major outsource partner for local and national projects across the private and public sectors. Quality Assurance System conforming to AS/NZS ISO 9001:2008 (Certification no. 1075). Odyssey Training is also a signatory to the Government’s Information Technology Conditions v5 (GITC v5) – Q-953.

Training Schedules

Partnering with employers across Australia. Training your people, bringing out their best!

Experience that speaks for itself.

Build your team, your way!

We are an Australian training company, developing Australia’s professionals.

Microsoft Access 2003 Advanced

Upcoming Course Dates Microsoft Access 2003 Advanced

Brisbane

Related Courses

Duration

Downloads

Meals Provided

Print-Friendly

Delivery Methods

Skills Assessment

Expected Outcomes

Prerequisites

Who Should Attend this Course

Topics Covered [Click to Show All]

Training Courses

Upcoming Course Dates
Microsoft Access 2003 Advanced