HOW TO DESIGN A REPORT IN MICROSOFT EXCEL

DESIGNING A REPORT

A report is the final output taken on the basis of the existing database in the database management system or relational database management system. Reports play very important role. Queries are used to generate the reports which work on a database available in the tables.

You can design a report by taking the following steps:

1. Click on create tab.

2. Then click on report wizard in reports groups.

Designing a Report in ms excel

3. Select a table/query on which you want to base your report. Then select the fields to display and click on Next button.


4. The report wizard will appear on the screen. In this wizard, select the fields which you want to put in the report.


5. Click on next button. Now, another wizard will come on the screen.



6. The screen appears what sort order do you want for your records? Set the order of records for sorting and click on next button.

7. The screen will appear with a message, how would you like to lay out your report? Select layout and orientation for printing and then click on next button. In portrait orientation, the width of page is less than height but in landscape, the width is greater than height. clip_image012

8. Respond to the table, what style would you like? By selecting the style for printing as a flow, foundry, median, metro, module, etc. and then click on next button.

9. Enter a title for your report in the given box and select the option preview the report and then click on finish button.