Users will already be working with Microsoft Access and need to develop more complex relational databases, by using more sophisticated querying tools and creating multi-table forms and reports.

By the end of this course, users will be able to utilise functionality such as Action and Summary queries and create calculations in queries, forms and reports. Users will also be able to apply basic automation through the use of command buttons to make viewing, printing and closing forms and reports quick and easy.

Users should be able to create a simple relational database in Access, including creating basic relationships.  Users should also be able to interrogate and present data by creating simple queries, forms and reports.