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 Intermediate

Upcoming Course Dates
Microsoft Access 2003 Intermediate

Melbourne

Sydney

Brisbane

Show more Brisbane courses

Show less courses

Next Level Course

Microsoft Access 2003 Advanced

Duration
2 Days (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

• Import, link and export tables
• Work with advanced table properties
• Use advanced select queries and create crosstab queries and charts, as well as use action queries
• Design forms and use subforms
• Create simple macros
• Design reports

Prerequisites

Participants will need to be familiar with all of the topics covered in the Microsoft Access Introduction course.

Who Should Attend this Course

This course has been developed for Access users want to report on and manipulate data and improve their working knowledge of the product.

Topics Covered [Click to Show All]

Introductory Revision
Database Design
Table Creation
Query Creation
AutoForm

Importing, Linking, Exporting Tables
Importing Vs Linking
Importing Tables
Drag and Drop Import
Linking Tables
Modifying Links
Exporting Tables to Access
Exporting Tables to Excel

Advanced Table Properties
Creating a Custom Format property
Input Mask Property
Validation Rule Property
Validation Text Property

Table Relationships
Understanding Join Types
Joining Tables – Relationships Window
Referential Integrity

Advanced Select Queries
Finding Null Values
NOT Queries
Summary Queries
Sum(), Avg(), Count() Queries
Parameter Queries
Queries on Multiple Tables
Changing the Join Type in a Query
Returning Top Values in a Query
Finding Unmatched Records
Finding Duplicate Records

Writing Expressions in Queries
Use the Expression Builder
Concatenating Fields
Date Functions
IIF() Function
Renaming Fields
Formatting Calculated Fields

Crosstab Queries
Creating a Crosstab Query
Modify the Wizard results

Action Queries
Make Table Queries
Delete Queries
Update Queries
Append Queries

Form Design
Adding Fields to a Form
Changing Captions
Moving Fields
Align/Distribute Field Layout
Form Properties
Form Caption
Form Borders
Removing Record Selectors
Removing the Navigation Bar
Form Control Properties
Creating & Linking SubForms

Calculated Controls on a Form
Creating a Drop Down on a Form
Create a Control
Add an Expression on a Form
Add a Button on a Form with the Control Wizard
Modifying Tab Order

Macros
Understanding Macros
Macros vs Modules
Write a simple Macro
Add a button to a form to run the Macro

Report Design
Report Design View
Report Grouping and Sorting
Report Properties
Group Properties
Adding Report Page Breaks
Adding Expressions to Reports
Insert a Logo
Adjusting Margins

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 Intermediate

Upcoming Course Dates Microsoft Access 2003 Intermediate

Melbourne

Sydney

Brisbane

Next Level Course

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 Intermediate