Microsoft Access 365 Introduction Training Course Outline

Audience: This course is designed for new or self-taught Microsoft Access 365 users. The course will cover all aspects of database design and objects.

We are happy to arrange for a trainer to contact you to help tailor you course.

Course Duration: 1 day.

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Microsoft Access 365 Introduction training course 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.

At Course Completion

At Course Completion

After completing this course, students will be able to:

  • 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

Course Outline

Module 1: Introduction to Microsoft Access

  • 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? (new)

Module 2: Working with Microsoft Access

  • 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 (new)

Module 3: Working with Tables

  • 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

Module 4: Planning a Microsoft 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

Module 5: Working with Forms

  • 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

Module 6: Introduction to Select Queries

  • 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

Module 7: Microsoft Access Reports

  • Creating a report using the Report Wizard
  • Using Design View to modify a report
  • Previewing a report
  • Printing the report