Access Query Writing

Access Query Writing

1 DayCrawley£210.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 advanced Access training course will provide you with the skills and knowledge to write and use queries that can extract information from databases.


Course Detail

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
1 DayCrawley£210.00+VAT
MORE ON CONSULTANCY

tbc

MORE ON SECTORS

tbc