Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.


MS Access 02 / 03 Intermediate

Sydney, NSW

Subject: Microsoft Access

TARGET AUDIENCE & PURPOSE

This Intermediate Access Course is for people who can already create simple databases, and want a Forms-driven database with basic automation.

OBJECTIVES

* By the end of this course participants should be able to:
* Export data from Access to other applications
* Set table field properties
* Design advanced queries and action queries
* Use charts in Access
* Create subforms and subreports
* Use hyperlinks in Access
* Create and use a switchboard

PREREQUISITES

Participants should be competent...

see more

TARGET AUDIENCE & PURPOSE

This Intermediate Access Course is for people who can already create simple databases, and want a Forms-driven database with basic automation.

OBJECTIVES

* By the end of this course participants should be able to:
* Export data from Access to other applications
* Set table field properties
* Design advanced queries and action queries
* Use charts in Access
* Create subforms and subreports
* Use hyperlinks in Access
* Create and use a switchboard

PREREQUISITES

Participants should be competent users of Access and should already be able to:

* Create a database
* Define the fields and properties for a table
* Create simple calculation and select queries
* Link tables using queries
* Create table relationships
* Create forms and modify the appearance of forms
* Perform calculations in forms
* Create and modify reports

COURSE CONTENT

* Exporting Data to Excel & Word
Exporting Data to an Excel Workbook, Dragging & Dropping Data into Excel,
Creating Excel Workbooks – Office Links,
Creating Word Documents – Office Links

* Using Advanced Database Features
Printing a Relationship Document, Linking Data to an Access Table, Importing Data, Setting a Database Password, Compacting a Database, Backing Up a Database, Using Advanced Database Features

* Using Subforms/Subreports
Working with Subforms / Subreports, Creating a Subform/Subreport, Editing the Layout of a Subform, Displaying a Subform in Datasheet View, Adding a Subform Header / Footer, Displaying a Subform Total

* Using Switchboards
Opening & Using a Switchboard, Creating a Switchboard Form, Adding a Command Button to a Switchboard, Setting Startup Option

* Using Other Form Techniques
Viewing the Properties of an Object, Changing a Control Property, Adding a Logic Control, Adding a Command Button, Saving a Form as a Report, Creating a Form Letter

* Using ActiveX Controls
Working with ActiveX Controls, Registering an ActiveX Control, Adding an ActiveX Control, Attaching an ActiveX Control,
Using ActiveX Controls

* Using Charts
Creating a Chart, Adding a Chart to a Form or Report, Activating Microsoft Graph to Edit, Changing the Chart Type, Changing the Chart Title, Formatting the Chart Title, Adding Data Labels to a Chart

* Creating Macros (Time Permitting)
Working with Macros, Opening the Macro Design Window, Creating a Macro, Assigning an Argument to an Action, Saving a Macro, Using Single Step Mode for Testing, Running a Macro, Editing an Existing Macro, Running a Macro using the Tools Menu, Creating a Macro using the Macro Builder

* Using Macros (Time Permitting)
Using Properties, Assigning a Macro to a Control, Creating a Command Button, Adding a Condition to a Macro, Creating a Group Macro, Creating an Autoexec Macro

Duration: One Day

see less

When

Please contact us for upcoming dates and/or more information about this class.

Where

83 York St
Sydney, NSW 2000

Type

  • Class / Group Sessions

Price: $390.00

 

Notes:

Course Inclusions

* Comprehensive learning materials incl. exercise files
* 12...

see more

Notes:

Course Inclusions

* Comprehensive learning materials incl. exercise files
* 12 months post course telephone support
* 'Certificate of Attendance'
on completion of course
* Light lunch plus morning & afternoon tea

see less


The teachers

COMPUTER TRAINING with Forrest

With over 15 years experience providing Computer Training solutions Australia wide...

see more

COMPUTER TRAINING with Forrest

With over 15 years experience providing Computer Training solutions Australia wide, you can be assured that whatever your requirements, we can deliver solutions to meet them. Ensuring your specific learning needs are met is our number one priority.

Microsoft Office Training is our specialty however, we provide a full range of learning solutions including courses in non-Microsoft software such as Prince2, Crystal Reports and InfoPath to name but a few. Our Professional Development Courses are also very popular and can provide you with key business skills to give you the edge over your competition.

Our modern training rooms are equipped with data projectors, networked DualCore Pentium computers, fast Internet access and 19" LCD monitors.

Forrest offers you...

Certified, experienced, professional trainers
National capability with associates in all Australian states
Small class sizes (Max 8) for personal attention
An extensive range of computer courses incl. Microsoft Office training
Access, Excel, Outlook, Powerpoint, Project, Publisher, Visio, and Word
Professional development / soft skills courses
Microsoft Certified Technical Training
Morning & afternoon tea plus light lunch when attending publically scheduled courses
Pre-course questionnaires – ensuring the right course for you
Unlimited telephone support for the course completed
Comprehensive courseware (customisable for clients in private groups)
Central location in Sydney's CBD
Modern facilities and equipment
Totally Australian owned

Getting to Know Us
Preparing you for the future.

Forrest Training Pty Ltd has been providing a wide range of innovative and custom designed courses and training services since 1994. Our training center, located in the heart of Sydney's CBD is modern and well equipped with current technologies. Forrest Training is an Australian owned and operated Training Organisation.

We have long established partnerships with training providers throughout Australia including: ACT, VIC, QLD, SA, TAS & WA and can assist with company rollouts and upgrades.

At Forrest we believe in...

BEST PRACTICE Learning Methods
Forrest Training courses are presented by qualified professional trainers and consist of a combination of trainer presentations, demonstrations, and hands-on practical sessions in which participants complete practical, work-related exercises to reinforce the topics covered. Our educators understand how people learn and can help you get the most from your training course.

Most courses are delivered over a two week period, eg two consecutive Mondays. This allows for practice between learning sessions. This internationally recognised 'Adult Education Technique' increases the retention rate for each participant. Group bookings may chose to undertake training on consecutive days.

see less