301 Access Lab - Forms and Reports

301 Access Lab - Forms and Reports - Access Lab Forms and...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Access Lab – Forms and Reports 1. We want a report that shows orders that have shipped recently (within the last week) or are not yet shipped. The report will list the order number, shipping method, customer number and name, and the date shipped. First, we create a query to get the information: 2. Now we will create a report based on the query. With the new query selected, go to the create tab, select report wizard, then click >> to select all available fields.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3. Click next, make sure “by tblOrders” is highlighted, click next. We don’t want any grouping, so click next again. Sort by shipdate: 4. Click next. Select a tabular layout, click next. Chose a meaningful title, then click finish: 5. Now we want to “clean up” the report to make it readable. Close print preview, and you will see the report in design view:
Background image of page 2
6. Re-size and re-label fields as needed. Remove the days since shipped field. Change to report view to see how it looks:
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
7. Add a count of the total number of orders on the report. In the design tab, select the ShipDate field.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/28/2012 for the course BMGT 301 taught by Professor Wang during the Spring '08 term at Maryland.

Page1 / 7

301 Access Lab - Forms and Reports - Access Lab Forms and...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online