Microsoft Access Introduction

COURSE AIMS

This one-day course is intended for new users of Access. The course introduces delegates to the main Access components: tables, queries, forms, and reports. Delegates design a new database by first creating a table, and adding data, and then create queries, forms and reports to enhance the database.

The course is highly interactive and will encourage all delegates to join in, to enhance their own learning process and understand how this application can be applied in a business environment for the handling of large quantities of information.

KEY BENEFITS

The course will cover the main aspects of a Database as follows:

  • Create and edit a database table
  • Use queries to select data
  • View and edit data using a form
  • Create and edit simple reports to display data from queries or tables
COURSE OUTLINE

Session 1: Database Concept

  • Introduction to database terminology
  • Understanding the Access components
  • Viewing an example database

Session 2: Create and Edit Tables

  • Creating tables
  • Adding data to tables
  • Filtering data

Session 3: Forms

  • Creating forms to view data
  • Adding an item to a form
  • Adding colour and formatting
     

Session 4: Queries

  • Creating queries to display data
  • Creating queries to sort data
  • Using criteria to select records

Session 5: Reports

  • Creating reports based on tables
  • Creating reports based on queries
  • Modifying report design
     

Session 6: Course Summary

  • Create a simple database
  • Review the Access components
  • File management in Access
     
WHO SHOULD ATTEND
The course is intended for people who are unfamiliar with the application and to show the general structure of a relational database and how it functions.
WHY YOU CANNOT MISS THIS COURSE

The key elements of a database will be covered including:

  • The course will show you how a database is constructed and its main elements
  • It will show you how to build a simple database and understand its basic building blocks
  • How to construct simple Queries
WHO ARE CBH TRAINING
CBH have been delivering training into businesses for over seven years. All our Trainers come from industry so you are assured of their competence to deliver professional and practical knowledge throughout the course. All training is backed by our 90-day free support line, which can assist you when putting your learning into practice.

 

Joomla SEF URLs by Artio