Microsoft Access Foundation

Access Training courses Glasgow, Edinburgh, ukCourse Overview

Duration: 2 Days

Pre-requisites: Delegates should have attended a Windows course or have been using Windows for a reasonable length of time. Some typing skill would be an advantage.

Aimed at: First time users of Access for Windows.

Objectives: On successful completion of the course delegates will be able to Create and Maintain Access Databases and Create Queries and Reports. To gain a good understanding of the capabilities of the program.

Course Content:

Lesson 1: Overview Of Database Basics

  1. Adding Data To A Database
  2. Getting The Best View Of Your Data
  3. Saving Time With Forms
  4. Finding Information
  5. Printing Existing Reports
  6. Database Overview- Practice Exercise

Lesson 2: Tables: Creating And Importing

  1. Creating New Tables With The Table Wizard
  2. Using Design View To Create A New Table
  3. Getting External Data
  4. Understanding Relationship
  5. Tables/Relationships – Practice Exercise

Lesson 3: Retrieving Information From Your Database

  1. Creating And Saving A Query
  2. Parameter Queries
  3. Summarising Data In A Query
  4. Changing The Query Type
  5. Crosstab Query
  6. Viewing A Crosstab Query In Design View
  7. Finding Unmatched Records
  8. Creating A Report From A Parameter Query
  9. Some Commonly Used Query Criteria
  10. Queries – Practice Exercise

Lesson 4: Designing Your Forms

  1. The Form Design Window
  2. Creating A New Form
  3. Using Forms And Subforms
  4. Using Command Buttons
  5. Forms – Practice Exercise

Lesson 5: Designing Your Reports

  1. Designing Reports – Practice Exercise
  2. Creating Mailing Labels

Lesson 6: Designing A Database

  1. Design Concepts
  2. New Database Command

Further Training:

Access Workshops.

The above is an outline intended as a guide only; topics may not be covered in this order. Actual course content will be tailored to suit client’s needs.

Contact John Cowie on 0791 787 4739 to book your course, or use our enquiry form to send us a message.