IT & Business Systems Training Courses

Access Database Design – Essentials Course

IT Capability Banner 2

Book this course

2 Day
£440.00 +VAT

Course description

Microsoft Access is a powerful piece of software that allows you to quickly and easily create databases, and this programme looks at the key features and techniques required to achieve that.

Building a robust database is an effective way to keep track of important data, allowing you to enter and extract information quickly and easily, ultimately making your data more organised and useful.

Is it right for me?

If you want to learn how to build fully relational database systems, and you’re already competent in using a PC for business use, this essential Access training course will equip you with the necessary skills and knowledge.

What will I get out of it?

By the end of the course you will be able to:

  • Create a database
  • Build tables, forms, queries and reports
  • Create fully relational databases

Paul had exactly the right mix of humour, knowledge of database design and presentation skills to keep the sessions moving forward, answering questions and extending the challenges for those who were ready.  An excellent trainer!

Senior Buyer/Purchasing Manager, Ryman Control Systems

What does it cover?

  • Creating a new database
  • Database elements
  • Setting field properties
  • Using input masks
  • Validation rules
  • Default values
  • Setting a primary key
  • Creating lookup fields
  • Adding data
  • Deleting data
  • Sorting data
  • Data entry quick keys
  • Filtering
  • The form wizard
  • Building and amending forms
  • Entering data using forms
  • Creating select queries
  • Setting criteria
  • Creating parameter queries
  • Adding calculations to queries
  • Printing tables and queries
  • The report wizard
  • Building and amending reports
  • Error checking
  • Using layout view
  • Linking information between tables
  • One-to-one and one-to-many links
  • Defining referential integrity
  • Printing table relationships
  • Viewing a subdatasheet
  • Adding a subdatasheet
  • Deciding which tables to use
  • Adding tables to the query
  • Creating links between tables
  • Join properties
  • Field properties
  • Adding calculations
  • Adding headers and footers
  • Adding dates, times, page numbers
  • Sorting and grouping
  • Concatenating fields

Book this course

2 Day
£440.00 +VAT

Course leader

Paul Terry

L&D Consultant, IT Solutions

Need a bespoke solution?

Talk to us about setting up a course that is tailor made for you.


Enhance your potential




Nov 27, 2015

Assimilating Technology into the Workplace

Assimilating Technology into the WorkplaceThe digital revolution has been gaining momentum for the past three decades or so, and while almost everyone these days uses some form of modern tech to benefit their lives, there remain a surprising number of people who continue to resist the influx of tech

Thales Blog >


Visit us on Twitter >


Apprentices are in high demand – research by Barclays shows that £4.4bn would be injected into the UK economy if more businesses employed them. Thales UK is a proud member of The 5% Club which is focused on creating momentum behind the recruitment of apprentices and graduates into the workforce.
As part of Thales UK’s commitment to nurturing raw 

Join the discussion >


31st March - Intelligent Outsourcing, Programme Management & Organisational Health

2nd July - Digital Learning & Workforce Planning

1st October - Discovery Center launch


Book Now >