Formatting a Report

Diving Line


If you need to print this page out, type your name in the box below.

Your Name : 


Information

Once you have created a database report, you need to format it.

You can format a report in the same way you format a form in your database.

Open the report in Design view Databases .

When every you make any changes to your report, use the Print Preview Databases command to check that your report will looks and print ok.  You can always click on Design view again to change the report.

Databases


There are different formatting options you can use on a report ...


Information
Add a Report Heading

Use the Label tool Databases to add the business name in the header of the report.  You might need to increase the height of the header to fit the new heading in.

Databases


Format the report headings by changing the font size, font style and colour.

Databases


Back


Information
Change the Report Colour Scheme

Change the colour scheme for the report design using the Design tab.

Databases


Databases


You can select individual parts of the report and change the background colour using the Databases command on the Home tab.

Database


Back


Information
Highlighting Fields

Sometimes it is useful to highlight key information in your report.

When we created our report, we added a Grouping Level for the city.  You can select a field and heading on the report and highlight them using the bold, italics, underline, font style and font size commands.

Databases


Databases


Back


Information
Moving and Arranging Fields

Sometimes the fields on your report don't display all the data.  You might need to rearrange, move or resize different fields so everything fits correctly.

To resize a field, click on the field and drag the yellow border to make it larger or smaller.

Database  Database


You can also move fields to different places in your report.  Click on the field and drag it to its new position on the report. 

In the image below, the surname and first name fields have been moved together and the address fields have been oved together.

Databases


Back


Information
Formatting Headings

Headings on your report can be formatted, moved, resized, updated and deleted.

To format a heading, select the heading then use the formatting tools to change its appearance.

Databases

Headings can be deleted if they are not needed.  Click on a heading and then press the delete key.

You can update a heading by clicking on the heading text to it is highlighted.  Type in the new text you want for the heading.

Databases


Databases


Databases


Back


Information
Adding a Copyright Line and Contact Details

You can use the Label command Database to add a copyright statement, business address, web site address and email address to the footer (or header) or your report.

Click on the Label command and then select where you want to add the text.

Type the text in and format it using the different formatting tools.

You can move and resize the label to suit the text you have typed in

Databases


Back


Information
Add a Logo to the Header

Use the Database command to add a logo in the header of your report.


Back


PrintIT  Print out this Page

Next  Next


Last modified: Tuesday, 8 December 2020, 12:03 PM