Creating and using Queries - DB02

General Description

The true power of a database isn't realised until you start to extract information from it. Using queries you will have the power to extract and summarise the data in your database.

Target Audience

This session is intended for participants a basic knowledge of Microsoft Access.

Pre-requisites

Participants should be competent in the learning outcomes of DB01.

Duration

3 hours

Learning Outcomes

• Create and use select queries
• Create calculated fields in queries
• Use AND / OR conditions
• Create nested queries
• Create calculations that summarise
• Create and run parameter queries
• Increment values with an update query
• Create and run a delete query
• Save and re-run a delete query