Microsoft Partner

Microsoft Access 2013 Introduction

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

Course Duration: 2 days(2)

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

Course Location: This Microsoft Access 2013 Introduction training course is delivered at our training centre in London situated close to Liverpool Street station; training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you

MOS Excel Specialist / Expert Exam Costs ( optional )


All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs


View Scheduled Public Courses


reaining course

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 Content

print this page
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
  • Using the Access Ribbon
  • Opening an existing Microsoft Access database
  • Navigating Microsoft Access
  • Quitting Microsoft Access
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 reportMicrosoft

Call us now for further information Tel:08001601666