DesigningReportsinAccess-UIS.pdfVIP

[Not for Circulation] Designing Reports in Access This document provides basic techniques for designing reports in Microsoft Access. Opening Comments about Reports Reports are a great way to organize and present data from your Access database. Reports enable you to format your data in an attractive and informative layout for printing or viewing on screen. Reports are often used to present a big-picture overview, highlighting main facts and trends. The data in a preview or in a printed report is static. Reports merely present the data; they do not alter the underlying data in the tables. Each time a report is opened, Access displays the most recent data. Creating a Report Reports are created from one or more tables or queries. To use several tables, you would first create a query to retrieve data from those tables. There are three basic ways to create a report: with a single mouse click, with the Report wizard, or in Design view. To create a report with a single click, 1. Open the table or query upon which you want to base the report. 2. On the Create tab, click Report. 3. The report is created and displays all the fields from the underlying table or query. The Report tool may not create the final, polished product that you ultimately want, but it is quite useful as a means to quickly look at the underlying data. You can then save the report and modify it in Layout view or Design view so that it better serves your purposes. Information Technology Services, UIS 1 [Not for Circulation] You can use the Report Wizard to be more selective about what fields appear on your report. You can also specify how the data is grouped and sorted, and you can use fields from more than one table or query, provided you have specified the relationships bet