Learning Outcomes:
At the completion of this course you should be able to:
understand how Microsoft Access is used and how to navigate around it
create a database structure using Microsoft Access
create a relational database file with multiple tables
modify the structure of an existing table
set table relationships and join tables together
add records to a new table
add transactional records to a lookup database
work with the records in a database table
format the data in a table
sort and filter records in a table
export records to and import records from a wide variety of sources and applications
create and use a variety of forms
modify and adapt an existing form according to specific needs
create simple and effective queries
create meaningful reports from tables
Pre-requisites:
The course assumes little or no knowledge of the Access software.
You must have a general understanding of personal computers and the Windows operating system environment. If you need help with basic computer skills or are worried in any way whether this is the right course for you, please book a place on the Supported IT Self-Study 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.