Report Wizard in MS Access

Report Wizard is a tool that guides you through the process of creating a report. It is useful for beginners because you do not need to design the entire report manually.

Uses of Report Wizard

• Selecting fields from a table or query.
• Grouping related records.
• Sorting records in ascending or descending order.
• Selecting a report layout.
• Choosing portrait or landscape orientation.
• Giving the report a title and saving it.

Before opening Report Wizard, make sure your database contains the required information.

Example: Students Table

In this example, the Students table contains four records. We will use Report Wizard to create a report from this data.

Steps to Open Report Wizard

1. Open Microsoft Access.
2. Open your database file.
3. Click the Create tab on the ribbon.
4. Find the Reports group.
5. Click Report Wizard.
6. Wait for the Report Wizard dialog box to open.

The first step inside Report Wizard is to select the data source for your report.

Steps

1. Open the Table/Queries drop-down list.
2. Select the table or query containing your data.
3. Review the available fields.
4. Choose the fields you want to display in the report.

Example

Select the Students table and include these fields:

• StudentID
• StudentName
• Course
• City

The available fields depend on the selected table or query.

Report Wizard provides controls for moving fields between the available fields list and the selected fields list.

Common Controls

Steps

1. Select a field from the available fields list.
2. Click the right-arrow button to add it.
3. Repeat for all required fields.
4. Use the left-arrow button if you need to remove a field.
5. Click Next.

Grouping organizes records according to a common field. For example, you can group students by course so that all ADCA students appear together.

Example: Group Students by Course

Suppose the table contains these records:

• Rahul Kumar — ADCA
• Priya Singh — Tally Prime
• Amit Kumar — ADCA
• Neha Kumari — Web Development

The report can organize the students like this:

Steps

1. Proceed to the grouping step in Report Wizard.
2. Select the field you want to group by, such as Course.
3. Add the grouping level.
4. Adjust the grouping order if needed.
5. Continue to the next step.

Sorting arranges report records in a particular order. You can sort names alphabetically, dates chronologically, or numeric values from smallest to largest.

Sorting Options

• Ascending: A to Z or smallest to largest.
• Descending: Z to A or largest to smallest.

Steps

1. Proceed to the sorting step in Report Wizard.
2. Select the field you want to sort by.
3. Choose ascending or descending order.
4. Add additional sorting fields if required and available.
5. Click Next.

Example

If you sort StudentName in ascending order, names are arranged alphabetically.

Report Wizard allows you to choose how the information is arranged on the page.

Common Layout Options

• Stepped: Presents data in a stepped arrangement.
• Block: Arranges fields in a block-style layout.
• Outline: Organizes grouped data in an outline-style arrangement.

The available layout choices depend on the report and Access version.

Page Orientation

• Portrait: The page is taller than it is wide.
• Landscape: The page is wider than it is tall.

How to Choose

1. Select the required layout.
2. Choose Portrait or Landscape.
3. Review the preview if available.
4. Continue to the next step.

The final step is to give the report a meaningful name and complete the wizard.

Steps

1. Enter a descriptive report title.
2. Choose whether to preview the report or modify its design, if prompted.
3. Click Finish.
4. Review the generated report.
5. Save any additional formatting changes.

Example Report Names

• rptStudentDetails
• rptCourseWiseStudents
• rptFeeCollection
• rptEmployeeDetails

The saved report appears in the Navigation Pane and can be opened again whenever required.

Report Wizard creates the initial report structure. You can customize the report afterward.

Common Changes

• Change the title and headings.
• Adjust column widths.
• Change fonts and colors.
• Move or resize controls.
• Modify grouping or sorting options.
• Adjust margins and page orientation.

Steps

1. Locate the report in the Navigation Pane.
2. Right-click the report.
3. Select Design View or Layout View.
4. Make the required changes.
5. Save and check the result in Print Preview.

Create a course-wise student report using Report Wizard.

Required Fields

• StudentID
• StudentName
• Course
• City

Tasks

1. Open your student database.
2. Launch Report Wizard from the Create tab.
3. Select the Students table or an appropriate query.
4. Add StudentID, StudentName, Course, and City.
5. Group records by Course.
6. Sort StudentName in ascending order.
7. Select a suitable layout and orientation.
8. Name the report rptCourseWiseStudents.
9. Finish the wizard.
10. Preview and save the report.

1. What is Report Wizard in MS Access?
2. From which ribbon tab can you open Report Wizard?
3. What is the purpose of selecting fields?
4. What is grouping in a report?
5. What is the difference between ascending and descending order?
6. What is the difference between Portrait and Landscape orientation?
7. Why should you give a report a meaningful name?
8. Can you modify a report after creating it with the wizard?
9. Which view helps you check the printed layout?
10. Give two examples of reports created in an organization.