Description

Access 2003 - Essential skills in databases looked at creating simple select queries using one table. This opportunity builds upon that knowledge and takes you through creating simple queries using more than one table. This opportunity also looks at using calculations in queries to summarise numeric data as well as parameter queries which will cut down the number of queries you will need to have in your system by making one query flexible enough to answer more than one question. The unit then goes on to look at different types of queries and how they can be used as well as looking at how you can format the output of a query to make it look neater on screen and for printing.

Content:

1. Be able to create a query using more than one table
2. Be able to create a parameter query
3. Be able to use wildcards in queries
4. Be able to perform calculations in queries
5. Know what different types of queries can be used for
6. Be able to format the output from a query
7. Be able to print the results of a query

Level: Proficient users

Audience: All education staff

Pre Skills: Knowledge gained in one of the Introductory Access units

Hardware: Personal computer (PC)

Software: Microsoft Access 2003