Access Database Design – Essentials Course

Dates
Duration
2 Day
Location
Crawley
Price
£440.00+VAT

What is the course about?

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.

Why should I learn with Thales L&D?

There are many reasons why you should learn Access with us but here are just a few:

  • Our Access trainers are engaging and passionate experts
  • We’ll support you for 6 months after your course in case you need help back in role
  • We can take you from beginner to expert in a range of Programme courses at all levels
  • We provide a great selection of hot and cold food and drinks throughout the day, all included in the price

More information:

If you’d like to check availability or receive a PDF of our course spec, just drop us an email and we’ll send the information straight over. Don’t forget to include all your contact details and the course you are interested in.

What you’ll learn

By the end of the programme you’ll be able to:

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

What’s covered

Creating a database

  • Creating a new database
  • Database elements

Creating a data table

  • Setting field properties
  • Using input masks
  • Validation rules
  • Default values
  • Setting a primary key
  • Creating lookup fields

Working with data tables

  • Adding data
  • Deleting data
  • Sorting data
  • Data entry quick keys
  • Filtering

Creating simple data forms

  • The form wizard
  • Building and amending forms
  • Entering data using forms

Extracting data using queries

  • Creating select queries
  • Setting criteria
  • Creating parameter queries
  • Adding calculations to queries

Printing and reporting

  • Printing tables and queries
  • The report wizard
  • Building and amending reports
  • Error checking
  • Using layout view

Principles of relational databases Importing data

  • Importing data from Excel

Building relational databases

  • Linking information between tables
  • One-to-one and one-to-many links
  • Defining referential integrity
  • Printing table relationships

Sub datasheets

  • Viewing a subdatasheet
  • Adding a subdatasheet

Building multiple table queries

  • Deciding which tables to use
  • Adding tables to the query
  • Creating links between tables
  • Join properties

Advanced form and report design

  • Field properties
  • Adding calculations
  • Adding headers and footers
  • Adding dates, times, page numbers
  • Sorting and grouping
  • Concatenating fields

Case study

Prefer a bespoke course at a venue and date of your choice?

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

Customer Testimonials

Very impressed once again with Thales. I look forward to more training there.

Metering Assistant, Scotia Gas Networks PLC

Paul Terry

Course Leader

Enhance Magazine

Issue 5 out now!

READ

HAVE A QUESTION?

Talk to us about how training can enhance your business















RELEVANT BLOG POSTS

Enhance your potential

KEEP UPDATED WITH THALES L&D:

Subscribe

Blog

May 06, 2015

7 Engineering Wonders of the World - Infographic

In the relatively short space of time that people have populated the world, we have gone from living in caves and breaking into our dinner with a sharpened stone to creating things so vast and powerful they would make our stone-wielding ancestors’ jaws drop.Engineering – and with it: effective p

Thales Blog >

Tweets

Visit us on Twitter >

Group

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 >

Events

Customer Days 2015

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

12th June - A focus on Sales in a complex environment. Content TBC

4th September - Content TBC

4th December - Content TBC -

To book your space click here

 

More events >