This course caters for people who have attended the Access Essentials course or have a comprehensive working knowledge of Access. They should be confident in designing tables, forms, queries and reports.
Upon completion of the 2 day Advanced Access course students will be able to create and run action queries, build crosstab queries, create calculations in forms, create pivot tables and charts as well as being able to work confidently with properties and expressions in forms, reports and queries. Students will gain a deeper understanding of the impact of relationships, cascade update and delete options when designing the relationships of an Access database. This course also covers basic macro design and an introduction to the concept and use of VBA in Access database design.