Microsoft Access 2016 - Module B (Building on Basic Knowledge)
Course Aims:
This course introduces attendees to more advanced concepts, tools and techniques of database design and usage.
Course Pre-requisites:
This course is open to anyone seeking to expand their existing knowledge of table design, creating queries and designing forms and reports. Attendees will already have some knowledge of designing and working with the aforementioned objects, preferably as a result of having attended the Access Module A (Intro) training.
Course Objectives:
On completion of this course delegates will be able to:
▪ Improve the effectiveness of data tables by adding field properties and relationships;
▪ Extract information from data tables by using advanced query techniques; and
▪ Create more comprehensive forms and reports for the entering, viewing and printing of data.
Course Content:
Introduction and Objectives
Table Design
▪ Setting advanced field properties in tables
(input mask, validation, default value, lookup)
Designing Advanced Queries
▪ Setting join types between tables
▪ Setting top values in a query
▪ Creating calculated fields, summary queries and parameter queries
Creating Relationships Between Tables
▪ Creating relationships between tables
▪ Viewing sub-datasheets
▪ Setting referential integrity
▪ Cascade options
Working in Form Design View
▪ Manipulating controls in form design view
▪ Changing form and control properties
▪ Adding controls to a form (list boxes, check
boxes, option buttons)
▪ Using calculations on forms
Working in Report Design View
▪ Manipulating controls in a report
▪ Changing report control properties
▪ Managing sorting and grouping in reports
▪ Adding calculations to a report
▪ Controlling pagination
Using Sub-forms and Sub-reports
Action planning
Review of Programme
