Access Database Design – Essentials Course

Book this course

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

Other recommended courses

Show more courses +

Course leader

Richard Harker

Technical & Digital Learning Consultant

Need a bespoke solution?

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

Recent blog posts

Developing Strategic Leadership

It doesn’t matter how long you’ve been in a leadership role, there is always something new to learn...

Tweets
Press Coverage

Supporting the agents of change

Change is scary, at least for a lot of people it is. It creates uncertainty and a sense of unease, especially when it’s sudden or not handled correctly...

Enhance Magazine