Microsoft Office is the software which meets the demand of today’s generation that is this software now become the major player among all software. It has many IT applications like MS Word, MS Excel, MS PowerPoint and MS Access etc. You can install this software through www.office.com/setup.
MS Access is the database management system in which you can manage large amount of data, in a proper manner than in MS Excel. In this blog, you will learn how to create a report with report wizard in MS Access.
Create a Report with Report Wizard in MS Access:
For creating a report, firstly on the Create tab in the Reports group, you have to click on Report Wizard. Then the report wizard starts. Now from the Tables drop-down list, you have to select the table to create the report. Here you have to select the fields in the Available Fields list box. After this, move the fields to include on the report from the Available Fields list box to the Selected Fields list box. Now just double-click a field name. To move all fields at once, you have to click. Here you have to click on Next. After this, to group records on the report, highlight the field which is in the list box and then just click. You can add more grouping levels if you want. If you want to change the order of the grouping levels, you can use arrow. After you select record groups then just click on Next option. In the first drop-down list, you have to select the field to sort records. The records will be sorted in ascending order by default but if you want to sort in descending order, you have to click on the Ascending button so that it changes to “Descending”. You can do four levels of sorting after you done just click on Next. In the Layout field, you have to select the format of the report. And see a preview of the report layouts. In the Orientation field, you have to select report in portrait or landscape mode. If you want all fields to fit on a single page, then Adjust the field width so all fields fit on a page check box is marked. After this just Click on Next. Now just enter the title for the report. After this, just select the option for the view -Preview the report or modify the report’s design. Now Click on Finish. The report will load in the view in which you have selected.
For more details, you can visit to the official team of MS Office through office.com/setup.