Microsoft Access 2007 tutorial: Create Report

Create Report



I. What is a Report?

The Report is an object in Microsoft Access 2007. It is used to pull data from a table or query to create a report.

II. How to Create a Report

In this tutorial, I show two ways in creating a report. First, creating report by using Report Wizard, and second creating report by using Report Design.

II.1. Creating a Report by using Report Wizard

To create a report by using Report Wizard, you have to follow the steps:

- Click Create Tap-->Report Wizard

Microsoft Access 2007 Report Wizard1

Microsoft Access 2007 Report Wizard2

- Click Combo Box to select tables or queries to create a report

- Click Microsoft Access 2007 Select One field Icon or Microsoft Access 2007 Select All Fields Icon to select fields to create a report

- Click Next; a Report Wizard dialog will appear as figure:

Microsoft Access 2007 Report Wizard Dialog1

This dialog asks you if you want to add grouping on any fields. For example, you want to group PubID field so you have to select PubID in the list and click Microsoft Access 2007 Select One Field. You will see the Report Wizard dialog like the demonstrated figure :

Microsoft Access 2007 Report Wizard Dialog2

- Click Next

Microsoft Access 2007 Report Wizard Dialog3

This dialog asks you if you want to sort the records in order; you can sort the records by four fields in a report in ascending or descending. For instance, you select BookID field as a sorting field with ascending.

- Click Next

Microsoft Access 2007 Report Wizard Dialog4

The dialog asks you to select the the layout and orientation of your report that you like.

+ Layout:

- Stepped

- Block

- Outline

+ Orientation

- Portrait

- Landscape

You can choose any layouts that you satisfy with and you will see each its layout on the left preview while you click any layouts. And for the orientation, there are two types to choose and you will see each its orientations below Portrait and Landscape orientation.

- Click Next

Microsoft Access 2007- Report Wizard

The dialog allows you to choose any styles you like. Select styles you like and you can see each its styles on the left preview.

- Click Next

Microsoft Access 2007- Report Wizard

The dialog asks you to give the title to your report in the text box and you can select: Preview the report or Modify the report design. For instance, you entitle the report as Book Information and you want it choose Preview.

- Click Finish

You will get a report like a figure below:

Microsoft Access 2007- Report Wizard





Comments

dee comment

 dee

gila ke apa

07-24-2014
Name:
Comment:
Enter the text:
CAPTCHA image

.........................................................................................................................Home | Forum | About | Contact
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word.
However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.
Copyright @ 2011-2013 worldbestlearningcenter. All Rights Reserved.
Home Programming Web DB & App Questions Exercises Tips Programs FAQs Download About
Computer-Wbest
Popular Pages
You might like