Microsoft Access Module B (Building on Basic Knowledge)

Download PDF copy

Course Code: ACMODB19

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 (Introduction) 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
• 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

Related Courses

Access> Module C

Download PDF copy

‍

Pricing from

Dedicated Courses

Virtual - £645 per day for up to 8 delegates

Onsite - £695 per day for up to 10 delegates

Public Schedule Courses - N/A

Notes

Onsite prices are for courses in London. For other locations, trainer expenses will apply.

All prices displayed are exclusive of VAT.

‍