Griffith College Logo

Microsoft Access - Introduction

Microsoft Access - Introduction

Overview

This course is designed to give an introduction to the Microsoft Access database program and provide you with the skills to input, store, manage and create reports.

This course is designed for participants who wish to design and build databases to input simple lists, produce professional reports and use all the necessary tools for mailshots.

Suggested Uses:

  • Create mailing lists or other lists such as product catalogues
  • Create professional looking reports to print just the information you are interested in at the click of a button
  • Create mailshot letters and labels
Course details
Modules
Introduction to Access
  • Types of Databases
  • Records
  • Fields
  • Creating a New Database
  • Access Structures
Managing Tables
  • Creating a Table
  • Naming Fields
  • Setting Field Properties
  • Primary Keys
  • Setting the Primary Key
  • Saving a Table
  • Entering Data
  • Adding Records
  • Inserting & Deleting Fields/Records
  • Sorting Records
  • Formatting a Table
Queries
  • Creating a Query: The QBE Grid
  • Adding fields to the QBE Grid
  • Criteria Specification
  • Expressions
  • Running a Query
  • Dynasets
  • Sorting a Query
  • Multiple Criteria Expressions
  • Specifying a Sort Order
Using Forms
  • Creating a Form
  • Saving a Form
  • Deleting a Form
  • Entering Data in a Form
  • Modifying Forms
  • Form Controls
  • Adding a Header and Footer
  • Adding and Editing Label Boxes
  • Re-sizing labels
Parameter Queries
  • Creating a Parameter Query
  • Running a Parameter Query
  • Linking Tables
  • Creating a Link between two tables
Reports & Labels
  • Creating Reports
  • The Report Wizard
  • Automatic Reports
  • Mailing Labels

Course Contacts

If you have any questions please get in touch with us at [email protected] or 01 415 0429.

Timetables

Saturday 1 Day Course from 9:30am to 5pm

Year 2017

Sep: 23

This course is also available as customised training please contact [email protected] for further information about this option.

 
How to Apply

How to apply

Directly to Griffith College Short Courses Department

Fees

Study mode: Part Time

Fee: Available on request

CTA1

Ready to take the next step?