access assignment

part3breports.docx

Home >Computer Science homework help >access assignment

Grading Sheet for Project Part 3

Part 3b: Report Design

The purpose of this part of the assignment is to demonstrate your knowledge of the report design process: source data, grouping, and summary statistics. Reports can be based on the queries developed in the earlier part of the assignment and, if so, the report name and query name should match as illustrated in the examples provided. The table below outlines the feature(s) to be demonstrated in your reports.

Report Type	Feature Demonstrated
Table based	A report based on a table or tables
Grouping	A grouped report
Date Grouping	A report grouped by date
Subgrouping	A report grouped on two fields and sorted appropriately
Totals (Summary Statistics)	A report with group and grand totals in the appropriate footers

Your reports must be functional and meaningful within the context of your specific database. All reports must have appropriate fields, field order, and sorts, and should be appropriately formatted (e.g. all data/information should be visible and consistently formatted. Report titles, background, logos etc. should be professional in appearance similar across all reports.

Submission Instructions

1. Upload your database file to the drop box in D2L before Wednesday, Nov 2nd.

BUS 145 – Database Project – Part 3

Page 1 of 2

Name:

PART 3b: REPORT DESIGN

Features Demonstrated: / 10
Table Data Source	Grouping
Date Grouping	Subgrouping
Totals (Summary Statistics)	Appropriate Fields
Report Formatting

Documentation: / 10

Grading Sheet for Project Part 3b

TOTAL: /20