Course-Prices

IT Courses

£225 per full day course

£185 per 3 hour short course

£150 per 2 hour workshop

(Travel & expenses may also be applicable).

This could work out at only £28* per person

(*based on a maximum of 8 people on a full day course)

 

Book-a-Course

 

Access

Microsoft Access Introduction Course

1 Day course

On this course you will discover the essential skills needed to create a simple database with Microsoft Access. 

You will learn to design tables and create simple queries, and to generate forms and reports using built-in tools.

Discover easy ways to get started in Access!

Who is this Microsoft Access Training Course for?

If you are new to Access or want to formalise the following basic skills:- to create simple databases or modify existing databases, create tables, simple queries, forms and reports, this course is for you.

Course Prerequisites

You should have basic knowledge of Microsoft Windows and be able to  start an application, get help, and open, close, and save files.

  Course Outline - 1 Day

 

Access Overview
  • What is a database
  • Screen familiarisation
  • Planning and designing a database

 

Access Objects
  • Object explanation
  • Moving between objects
  • Switching between Views

 

Creating and Modifying Tables
  • Building and modifying tables
  • Field names and data types
  • Setting field properties
  • Identify and assigning the primary Key
  • Using datasheet View
  • Find a record
  • Filter by selection
  • Sort records

 

 
Creating Simple Queries in Access
  • Data sources
  • Field selection
  • Selection criteria overview
  • Logical operators
  • Viewing data
  • Sorting and filtering data

 

Building and Modifying Forms
  • Create a form with the form wizard
  • Basic editing of forms
  • Adding controls
  • Moving and resizing controls

 

Reports
  • Create a report with the report wizard
  • Grouping and summary reports
  • Preview and print a report screen familiarity

 

 

Business Skills

Finance-for-Non-Financial-MA selection of core Business Skills to help your business succeed.

 

Essential courses specifically written to be practical and relevant.



Read more: Business Skills

Or go directly to specific courses details...

Soft Skills Courses

Communication-SkillsA wide range of Soft Skill courses to help you communicate and interact with people better.

 

Learning through real-life situations.

Effective and Enjoyable.


Read more: Soft Skills

Or go directly to specific course details...