IT & Business Systems Training Courses

Access Query Writing – Microsoft Training Course

IT Capability Banner 2

Book this course

Dates
Duration
1 Day
Location
Crawley
Price
£220.00 +VAT
 

Course description

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.

Is it right for me?

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 will I get out of it?

By the end of the course you will 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

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

What does it cover?

  • Database objects
  • Table structure
  • Keys and indexes
  • Relational databases
  • Extracting data using select queries
  • Setting criteria
  • Creating parameter queries
  • Calculations in queries
  • Linking tables in queries
  • Join types
  • Creating queries to find unmatched data
  • Top values queries
  • Unique values queries
  • Formatting query output
  • Adding totals to your queries
  • Building crosstab queries
  • Using make table queries
  • Using append queries
  • Using delete queries
  • Using update queries
  • Using the duplicates query wizard
  • Eliminating duplicates using an append query
  • Finding differences between tables

Book this course

Dates
Duration
1 Day
Location
Crawley
Price
£220.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.

RELEVANT BLOG POSTS

Enhance your potential

KEEP UPDATED WITH THALES L&D:

Subscribe

Blog

Jun 30, 2015

Top 10 Missed Opportunities in L&D

The Top 10 Missed Opportunities in L&DInvestment in L&D is not simply about solving pre-existing business problems or overcoming challenges (although targeted learning can, and should, do both of those things if necessary). It is also about creating, and capitalising on, opportunities which

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

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

2nd July - Digital Learning & Workforce Planning

1st October - Discovery Center launch

 

Book Now >