• Report Wizard - simplest way to create report design
• Report window - used to modify report created by wizard to your exact specs.

• Design view - used to modify design layout of report
• toolbox available in Design view (create special objects for report)
• Print Preview - used to see report with sample data

• Report Header - print once at beginning
• Report Footer - print once at end
• Page Header - top of each page
• Page Footer - bottom of each page
• Detail - print once for each record in table
• Controls - rectangles appearing on report in design mode
• controls in Page Header section serve as captions for data

• Property sheet - list of control properties that can be modified
• to produce property sheet, right-click control, then click Properties on shortcut menu

• Grouping - arranges records in report that share common characteristics
• 2 Types of Sections:

• To move, resize, delete, or modify a control click it, sizing handles appear
• Move - point to boundary away from sizing handle, drag control (hand shaped mouse)
• Resize - drag one of control's sizing handles
• can move or resize several controls at same time by selecting them before dragging (hold down SHIFT-key click multiple controls to select)

• Provide specific information - meanings of rows and columns must be clear, column captions easily understood, abbreviations
• Allow sufficient space between groups
• Do not overuse different fonts and sizes
• Be consistent stick to a general style

• Bound controls - used to display data that comes from database
• Attached label - portion of screen to left of field identifying field
• Unbound controls - not attached to data used for titles and headings
• Calculated controls - used to display data that is calculated from the data in database

• Don’t clutter excessively (too many different effects(colors, fonts,etc))
• Place fields in logical groupings
• If source of data on paper, make form format as close to paper as possible

• Access provides capability of creating a version of datasheet, form, or report to the Web
• The process of creating such a version is referred to as publishing to the Web.
• Publish to the Web Wizard - tool in Access that assists you in this process

• End
• Access
• Project 4

Return to Elective Courses