CBH Training

Call Now: 01524 424678, Email: This email address is being protected from spambots. You need JavaScript enabled to view it. or open Contact Form

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.

 

Latest Articles

How to take Minutes Effectively WHY SHOULD YOU LEARN TO TAKE MINUTES? Minute Taking is a key skill and is often far more involved than given credit.  Many people start taking minutes with...
Finance for non-financial Managers COURSE AIMS This one day training course will look at the tools and processes you need to build, present and work with your budget, understand a Profit and Loss Statement, Cash Flow...
Business Writing COURSE AIMS Every email, report or letter speaks volumes about you and you organisation. This is why it is important to ensure that every document that leaves your organisation is crisp, professional...

Contact Us

You are here: Home Microsoft Microsoft Access Training Microsoft Access Introduction

CBH Training Logo White



CBH Training

"Work smarter, not harder!"

01524 424678
This email address is being protected from spambots. You need JavaScript enabled to view it.

 

 

Training Venues

Bedfordshire

Wyboston Lakes, Great North Road, Wyboston, Bedfordshire.  MK44 3AL

Lancashire

Greenlands Farm Village, Tewitfield, Carnforth, Lancashire.  LA6 1JH

Clawthorpe Hall Business Centre, Burton-in-Kendal, Carnforth, Lancashire.  LA6 1NU

London

1 Lyric Square, King Street, Hammersmith, London.  W6 0NB

Offices

Morecambe Office

30 Lowlands Road
Morecambe
Lancashire
LA4 5SB
T: 01524 424678
E: This email address is being protected from spambots. You need JavaScript enabled to view it.
F: 01524 424678

Huntingdon Office

PO Box 617
Huntingdon
PE29 9FT
T: 01480 718008

Follow Us







Copyright © 2012 CBH Training
All Rights Reserved
Created by Showing Off Ltd