Creating Reports in MS Access

A report displays information from tables or queries in an organized layout. You can group records, sort data, calculate totals, add headings, and prepare information for printing.

Examples of Reports

• Student Admission Report
• Monthly Fee Collection Report
• Employee Details Report
• Product Stock Report
• Sales Summary Report

Example: Student Report

This is an illustrative example of how report data may be organized.

Reports help users present database information clearly.

• To print database records.
• To organize information in a professional layout.
• To group and sort records.
• To calculate totals and other summary values.
• To prepare monthly or yearly summaries.
• To share information in a readable format.

The Report Wizard helps you create a report by selecting fields and choosing basic layout options.

Steps to Create a Report

1. Open your Microsoft Access database.
2. Select the table or query containing the required data.
3. Open the Create tab on the ribbon.
4. Click Report Wizard.
5. Select the table or query from the available list.
6. Move the required fields to the selected fields list.
7. Click Next.
8. Choose grouping levels if required.
9. Select sorting options.
10. Choose a layout and page orientation.
11. Enter a report title.
12. Click Finish.

The Report command creates a report quickly from a selected table or query.

Steps

1. Select the required table or query in the Navigation Pane.
2. Open the Create tab.
3. Click Report.
4. Access generates a report using the available fields.
5. Review the result in Layout View or Print Preview.
6. Save the report with a meaningful name.

This method is useful when you need a quick report without configuring every option manually.

After creating a report, save it so that you can open and use it again.

Steps

1. Finish creating the report.
2. Press Ctrl + S, or use the Save command.
3. Enter a descriptive report name.
4. Click OK if Access asks you to confirm the name.
5. Find the saved report in the Navigation Pane.

Examples of Report Names

• rptStudentDetails
• rptFeeCollection
• rptEmployeeList
• rptSalesSummary

Using a consistent prefix such as rpt can help you identify report objects in a database.

Microsoft Access provides different views for working with reports. The available options depend on the Access version and context.

How to Open a Report

1. Find the report in the Navigation Pane.
2. Right-click the report.
3. Select the required view.

Formatting improves the appearance and readability of a report.

Common Formatting Tasks

• Change the report title.
• Adjust font style, size, and color.
• Change background colors.
• Resize and align controls.
• Add borders where appropriate.
• Adjust column widths.
• Arrange headings and data fields.

Steps to Format a Report

1. Open the report in Layout View or Design View.
2. Select the title, label, or text box.
3. Use the Format tab or Property Sheet.
4. Adjust the required properties.
5. Review the report in Print Preview.
6. Save the changes.

Headers and footers help identify a report and provide useful information such as page numbers and dates.

Common Report Sections

• Report Header: Displays information at the beginning of the report.
• Page Header: Displays headings at the top of each page.
• Detail: Displays the records or data rows.
• Page Footer: Displays information at the bottom of each page.
• Report Footer: Displays information at the end of the report.

Steps

1. Open the report in Design View.
2. Use the Design tab to show or hide the relevant header or footer sections.
3. Add labels or controls as needed.
4. Enter the report title or other information.
5. Save and preview the report.

For page numbers and dates, Access provides suitable commands and controls in report design tools.

You can print a report directly from Microsoft Access after checking its page layout.

Steps

1. Open the required report.
2. Switch to Print Preview.
3. Check page orientation and margins.
4. Confirm that the report fits properly on the page.
5. Press Ctrl + P or select the Print command.
6. Choose the printer and required print settings.
7. Click Print.

Before Printing, Check

• All required columns are visible.
• Text is readable.
• Headings are displayed correctly.
• There are no unnecessary blank pages.
• The page orientation is appropriate.

Create a student details report using a table in your Access database.

Required Fields

• Student ID
• Student Name
• Father Name
• Course Name
• Mobile Number
• Admission Date

Tasks

1. Create or open a student table with sample records.
2. Select the student table in the Navigation Pane.
3. Use Report Wizard to create a report.
4. Select the required fields.
5. Set a suitable layout and orientation.
6. Name the report rptStudentDetails.
7. Format the title and column headings.
8. Preview the report before printing.
9. Save the report.

1. What is a report in Microsoft Access?
2. Why are reports useful?
3. What is the purpose of Report Wizard?
4. How can you create a quick report?
5. How do you save a report?
6. What is the purpose of Print Preview?
7. What is the difference between Layout View and Design View?
8. What is the purpose of a Report Header?
9. Why should you format a report before printing?
10. Give three examples of reports used in an organization.