Aims

This course is designed to provide attendees with a thorough understanding of database design. It will benefit anyone new to databases wishing to learn how to design tables, forms, queries and reports.

Objectives

On completion of this course, attendees will understand the design techniques involved in building a database as well as how to create tables, input forms and basic reports.

Prerequisites

Attendees do not need any previous experience of Access but must have a basic understanding of PC’s, including familiarity with a keyboard and mouse.

Versions

Courses are delivered in 2010, 2013, 2016, 2019 & O365.

What will I learn?

Database Introduction

  • Database concepts and terminology
  • Ground rules for database design
  • Relational database concepts
  • Getting started in Access
  • Getting help

Table Design

  • Creating a table in design view
  • Data types
  • Indexes
  • Default values
  • Validation rules
  • Input masks
  • Setting a primary key

Working with Tables

  • Adding and editing data
  • Navigating, adding, editing and deleting records
  • Finding and replacing data
  • Sorting and filtering records
  • Filtering by selection

Table Relationships

  • Relational database design
  • Creating relationships
  • Database integrity and validation

Queries

  • Creating a select query
  • Refining the results of a query
  • Add a calculated field to a query
  • Create query joins
  • Multi table queries
  • Parameter queries

Form Design

  • Create a form
  • Modify the design of a form
  • Moving, resizing and deleting controls
  • View and edit data using an Access form

Reports

  • Create a report
  • Add a control to a report
  • Format the controls in a report
  • Enhance the appearance of a report
  • Prepare a report for print

Sharing Data across Applications

  • Publish Access Data in Word
  • Analyse Access Data in Excel
  • Create a Mail Merge

How we deliver

Training can be delivered at your offices in either of the following ways:

  • Online

    Online training is ideal if you have staff in different geographical locations who have the same Microsoft or Adobe training requirements.

    Our expert trainers can deliver Watch and Learn sessions to up to 100 people. Alternatively, they can produce an interactive session that allows delegates to complete practical exercises within the Microsoft or Adobe apps of your choosing.

  • Face to face

    Choose from one or half day training sessions or our popular 90-minute Sprint sessions, which can be delivered in your offices or at another location of your choice.

    All we need is a room with a table and chairs and we look after the rest. We can even provide laptops and a projector should you not have spare IT equipment to use.

Sprint learning

Short on time, but still want to boost staff performance?
Book a Sprint Session!

Each Sprint Session follows a 90-minute format for ultra-focused team learning.

Pick a topic, tell us what you want to achieve from your session, and we’ll put together a short, fun, entirely bespoke programme that meets the needs of your team.

Designed to cater for 10-15 delegates at a time

Developed by our team to cover the subject matter of your choice

Delivered online or face-to-face

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)