Learning Outcomes:

At the completion of this course you should be able to:

• querying using multi-table queries

• generating a parameter query to prompt for criteria

• creating, editing and formatting calculated fields

• summarising data in a query

• learning how to concatenate fields together

• developing aggregation queries to produce totals, averages, counts, etc

• using action queries such as make-table, delete and append to manage the database

Pre-Requisites:

Participants must have attended the "Microsoft Access - Introduction" or "Microsoft Access - Simple Queries and Reports" course

 

Process:

Course Leader input, demonstrations, and hands-on practical sessions.

Pre-Requisites The class manuals are for REFERENCE ONLY and must not be removed or defaced.  If you wish to download or print the manual please follow the link.

If you are not already familiar with these policies, you are strongly advised to read them:
Click here to view the University Data Handling Policy
Click here to view the University Data Protection Policy

If you have any questions about the content of these policies then please contact infosec@nottingham.ac.uk or see https://workspace.nottingham.ac.uk/display/GDPR/Information+Compliance+Team+Home for more information.