Access Training Courses

Table of Contents

Access introduction Training Courses, Microsoft Access Introduction Training Courses

Access Introduction Overview

Our Access introduction training courses provides a comprehensive introduction to the essential functions and features of Microsoft Project.

This  1 day, hands-on course Microsoft Access Introduction training course helps you gain comprehensive, practical understanding of Access.

In this course, you will use Access to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Access introduction Training Courses, Microsoft Access Introduction Training Courses

Access Introduction Five Key Topics

The Access Database Screen
Working with Access Tables and Forms
Table relationships
Extracting data using Select Queries
Creating and modifying Access Reports

Access introduction Training Courses, Microsoft Access Introduction Training Courses

Course Details

Course Duration: 1 day
Course Availability: Monday – Saturday
Course Types: Group booking, 1-2-1 sessions, Bespoke & Public Courses
Course Availability: Monday – Saturday

Access introduction Training Courses, Microsoft Access Introduction Training Courses

Access Introduction Training Course Details

Course Location: Our Microsoft Access Introduction training courses can be delivered either at our London training venue or at your offices.

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

Tailored Courses: We offer a free consultant service to help tailor your course to meet your requirements.

Rate: £220 + VAT

Next Public Course: 1st September 2020

Days
Hours
Minutes
Seconds

Centre and Services

Comfortable & modern facilities
Unlimited access to out online trining manuals
Complimentary lunch
Courses delivered by Certified Trainers
Microsoft & CPD courses available

Back to Contents

Microsoft Access Introduction Training Course – Outline

  • Understand the role of Microsoft Access objects
  • Plan a relational database
  • Create fields and tables
  • Create forms from scratch or using the Form Wizard
  • Understand Select queries
  • Create calculated fields
  • Produce Reports
  • What is a Microsoft Access Table?
  • What is a Microsoft Access Query?
  • What is a Microsoft Access Form?
  • What is a Microsoft Access Report?
  • What is Tell Me? 
  • Starting Microsoft Access
  • Exploring Backstage View
  • Using the Access Ribbon
  • Opening an existing Microsoft Access database
  • Navigating Microsoft Access
  • Quitting Microsoft Access
  • Launch Access from a modern template
  • Opening an existing Microsoft 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
  • Creating tables
  • Using Quick Start fields
  • Setting field properties
  • Setting the primary key
  • Defining relationships
  • Setting referential integrity
  • Creating lookups
  • Creating calculated fields
  • Creating a form with the Form Wizard
  • Editing a form
  • Opening a form
  • Adding, editing and deleting records
  • Find and replace records
  • Filtering data in a form
  • Select queries explained
  • Creating select queries
  • Working with query views
  • Adding and deleting fields
  • Sorting records in the Design View
  • Using query criteria
  • Adding calculated fields
  • Summarising data
  • Creating a report using the Report Wizard
  • Using Design View to modify a report
  • Previewing a report
  • Printing the report
Access introduction Training Courses, Microsoft Access Introduction Training Courses
Access introduction Training Courses, Microsoft Access Introduction Training Courses
Access introduction Training Courses, Microsoft Access Introduction Training Courses
Hints & Tips