Working with Databases
Project 4: Forms & Reports

Title: Jan's Illustrated Computer Literacy 101
Did you want: Working with Databases: Access 2007, 2010, 2013, 2016

Project Objectives


  • Import/export data and objects
  • Link tables
  • Repair broken table links


  • Create a form with wizard
  • Create a form manually
  • Change properties of the form
  • Change properties for controls on form
  • Move/resize controls
  • Add/remove controls
  • Create/edit form header/footer
  • Control tab order on form
  • Manage images on form and in records
  • Create tabbed form
  • Create printable form


  • Create a report with wizard
  • Control printing
  • Create a report manually
  • Change properties of the report
  • Change properties for controls on report
  • Create/edit report and page header/footer
  • Group records
  • Create simple totals
  • Create totals for calculated controls
  • Share reports with several methods

Special Forms and Reports:

  • Create a switchboard form
  • Create a custom dialog
  • Use the Label Wizard
  • Use the Chart Wizard
  • Create a multiple column report
  • Create subform
  • Create subreport

Where you are:
JegsWorks > Lessons > Databases

Before you start...

Project 1: Intro

Project 2: Access Basics

Project 3: Tables & Queries

Project 4: Forms & Reports Arrow: subtopic open
    Import/Export/LinkTo subtopics
    Designing FormsTo subtopics
    Designing ReportsTo subtopics
    Special Forms & ReportsTo subtopics
    ExercisesTo subtopics


Forms and reports have different purposes and different looks, but the design view is similar for both. So, much of what you learn about one will apply to the other. There is just enough difference to make things "interesting".

You can easily wind up with more reports in your database than anything else.

An Example Database: Day Camp

I used versions of this database for multiple day camps. I have changed the names, addresses, and phone numbers. The database has only 3 tables and one form, but quite a number of queries and reports. I used some queries directly, without ever tying them to reports. Once the data is in your database, you can get very creative with what questions you can answer!

Tables Queries

Forms Reports

We will continue to use the Language Arts database as the primary source of examples but you will see the Day Camp database again in some of the lessons on reports.

Before digging into forms and reports, you will first learn to import and export both data and objects and to link tables. You will use these skills to set up a new database to work with in this project.