MS Access Intermediate

Duration: One Day

Interested in this course?

Complete the form and let us know your preferred training date. Our team will contact you to discuss your requirements and arrange a suitable course schedule.

Whether you're booking for yourself or a team, we'll work with you to find a convenient training date.

Prefer to get in touch directly? You can also email us at forrest@forresttraining.com.au, and we'll be happy to assist you.

    Target Audience & Purpose

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

    Course Inclusions

    • Comprehensive learning materials incl. exercise files
    • Post course telephone support
    • ‘Certificate of Attendance’ on completion of course
    • Morning & afternoon tea
    • Course Prerequisites

    Course 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

    MS Access Intermediate Course Content

    Download Exercise Files

    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 Panel
    Creating Custom Categories, Creating Custom Groups, Adding Database Objects to a Group, Showing/Hiding the Unassigned Objects Group, Deleting Objects from a Group