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
- Click Combo Box to select tables or queries to create a report
- Click 
or 
to select fields to create a report
- Click Next; a Report Wizard dialog will appear as figure:
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 
.
You will see the Report Wizard dialog like the demonstrated figure :
- Click Next
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
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
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
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:
| |||||||||||||||
| ......................................................................................................................... | 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. | |||
