Microsoft Access 2010 Intermediate

Versions: All earlier versions and 2013 available

On-site training only

We only run this course on-site for groups. Minimum of 6 delegates, maximum of 12

Description

The intermediate course covers queries, forms and reports in particular.Forms and Reports are handled on an introductory level only.

Duration

1 day 

Unit Standards 

SAQA US # 116938.

Prerequisites

It would be an advantage to have attended the MS Access Basic course, but if the user is not going to be designing tables and ONLY going to be using existing data i.e. SQL tables or tables that have already been set up, they can start with this course.  

The delegates must have basic Windows skills; handling the mouse, opening and finding documents and basic typing skills.  Excel knowledge would be an advantage, but is not essential.

Module 1: Tools to run MS Access efficiently

  • Compacting and repairing a database
  • Making a backup of a database
  • Working with Trust centers – Trusted locations

Module 2: Queries

  • Viewing Existing Queries
  • Using the Query Window
  • Examples Of Typical Criteria
  • Creating A Query With A Sorting Order
  • Adding Another Table In The Query Design
  • Create A Query That Is Based On More Than One Table

Module 3:  Using Calculations in a Query

  • Using A Concatenation Operator In A Query (Combining Two Or More Fields)
  • Calculating Totals In A Query (Group By)

Module 4: More advanced Query options

  • Creating a query from another query
  • Determining the top 10
  • Creating a parameter query (Prompting the user to supply the criteria) 

Module 5: Printing query results

Module 6: Specialised queries

  • Crosstab Queries
  • Find Unmatched Query
  • Find Duplicates Query

Module 7: Action Queries

  • Creating a Make-Table Query
  • Creating a Delete Query
  • Creating an Append Query
  • Update Queries

Module 8: Join Types in Queries

Module 9: Forms (Introduction)

  • Creating a form with the form wizard
  • different views for a form
  • tips and tricks when designing a form
  • to insert fields not displayed on a form

Module 10: Reports

  • Creating a report using the report wizard
  • Totals/summary options on reports
  • Printing a report

Module 11: Exporting a Report as an Excel File

Module 12: Send an Access Report to a Mail Recipient (Email)  

  • PDF format
  • Excel format

Request a quotation

Full Name(*)
Please type your full name.

E-mail(*)
Invalid email address.

Phone Number
Invalid Input

Individual or company?(*)
Individual or company?

How many people require training?(*)
How many people require training?

Download course details