Creating a Report

Diving Line


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

Your Name : 


Information

Reports are a really useful database tool.  They allow you to view, format and print information from your database tables and queries.

You can create a simple report of names, phone numbers and email addresses for all your contacts, print a list of names and addresses for a certain city, or print a list of order that have to be sent out today, this week or this month.

You can format the design of a report to include the name of the business, a logo, the business colours, the business contact details and a copyright statement.

Information

To create a report you need to click on the Create tab and then the Report Wizard command.

Databases


You can create a report from a database table or a query.  In this example, we are going to cerate a report from a query that searches for all customers who live in Leicester.

Select the table or query you want to use for your report.

Databases


Select the fields you need to include in your report.  It is tempting to add all the fields, but think carefully about what fields you need to include. 

Use the Databases button to add each field one at a time or the Databases button to add all the fields in one go.

You can always use the Databases and Databases buttons to remove fields from the report.

In this example, we are creating a mailing list report for customers who live in Leicester.  We don't need to see the Customer ID number so we wont select it.

Databasea


Click Databases.


Information

Grouping Levels allow you to organise the information in your report under headings.  This is really useful if your report will include lots of information.

In our report, we will group all our customers by city.  Select the City field and click Databases.

Databases


Information

Sorting the information in the report is also useful.  You might need to sort the information by name or post code.  Select how to sort the data and then click Databases.


Databases


Choose the best layout for your report.  Click Databases.


Databases


Give your report a useful name and then click Databases.

Databases


PrintIT  Print out this Page

Next  Formatting a Report


Last modified: Monday, 7 December 2020, 3:03 PM