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
Participants must have attended the "Microsoft Access - Introduction" or "Microsoft Access - Simple Queries and Reports" course
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 firstname.lastname@example.org or see https://workspace.nottingham.ac.uk/display/GDPR/Information+Compliance+Team+Home for more information.