Realdolmen Education

Details

Designing MS Access Forms and Reports

This course is currently not scheduled on the open calendar, but can be organized on request.

Request Course

Duration

1 day(s)

Audience

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

Prerequisites

Knowledge of MS Access databases, tables, relationships and queries is required.

Objectives

At the end of this course, students will: understand the terminology relating to forms and reports; be 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. Each student disposes of a workstation.

Description

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

Contents

  • Introduction
    • Review of databases, tables, relationships, and queries
  • Forms
    • Creating forms (AutoForm, wizard, …)
    • Using forms
    • Modifying the form design
    • Sections and properties
    • Creating and using controls
    • Divided forms
  • Reports
    • Creating reports (AutoReport, wizard, …)
    • Using reports (page settings, printing, …)
    • Creating labels
    • Modifying the report design
    • Sections and properties
    • Creating and using controls
    • Sorting and grouping data