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.

Access 2007 Advanced Course

2 sessions available starting from $770.00

Subject: Microsoft Access

Ages: All ages

Skill level: All difficulty levels

The course builds on existing databases covering the aspects required to develop a front-end of a database system including the use of advanced queries, advanced form and reporting techniques. This course also introduces the fundamentals necessary to develop successful custom multi-user applications in Access.

Duration:

2 Days

Audience:

Participants who need to create advanced databases or need to finalise a database for other users.

Prerequisites:

Participants must have completed the Intermediate level course or have equivalent knowledge.

Course Content:

Advanced Queries

• Finding Null Values
• Changing the Join Type
• Queries using Blank /Null Fields
• Advanced Calculations in queries
• Using Date Functions in a query
• Crosstab Queries
• Creating a Crosstab...

see more

The course builds on existing databases covering the aspects required to develop a front-end of a database system including the use of advanced queries, advanced form and reporting techniques. This course also introduces the fundamentals necessary to develop successful custom multi-user applications in Access.

Duration:

2 Days

Audience:

Participants who need to create advanced databases or need to finalise a database for other users.

Prerequisites:

Participants must have completed the Intermediate level course or have equivalent knowledge.

Course Content:

Advanced Queries

• Finding Null Values
• Changing the Join Type
• Queries using Blank /Null Fields
• Advanced Calculations in queries
• Using Date Functions in a query
• Crosstab Queries
• Creating a Crosstab Query using the wizard
• Formatting a Crosstab Query
• Crosstab query in a Report
• Manual Crosstab Queries
• Criteria with Crosstab Queries

Advanced Forms

• Subforms and Subreports
• Displaying a Subform in Datasheet View
• Displaying a Subform Total
• Locked and Enabled Property
• Limiting User Access to a Form

Modal Forms

• Modal Dialog Boxes
• Creating a Modal Dialog Box
• Adding Controls
• Setting Properties
• Formatting your Dialog Box

Automating Forms

• Creating Navigation Buttons
• Use Buttons to Add / Find Data
• Finding Data on a Form using a Combo Box
• Exporting Your Form
• Sending a Form via E-Mail
• Managing Replies
• Exporting your Form to XML

Advanced Form Controls

• Tab Page Control
• Inserting Pages in a Tab Control
• Formatting the Tab Controls
• Page Index
• Pictures on Tab Pages
• Tab Width and Tab Height
• Other Tab Control Properties
• Adding Controls to a Tab Control
• ActiveX Controls
• Registering an ActiveX Control
• Calendar Control

Advanced Reports

• Reports using Parameter Queries
• Modify the Report Record Source
• Advanced Groups in reports
• Grouping on Text fields
• Grouping on Date/Time fields
• Grouping on Multiple Sections
• Adding Graphics to Reports

Integrating with Word and Excel

• Mail Merge with Word
• Analysing Data with Excel

Creating Charts

• Chart Wizard
• Resizing a Chart
• Modifying the Chart
• Components of a Chart
• Fill Colour, Pattern and Textures
• Legends
• Changing the Chart Type
• Adding a Chart to a Report

Pivoting Data in Access

• Creating a PivotTable
• Creating a PivotTable
• More about PivotTable Fields
• Completing your PivotTable
• Creating a PivotChart
• More about PivotChart Fields
• Completing Your PivotChart

Database Maintenance

• Analysing Performance
• Analysing Tables
• Viewing Object Dependencies
• Splitting a Database

see less

Choose from 2 available sessions:

When

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

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $770.00

Type

  • Class / Group Sessions

When

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

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $770.00

Type

  • Class / Group Sessions



My Other Listings

Visio 2003 Course | Introduction
Visio 2003 Course | Introduction
3 sessions available starting from $350.00
Microsoft PowerPoint 2010 Course | Introduction
Microsoft PowerPoint 2010 Course | Introduction
2 sessions available starting from $350.00
Essential Skills for Admin Professionals Course
Essential Skills for Admin Professionals Course
4 sessions available starting from $870.00

see all listings »


Found In