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.


Microsoft Access Course | Level 2

4 sessions available starting from $900.00

Subject: Microsoft Access

Ages: All ages

Skill level: All difficulty levels

Course Code: DT10102
Course Duration: 2 days

Skills Gained

* Normalize tables, analyze tables, and view object dependencies; set table relationships; implement referential integrity between related tables; and set cascading deletes and updates.
* Create lookup fields and multi-valued fields; modify lookup field properties; and use a subdatasheet to add data to related tables.
* Create join queries; create calculated fields in a query; and use queries to view summarized and grouped data.
* Add unbound controls, graphics, and calculated fields to a form; and create multiple-item forms, split forms, datasheet forms, and subforms.
* Add headers and footers in a report; use functions to add calculated values in a report; print database objects and database documents; and create...

see more

Course Code: DT10102
Course Duration: 2 days

Skills Gained

* Normalize tables, analyze tables, and view object dependencies; set table relationships; implement referential integrity between related tables; and set cascading deletes and updates.
* Create lookup fields and multi-valued fields; modify lookup field properties; and use a subdatasheet to add data to related tables.
* Create join queries; create calculated fields in a query; and use queries to view summarized and grouped data.
* Add unbound controls, graphics, and calculated fields to a form; and create multiple-item forms, split forms, datasheet forms, and subforms.
* Add headers and footers in a report; use functions to add calculated values in a report; print database objects and database documents; and create labels.
* Create and modify charts in forms and reports.
* Create and modify PivotTables, create PivotCharts, and create PivotTable forms.

Course Modules

Relational databases

* Database normalization
* Table relationships
* Referential integrity

Related tables

* Creating lookup fields
* Modifying lookup fields
* Subdatasheets

Complex queries

* Joining tables in queries
* Using calculated fields
* Summarizing and grouping values

Advanced form design

* Adding unbound controls
* Adding graphics
* Adding calculated values
* Adding combo boxes
* Advanced form types

Reports and printing

* Customized headers and footers
* Calculated values
* Printing
* Labels

Charts

* Charts in forms
* Charts in reports

PivotTables and PivotCharts

* PivotTables
* Modifying PivotTables
* PivotCharts
* PivotTable forms

Prerequisites

Access 2010: Basic or equivalent experience.

see less

Choose from 4 available sessions:

When

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

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $900.00

Type

  • Class / Group Sessions

When

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

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $900.00

Type

  • Class / Group Sessions

When

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

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $900.00

Type

  • Class / Group Sessions

When

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

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $900.00

Type

  • Class / Group Sessions



Reviews

John Weber
Good experience!
  • 5/5 stars

I took CCNA class in MIS. It was pretty good, the course was hands-on and teacher was instructional. I was also...
John Weber

see all reviews »


My Other Listings

SharePoint 2007 Training Course | Governance
SharePoint 2007 Training Course | Governance
1 session available for $1,360.00
Windows SharePoint Services 3.0 in Windows Server 2008 Training Course
Windows SharePoint Services 3.0 in Windows Server 2008 Training Course
1 session available for $1,360.00
Windows Server 2008 Training Course | Security and Policy Control with Hands on Labs
Windows Server 2008 Training Course | Security and Policy Control with Hands on Labs
3 sessions available starting from $650.00

see all listings »


Found In