Microsoft Access - Advanced - For users of 2007 / 2010
Course Code: DPZ112D
Course Type:Short-course
Qualification: There is no associated qualification; however delegates receive a Central Sussex College Attendance certificate on completion.
Duration: 1 Day (7 hours)
Date/Venue/Cost:
21 February 2012, Horsham Training Centre, £130.00
10 May 2012, Horsham Training Centre, £155.00
25 July 2012, Horsham Training Centre, £155.00
Suitable For: This course is ideal for delegates who wish to learn how to build a relational database. It is also ideal for delegates who need to design systems for others to use, or those who need to use the reporting and calculating facilities.
Entry By: Direct Entry
Entry Requirements:
Delegates attending this course should be familiar with all of the topics in our ‘Creating a Database’ course.
Course Content:
- Linking tables through a combo box
- Combo box properties
- Linking tables through relationships
- Linking tables in a query
- Using calculated fields in a query
- Totalling in reports
- Grouping and sub totalling in reports
- Introduction to macros
