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.
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.