Access Training Courses All Levels – F2F or Online

Duration: 1 Day

Course Objective:

EXAMPLE OUTLINE BELOW To give an introduction to database design concepts. This course offers grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level.

Course Contents:

Introduction to MS Access

  • What is an Access Table?
  • What is an Access Query?
  • What is an Access Form?
  • What is an Access Report?
  • What is Tell Me (new)?

Working with MS Access

  • Starting Access
  • Exploring backstage view
  • Using the Access ribbon
  • Opening an existing Access database
  • Navigating Access
  • Quitting Access
  • Launch Access from a modern template (new)

Working with Tables

  • Opening an existing Access table
  • Adding, editing and deleting records
  • Finding specific records
  • Sorting and filtering the data
  • Hiding and unhiding columns
  • Printing the table
  • Freezing columns
  • Moving columns

Planning a MS Access Relational Database

  • Creating tables
  • Using quick start fields
  • Setting field properties
  • Setting the primary key
  • Defining relationships
  • Setting referential integrity
  • Creating lookups
  • Creating calculated fields

Working with Forms

  • Creating a form with the form wizard
  • Opening and editing a form
  • Adding, editing and deleting records
  • Find and replace records
  • Filtering data in a form

Introduction to Select Queries

  • Create select queries
  • Adding & deleting fields
  • Sorting records in the design view
  • Using query criteria
  • Adding calculated fields
  • Summarising data

MS Access Reports

Enquire About Access Training Courses All Levels – F2F or Online Course
This course can be tailored to meet your exact requirements.
 

* fields are mandatory.

What our attendees have said about us:
The trainer explained clearly and ensured I understood each part before moving on. There was ample opportunity to ask questions and I was made to feel at ease.
The BCI
Gave some useful tips which will make life easier. Good delivery of course content.
London Borough of Redbridge
Excellent performance, great knowledge of the subject and very easy to listen to.
AIG
Clear, concise and coherent tutor. Many thanks for this useful course.
Jack Tizazrd
Lively, alert, kept on track with course. The course was very beneficial to me, excellent.
Port of Tilbury
A very well run course, knowledgeable and istructive.
Angell Town Housing
Very good and well structured. Very engaging.
Bank of England
Clearly spoken, informative, gave me good advice and tips. Would recommend this course.
Dental Health Centre
Approachable and helpful. The tutor made the subject interesting.
Sutton High School