Description

The two objects used in Access to present data are Forms and Reports. Forms allow a designer to create a user friendly method of data entry. Instead of having to enter records into a grid of rows and columns you can use a form to layout the fields to resemble for example a paper based form. A form can also include fields from multiple tables so that you do not have to switch from one table to another to enter data.
A Report is a summary of information in one or more tables. You can simply print from a table or a query but if you wish to use calculations or insert graphics or customised headers and footers you will need to design a report.
This opportunity will take you through the steps of designing and more importantly modifying existing forms and reports.

Content:

1. Creating a Form
2. Working with a form in layout view
3. Changing a form in design view
4. Creating a Report
5. Changing a report in design view
6. Calculations in Reports
7. Sorting and Grouping a Report
8. Printing a Report

Level: Intermediate users

Audience: All education staff

Pre Skills:

1. Skills covered within Access 2007 – An introduction
2. Understand basic database concepts

Hardware: Personal computer (PC)

Software: Microsoft Access 2007