Support

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

Excel 2003 Advanced Course
Excel 2003 Advanced Course
3 sessions available starting from $770.00
InDesign CS5 Introduction Course
InDesign CS5 Introduction Course
3 sessions available starting from $770.00
Dreamweaver CS5 Course - Introduction
Dreamweaver CS5 Course - Introduction
2 sessions available starting from $770.00

see all listings »


Found In