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 2007 Intermediate

3 sessions available starting from $390.00

Subject: Microsoft Access

Ages: All ages

Skill level: All difficulty levels

TARGET AUDIENCE&PURPOSE

This Access Intermediate 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...

see more

TARGET AUDIENCE&PURPOSE

This Access Intermediate 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
Exporting Data to an Excel Workbook, Saving Export Setup, Dragging and Dropping Data into Excel, Creating Word Mail Merge Documents

* Using Advanced Database Features
Importing Data, Linking Data to an Access Table, Using the Linked Table Manager, Exporting Data, Converting Files, Printing a Relationship Document, Compacting a Database, Using Name AutoCorrect, Backing Up a Database

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

* Using Controls and Layouts
Switching Views, Using Controls, Using Control Layouts, Using a Stacked Layout, Using a Tabular Layout, Removing a Control from a Layout, Moving Controls, Viewing the Properties of an Object, Changing a Control Property, Manipulating Controls

* Using Other Form Techniques
Creating a Split Form, Converting an Existing Form to a Split Form, Editing a Split Form, Adding a Command Button, Saving a Form as a Report

* 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

* Using PivotTables and PivotCharts
Creating a PivotTable View, Creating a PivotChart View, Using Other Form Techniques

* Creating Macros
Working with Macros, Opening the Macro Tools Window, Creating a Macro, Displaying Macro Design Arguments, Assigning an Argument to an Action, Saving a Macro, Using Single Step Mode for Testing, Running a Macro, Editing an Existing Macro

* Using Macros
Using Properties, Creating Embedded Macros, Assigning a Macro to a Control, Creating a Command Button, Adding a Condition to a Macro, Creating a Group Macro, Creating an Autoexec Macro

* Collecting Data by E-mail
Understanding When to Use Data Collection, Using the Collect Data By E-mail Messages Wizard, Setting Data Collection by E-mail Options, Manually Processing Replies

* Customising the Navigation Pane
Creating Custom Categories, Creating Custom Groups, Adding Database Objects to a Group, Showing/Hiding the Unassigned Objects Group, Deleting Objects from a Group

Duration: One Day

see less

Choose from 3 available sessions:

When

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

Where

  • 83 York St
    Sydney, NSW 2000

Price: $390.00

Notes: Course Inclusions * Comprehensive learning materials incl. exercise... 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

Type

  • Class / Group Sessions

When

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

Where

  • 83 York St
    Sydney, NSW 2000

Price: $390.00

Notes: Course Inclusions * Comprehensive learning materials incl. exercise... 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

Type

  • Class / Group Sessions

When

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

Where

  • 83 York St
    Sydney, NSW 2000

Price: $390.00

Notes: Course Inclusions * Comprehensive learning materials incl. exercise... 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

Type

  • Class / Group Sessions



My Other Listings

Microsoft Word 2002 / 2003 Long Documents
Microsoft Word 2002 / 2003 Long Documents
2 sessions available starting from $390.00
Advanced Excel VBA
Advanced Excel VBA
2 sessions available starting from $780.00
Adobe Illustrator Essentials
Adobe Illustrator Essentials
2 sessions available starting from $795.00

see all listings ยป


Found In