Access 2010 Querying

Click to Enquire

Categories: Microsoft Access

£380 per delegate. This may be less for special offers on specific course dates and in-company training courses

Duration: 1 day

Trainer: S047OW

Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...

Course Overview
Course Dates

Introduction

This one-day course is aimed at people who don't know how to use Access, but have a database that they want to interrogate. The course explains the principles underlying your corporate database (if you bring a copy in, we'll do much more than this), then shows how to create queries to get at the data it contains. Learn how to select data, how to aggregate it and how to create expressions, then at the end of the course see a brief introduction to how forms and reports work.

Prerequisites

You should already be a confident Windows user to attend this course, but do not need to have used Access before. Note that most people find Access harder to learn than Excel.

Course Contents

Designing a database

- Identifying the tables
- What are relationships?
- Setting a primary key
- Using multivalue fields

Creating tables

- Defining fields
- The types of field
- Entering data

Drawing relationships (*)

- Creating relationships
- Referential integrity

Creating queries

- The query design grid
- Sorting
- Setting criteria
- Combining criteria

Advanced queries

- Grouping and totalling
- Creating expressions
- Parameter queries

Joins (*)

- Creating ad hoc joins
- Types of join

Creating forms

- Layout and design view
- Using the form wizard
- Split forms
- Creating controls

Creating reports

- Using the report wizard
- The group, sort and total pane
- Report design

Please note that any items marked with a * will be covered if time allows.

Course Times