Choose from our list of courses
Join the
Assist Training
& Consultancy Ltd

mailing list
Email:


24 Barrington Street
Limerick, Ireland.
353 (0) 61 317500
353 (0) 61 316517
info@assisttraining.ie

© Images and content
copyright


Website Designed By
Graphic Index

Hit Counter

1 Day Corporate Training

Computer Training Courses

Microsoft Access 

Course Level: Introduction

Click on the escalator to select another level.

Course Objectives:

To become familiar with the principles of databases
To be able to create and use your own database

Prerequisites:

Knowledge of Windows, Word and preferably Excel

Duration:

1 Day

Course Content:
Session 1 - Introduction
  • Introduction to the course
  • Discussion of needs
Session 2 - The Database Window
  • Introduction to Tables, Forms, Queries and Reports
Session 3 - Using Forms
  • Adding, Deleting and Modifying Records
  • Finding Records
  • Sorting and Filtering Records
  • Different Views
Session 4 - Queries
  • Running a Query
  • Creating Queries
  • Sorting
  • Criteria
  • * Parameters in Queries
Session 5- Reports
  • Opening and Closing
  • Creating a Report using Report Wizard
  • Mailing Labels
  • Groups and Totals Reports
  • * Design Techniques in Reports
Session 6- Tables
  • Creating a Table
  • Setting the Primary Key
  • Setting Field Properties
Session 7- Relationships
  • Viewing Relationships
  • Creating and Deleting Relationships
Session 8 - Creating Forms
  • Using the Form Wizard
  • * Design techniques in Forms
  • * Combo Boxes
  • * Calculated fields
Session 9 - Workshop
  • Workshop session based on the course, using a database required for work,covering development and, design.

*Optional parts of the course depending on ability and requirements of participants

Back to Top

Next Level Next Level - Intermediate Access

Click here to reserve a place on this course

Home I Company Profile I Accreditations I Recruitment I FAQs I Links
Course Schedule I Delivery I Where We Are I Enquiry Form I Email Us