Working with Databases
Project 4: Forms & Reports

Project Objectives

Import/Export/Link:

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

Forms:

• 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

Reports:

• 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

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!

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.

~~  1 Cor. 10:31 ...whatever you do, do it all for the glory of God.  ~~

Last updated: 30 Apr 2012