The Access Ribbon contains several commands for creating new reports for your applications. The Create tab of the Ribbon includes a grouping called Reports containing several options such as Report, Labels, and Report Wizard. For this exercise, use the Report Wizard button to create a new report from tblProducts.

Begin by clicking the Report Wizard button in the Reports group of the Create Ribbon tab. The Report Wizard dialog opens, as shown in Figure 37-5.

In Figure 37-5, tblProducts has been selected as the data source for the new report. Under the data source selection drop-down list is a list of available fields. Clicking on a field in this list and pressing the right pointing arrow moves the field from the Available Fields list to the Selected Fields list, adding it to the report. For this exercise, select Product ID, Description, QtyInStock, RetailPrice, and SalePrice.

FIGURE 37-5
The first screen of the Report Wizard after selecting a data source and fields.

You are limited to selecting fields from the original record source you started with. You can select fields from other tables or queries by using the Tables/Queries drop-down list in the Report Wizard. As long as you have specified valid relationships so that Access properly links the data, these fields are added to your original selection and you use them on the report. If you choose fields from unrelated tables, a dialog box asks you to edit the relationship and join the tables. Or, you can return to the Report Wizard and remove the fields.

After you have selected your data, click the Next button to go to the next wizard dialog box.

• Prosper Number of Open Listings By Day I was reading a thread on the forum and they were speculating that the recent lack of quality loans (December...
• Comparing Retirement Cost of Living in Different Locations When baby boomers retire, many will consider relocating to lower their cost of living.  I think this strategy will take...
• 5 Free Ways To Jumpstart Your Web Traffic Therefore you have got your own website. Congratulations. Currently, what exactly are you doing to induce individuals to go to...
• How to Pick Different Categories for Your Corporate Blog If you have decided to create your own corporate blog, one of the first things that you may be trying...
• Excel How-to: Creating a Pivot Table A pivot table is a merely a summary of data in a format that you can manipulate to suit your...