Access Query Writing – Microsoft Training Course

Dates
Duration
1 Day
Location
Crawley
Price
£220.00+VAT

We show you all the tools and techniques you need to understand in order to quickly, easily, and accurately extract data from Microsoft Access, enabling you to be more efficient and effective in your role.

Whether you’re a new or existing Access user, this Access training course will provide you with the skills and knowledge to write and use queries that can extract information from databases.

 

 

 

What you’ll learn

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

  • Create select queries from multiple tables
  • Include calculations and parameters in queries
  • Create unmatched queries
  • Create action queries to manipulate data
  • Create de-duplication queries

What’s covered

The database structure

  • Database objects
  • Table structure
  • Keys and indexes
  • Relational databases

Query writing principles

  • Extracting data using select queries
  • Setting criteria
  • Creating parameter queries
  • Calculations in queries

Multi table queries

  • Linking tables in queries
  • Join types
  • Creating queries to find unmatched data

Query options

  • Top values queries
  • Unique values queries
  • Formatting query output

Summary queries

  • Adding totals to your queries
  • Building crosstab queries

Action queries (Part 1)

  • Using make table queries
  • Using append queries

Action queries (Part 2)

  • Using delete queries
  • Using update queries

De-duplication techniques

  • Using the duplicates query wizard
  • Eliminating duplicates using an append query
  • Finding differences between tables

Customer Testimonials

Very knowledgeable and enthusiastic. He had taken the time to understand our backgrounds and what we would use Access for.  The exercises were good and as there were extra exercises, we could work at our own pace.  The venue and food were excellent.

Scientific Officer, Home Office

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 >