Overview

Microsoft Access is now the most popular Windows database program. A major reason for its success is its revolutionary query interface. Once data is collected in a database, analysis and updates need to be performed. Queries offer the ability to retrieve and filter data, calculate summaries (totals), and update, move and delete records in bulk. Mastering Microsoft Access queries will improve your ability to manage and understand your data and simplify application development.

The presentation will look at the different types of query, including update and append queries. We will also show you how to use complex selection criteria, create calculated fields and set up SQL Union queries.

Date and Time

16 March 2006, 19:30 – 21:30

Presenters

Elaine Giles and Mike Thomas