Support

MS Access 2007 Intermediate

3 sessions available starting from $390.00

Subject: Microsoft Access

Ages: All ages

Skill level: All difficulty levels

TARGET AUDIENCE&PURPOSE

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

see more

TARGET AUDIENCE&PURPOSE

This Access Intermediate 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
Exporting Data to an Excel Workbook, Saving Export Setup, Dragging and Dropping Data into Excel, Creating Word Mail Merge Documents

* Using Advanced Database Features
Importing Data, Linking Data to an Access Table, Using the Linked Table Manager, Exporting Data, Converting Files, Printing a Relationship Document, Compacting a Database, Using Name AutoCorrect, Backing Up a Database

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

* Using Controls and Layouts
Switching Views, Using Controls, Using Control Layouts, Using a Stacked Layout, Using a Tabular Layout, Removing a Control from a Layout, Moving Controls, Viewing the Properties of an Object, Changing a Control Property, Manipulating Controls

* Using Other Form Techniques
Creating a Split Form, Converting an Existing Form to a Split Form, Editing a Split Form, Adding a Command Button, Saving a Form as a Report

* 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

* Using PivotTables and PivotCharts
Creating a PivotTable View, Creating a PivotChart View, Using Other Form Techniques

* Creating Macros
Working with Macros, Opening the Macro Tools Window, Creating a Macro, Displaying Macro Design Arguments, Assigning an Argument to an Action, Saving a Macro, Using Single Step Mode for Testing, Running a Macro, Editing an Existing Macro

* Using Macros
Using Properties, Creating Embedded Macros, Assigning a Macro to a Control, Creating a Command Button, Adding a Condition to a Macro, Creating a Group Macro, Creating an Autoexec Macro

* Collecting Data by E-mail
Understanding When to Use Data Collection, Using the Collect Data By E-mail Messages Wizard, Setting Data Collection by E-mail Options, Manually Processing Replies

* Customising the Navigation Pane
Creating Custom Categories, Creating Custom Groups, Adding Database Objects to a Group, Showing/Hiding the Unassigned Objects Group, Deleting Objects from a Group

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

Introduction to Excel 2007
Introduction to Excel 2007
2 sessions available starting from $780.00
Microsoft Publisher 2010 Introduction
Microsoft Publisher 2010 Introduction
3 sessions available ranging from $300.00 to $390.00
Crystal Reports 11 Introduction Training
Crystal Reports 11 Introduction Training
3 sessions available starting from $1,050.00

see all listings ยป


Found In