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 Advanced

COURSE AIMS

This one-day course is designed for experienced users of Access who wish to develop their knowledge in order exploit the advanced functionality of Access in order to build more complex databases.

It will cover using Switchboards to allow users easy access to reports or data entry; cover using expressions to total reports as well as exploring different join types between relational tables.

The courses is highly interactive to provide practical as well as a theoretical understanding of the advanced functionality of Access.

KEY BENEFITS
Upon completion of this course, you will be equipped with knowledge and tools that enable you to:
  • Customise and develop secure databases
  • Use database tools and utilities
  • Automate a database with macros
COURSE OUTLINE

Session 1: Performance and Database Design

  • Setting up Indexes
  • Creating and editing table relationships
  • Importing and exporting database objects
  • Creating Custom Toolbars
     

Session 2: Using Different Join types

  • Working with outer join
  • Working with inner join
  • Editing join types
     

Session 3: Automated Form Design

  • Creating Calculated Fields
  • Using the Expression Builder
  • Understanding Form Events
     

Session 4: Automating a Database

  • Controlling the Start-up of a database
  • Creating and running macros
  • Setting conditions in macros
  • Attaching macros to events
     

Session 5: Database Utilities

  • Security methods for a database
  • Convert, compact & repair a database

 

WHO SHOULD ATTEND
This course is designed for experienced users of Access who wish to exploit the advanced facilities of this software package to build more sophisticated applications
WHY YOU CANNOT MISS THIS COURSE

The course will:

  • Develop your knowledge of Access showing how to design efficient Databases
  • Show how database relationships can be edited
  • Show how to import data effectively into Access Table structures
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 Advanced

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