Support

MS Access 02 / 03 Intermediate

3 sessions available starting from $390.00

Subject: Microsoft Access

Ages: All ages

Skill level: All difficulty levels

TARGET AUDIENCE & PURPOSE

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

see more

TARGET AUDIENCE & PURPOSE

This Intermediate Access 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 to Excel & Word
Exporting Data to an Excel Workbook, Dragging & Dropping Data into Excel,
Creating Excel Workbooks – Office Links,
Creating Word Documents – Office Links

* Using Advanced Database Features
Printing a Relationship Document, Linking Data to an Access Table, Importing Data, Setting a Database Password, Compacting a Database, Backing Up a Database, Using Advanced Database Features

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

* Using Switchboards
Opening & Using a Switchboard, Creating a Switchboard Form, Adding a Command Button to a Switchboard, Setting Startup Option

* Using Other Form Techniques
Viewing the Properties of an Object, Changing a Control Property, Adding a Logic Control, Adding a Command Button, Saving a Form as a Report, Creating a Form Letter

* Using ActiveX Controls
Working with ActiveX Controls, Registering an ActiveX Control, Adding an ActiveX Control, Attaching an ActiveX Control,
Using ActiveX Controls

* 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

* Creating Macros (Time Permitting)
Working with Macros, Opening the Macro Design Window, Creating a Macro, Assigning an Argument to an Action, Saving a Macro, Using Single Step Mode for Testing, Running a Macro, Editing an Existing Macro, Running a Macro using the Tools Menu, Creating a Macro using the Macro Builder

* Using Macros (Time Permitting)
Using Properties, Assigning a Macro to a Control, Creating a Command Button, Adding a Condition to a Macro, Creating a Group Macro, Creating an Autoexec Macro

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 PowerPoint 2007 Advanced
Microsoft PowerPoint 2007 Advanced
3 sessions available starting from $390.00
Microsoft PowerPoint 2010 Advanced
Microsoft PowerPoint 2010 Advanced
3 sessions available starting from $390.00
Microsoft Windows XP (2002) Training
Microsoft Windows XP (2002) Training
1 session available for $390.00

see all listings »


Found In