This unit focuses on how best to obtain information from your database using queries. You are given a ready-made database that will be used for storing information required when taking pupils on a school trip.You should already be familiar with the creation of a database from the previous unit Access 2003 - Getting started with databases. After completing this unit you will be able to create more complex queries like "How many pupils going on the trip have not paid the full amount OR have not returned the parental consent slip?"
Content:
Be able to use a filter to retrieve information
Be able to create a query using a wizard
Be able to create a query in design view
Be able to use operators in a query
Be able to save a query
Be able to change the format of the results of a query
