Access 2010 - Course List

  • The course is designed to introduce users to the basics of Access and to enable them to create a database from scratch to include basic input forms, queries and reports.

    2 days

    ACC-10-01

  • Learn to navigate an existing database. Use forms to search for, add, edit and delete information. Incorporates module: ACC-10-06 Access 2010 Viewing & Searching a Database.

    2 hours

    ACC-10-02

  • Design simple forms to ease the input and display of information held in the database.

    2 hours

    ACC-10-03

  • Create simple queries to find information in a database

    2 hours

    ACC-10-04

  • Extract information from the database with reports. Use the wizard to create simple reports. Edit the properties & controls.

    Half day

    ACC-10-05

  • How to find and view information in a database through the use of existing forms, queries and reports.

    2 hours

    ACC-10-06

  • Create effective forms using some of the more advanced form design features.

    Half day

    ACC-10-07

  • Understand the types of query available. Build queries that manipulate or archive the data in a database.

    2 hours

    ACC-10-08

  • A look at the more complex reporting options. Enhance reports with the use of graphics/charts and subreports.

    Half day

    ACC-10-09

  • An overview of the VBA language in Access.

    2 days

    ACC-10-11

  • Apply security to a database and understand security files.

    Half day

    ACC-10-12

  • A session to cover any aspects of Access.

    1 hour - 1 day

    ACC-10-13