Microsoft Access Advanced

Course Details

 

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.

2016

 

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
  • 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

2013

 

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
  • 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

2010/2007

 

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
  • 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

Event Properties

Event Date 03-07-2018
Event End Date 04-07-2018
Individual Price $880.00
Course Code ACADV
Location
Corporate Training Solutions Australia
Level 19, Waterfront Place, 1 Eagle St Brisbane, QLD 4000 Australia
Corporate Training Solutions Australia

Group Rate

#Registrants Rate/Person($)
3 836.00
4 792.00
$880.00 10

Location Map

Share this event: