Duration

1 day(s)

MS Access: Module 3 – Designing forms and reports

Duration

1 day

Audience

The course is intended for all users who want to use MS Access to create forms and reports with the intention of storing, retrieving and processing data.

Prerequisites

Knowledge of creating MS Access databases, tables, relationships and queries is required. A good knowledge of working in a Windows environment and file management is necessary.

Objectives

Understand the terminology relating to forms and reports. Being able to create forms and reports, modify the design of forms and reports, and use forms and reports.

Methods

Instructor-led classroom training with hands-on exercises and intensive interaction between instructor and students.

Description

The scope of this is course is limited to the Report and Form objects.

Contents

• Review of databases, tables, relationships, and queries

• Forms

  • Creating forms
  • Using forms
  • Modifying the form design
  • Sections and properties
  • Creating and using controls
  • Split forms

• Reports

  • Creating reports
  • Using reports (page settings, printing, …)
  • Creating labels
  • Modifying the report design
  • Sections and properties
  • Creating and grouping controls
  • Sorting and grouping data