Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Category

ICT

Course type

Microsoft

Cost per course

£495 for any two half day courses +VAT
Client site, max 10 individuals

Duration

Half day

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Dates and Locations

Contact us for the latest course dates.

Book course

This course is intended for existing Access users who need to interrogate and interpret data in Flat or Related tables within an existing database using a variety of criteria.

Objectives:

By the end of the course users will be able to create, run and save queries; extract accurate data that matches criteria based on text, numbers, dates and expressions. Users will also be able to summarise data using totals and simple calculations.

Prerequisites:

Delegates attending this course should be able to open and close a database and understand the purpose of Tables, Queries, Forms and Reports.

Download Outline (PDF)

The Theory Behind a Query
  • Navigating Table Data
  • Sorting & Filtering Data in a Table
  • Showing & Hiding Table Columns
Essential Query Skills
  • Adding, Moving & Removing Fields
  • Showing & Hiding Query Fields
  • Sorting Queries by One or More Fields
  • Entering a Simple Criteria Value
Extracting Data using Query Techniques
  • Using Multiple Criteria in a Query
  • Using AND & OR Criteria
  • Entering Wild Card Criteria
  • Creating a Parameter Query
  • Querying Data from Related Tables
  • Summarising Results in a Query
  • Creating a Simple Calculated Field
Query Wizards
  • Creating a Select Query with the Wizard
  • Find Unmatched Data Query Wizard
  • Find Duplicate Query Wizard
  • Crosstab Query Wizard

Enquire about a course

Fill in your information to apply for this course. The information you provide on this application form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.