Microsoft Access 2016 – Module B (Building on Basic Knowledge)

Course Code: ACCMODB16

Duration: 1 Day

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