Creating a Report

A "report" allows you to control the way Access prints out the information in your database. You can control which fields are printed out and the layout of the page. You can also add labels, backgound pictures, change fonts, text sizes, etc, etc.

1. Open your database in the usual way.

2. Go to the Reports tab and click on the New button.

3. In the Design View dialogue box select Design View and choose the Table to use in the drop-down list box (in this case "sample" was chosen).

4. Go to View/Field List to shiow the Field List box. If the Toolbox is not visible, go to the View menu and select Toolbox.

5. Drag and drop the fields from the Field List box to the Form. Drag them into position as required.

6. If you have used Visual Basic, you will be familiar with the Toolbox. Use the tools in the Toolbox to creat a Label and a Text Box. (ie Click on the tool in the Toolbox, move the cursor over the Form and drag out a rectangle.)

7. The features of the resulting 'controls' can be changed through the "properties" box. To go to the properties box, right-click the control (eg right-click with the cursor over the Text Box on the Form) and select Properties from the pop-up menu.

If you had a 'comments' field in your database, a Text Box would be an ideal place to display it.

8. Right click the Label control on the Form. Click in the Fore Color field on the properties lsit and choose a colour. (At this point you could also change the font style, size, etc of the text in the Label control..)

9. Go to View/Print Preview and then print out your report. Close your report by clicking in the Close box (The cross at the top-right of the window.) and save your report when promted to do so.

Congratulations. You have just created n Access Report.

| Previous Page | Menu | Next Page | Home Page |