Advanced Report Options in Access 2013
Learn basics and Advanced Report options in Access 2013
Access offers several advanced options for making and altering reports. The Report Wizard is an instrument that aides you through the way toward making complex reports. Once you’ve made a report—regardless of whether through the Report Wizard or the Report order—you can then format it to influence it to look precisely how you need.
In this exercise, you’ll figure out how to utilize the Report Wizard to make complex reports. You’ll additionally figure out how to utilize Access’s formatting options to format text, change report colors and fonts, and add a logo.
All through this instructional exercise, we will utilize an example database. In the event that you might want to take after along, you’ll have to download our Access 2013 example database. You should approach Office 2013 introduced on your PC with a specific end goal to open the case.
The Report Wizard
While utilizing the Report command is a fast method to make reports from the present protest, it’s not as supportive on the off chance that you need to make a report with information from various items. The Report Wizard makes it simple to make reports utilizing fields from different tables and questions. It even gives you a chance to pick how your information will be sorted out.
To make a report with the Report Wizard:
Select the Create tab and find the Reports group. Snap the Report Wizard command.
- The Report Wizard will appear. In the procedures below, we’ll discuss the different pages in the Report Wizard.
Step 1: Select the fields to include in your report
- Click the drop-down arrow to select the table or query that contains the desired field(s).
- Select a field from the list on the left, and click the right arrow to add it to the report.
- You can add fields from more than one table or query by repeating the above steps. Once you’ve added the desired fields, click Next.
Step 2: Organize the report
The Report Wizard will provide you with options that let you choose how to view and organize your data. These options group similar data within your fields and organize these fields into multiple levels, like in an outline or bulleted list.
If you are building a report from only one table or query, you can skip to Step 3 below.
- Access will offer a list of several organization options. Select an option from the list to preview it.
- Click Next when you are satisfied with the basic organization of your data.
- If you’re not satisfied with the way your data is organized, you can now modify the grouping levels. Select a field from the list, and click the right arrow to add it as a new level.
- If necessary, modify the order of your grouped fields by selecting a field and clicking the up or down Priority arrows to move it up or down a level.
- Once you are satisfied with the organization of your report, click Next.
Step 3: Sort your report data
- Click the top drop-down arrow, and select the name of the first field you want to sort.
- Click the button on the right to change the sort to ascending or descending.
- Include any extra sorts. You can sort up to four fields. The sort will be connected through and through, which means the sort at the highest priority on the rundown will be the fundamental sort.When you are happy with the way your information is arranged, click Next.
Contingent upon the gathering you have decided for your information, your arranging alternatives might be constrained.
To read more about Office Products visit Office.com/setup