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 Intermediate

COURSE AIMS

To provide delegates with a knowledge of how to manipulate data within a database with particular emphasis on data entry, extraction and the use of reports.  It will also examine the structure of a relational Database to provide efficient functionality and ease of accessing the data via reports and Queries.

It will also review more complex Queries and cover the Formatting of Reports including the incorporation of calculations.

KEY BENEFITS
Upon completion of this course, you will be equipped with knowledge enabling you to:
  • Import data into Access
  • Create relationships between tables
  • Use action queries to change database data
  • Create sub forms
  • Create reports which group and subtotal data
COURSE OUTLINE

Session 1: Importing Data

  • Choosing data source
  • Using the Import wizard
  • Importing from Excel


Session 2: Table Relationships

  • Understanding purpose of table relationships
  • Creating table relationships
  • Applying “Referential Integrity”
     

Session 3: Working with Forms

  • Editing forms
  • Creating forms with sub-forms
  • Adding calculation fields
     

Session 4: Advanced Queries

  • Using parameter queries
  • Creating Make-Table queries
  • Creating Append, Delete and Update queries
     

Session 5: Report Creation

  • Editing reports
  • Sorting & grouping data
  • Adding calculation fields
     

Session 6: Course review

  • Table relationships
  • Action queries
  • Forms and sub forms
     
WHO SHOULD ATTEND

This course is intended for existing users of Access who wish to gain a better understanding of database design.

We recommend that attendees have attended the Introduction course or have a good working knowledge of Access.

WHY YOU CANNOT MISS THIS COURSE
  • This course will enhance your knowledge of Access allowing you to understand database construction.
  • You will understand how to write complex Queries and understand use and construction of Database reports
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 Intermediate

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