Lab%2011%20-%20Report%20Design%20Using%20Microsoft%20Access

Lab%2011%20-%20Report%20Design%20Using%20Microsoft%20Access...

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

View Full Document Right Arrow Icon
REPORT DESIGN USING  MICROSOFT ACCESS LAB 11
Background image of page 1

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

View Full DocumentRight Arrow Icon
WHAT A REPORT CAN DO  THAT A QUERY CANNOT Added formatting options: Heading vs. Detail areas. Differing font sizes and faces. Allows display of both detail and sub-totals or  totals. Built in functionality to handle paging. 2
Background image of page 2
HOW TO BUILD REPORTS  WITH THE WIZARD (STEP 1) In the menu at the top of the window, click  Create. Click on the Report Wizard  icon in the toolbar. 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
HOW TO BUILD REPORTS  WITH THE WIZARD (STEP 2) Select table or  query on which  report will be built. Use the buttons in  the middle of the  screen to move the  fields you want  from  Available Fields to  Selected Fields. 4
Background image of page 4
HOW TO BUILD REPORTS  WITH THE WIZARD (STEP 3) Choose how you want  records grouped on  report: Grouping has to do  both with sorting  the records and with  formatting them on  the report. Groupings can be  given their own  headings and footers. 5
Background image of page 5

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

View Full DocumentRight Arrow Icon
HOW TO BUILD REPORTS  WITH THE WIZARD (STEP 4) Sorting arranges the  records within  groups: Select field to sort by  from drop down. Can also click  Ascending/Descending  button to make sort  ascending or  descending. 6
Background image of page 6
HOW TO BUILD REPORTS  WITH THE WIZARD (STEP 5) Choose the layout and  orientation of your  report: Click on Columnar,  Tabular, and Justified  and watch the changes  in the thumbnail diagram  to see how each works.  7
Background image of page 7

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

View Full DocumentRight Arrow Icon
WITH THE WIZARD (STEP 6) Select a report  style: As with the prior  screen, you can  click on any styles  and see the  thumbnail  presentation of it. 8
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/30/2012 for the course CNIT 180 taught by Professor Victorbarlow during the Spring '12 term at Purdue.

Page1 / 23

Lab%2011%20-%20Report%20Design%20Using%20Microsoft%20Access...

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

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