meets Tuesday and Thursday from 0800-0915
office hours in Manning 112
Class Schedule
10 Jan | intro
15 Jan | clients
17 Jan | servers
22 Jan | networks
24 Jan | basics lab
29 Jan | structural layer
31 Jan | presentational layer
05 Feb | working with layers
07 Feb | behavior layer |
12 Feb | images & design
14 Feb | website lab
19 Feb | document markup
21 Feb | graphics
26 Feb | document markup lab
28 Feb | spreadsheets
05 Mar | formulas & functions
07 Mar | data display
19 Mar | database tools
21 Mar | spreadsheets lab
26 Mar | relational databases
28 Mar | tables
02 Apr | relationships
04 Apr |
forms for input |
05.03 |
reports for output |
05.04 |
next session
09 Apr | SQL
11 Apr | complex queries
16 Apr | databases lab
18 Apr | presentation design
23 Apr | presentation delivery
25 Apr | presentation lab
30 Apr | 0800-1100 | final in class presentation
This work
is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
home & schedule | class blog | syllabus | contact | grades
Reports allow you to create paper products that are the result of a restructuring of the underlying database.
It's a way to retrieve and present selected information stored in your database in a format that will be printed rather than viewed on a computer monitor.
Reports provide a snapshot of your database (or a part of your database) each time a report is generated. A well-designed report can be used over and over.
If you want to create a simple report that is a duplicate of a particular table or (more likely) a simple select query, create a report based on that table.
You then will see what the printed report will look like, but it might have taken some formatting work in the design view to make this happen.
If you want to modify the report's appearance, you may do it in the WYSIWYG design view or you may choose to be more precise and exact by working within the report object's properties.
select the Wizard
Using the Wizard dialog boxes, you can combine data from multiple tables and/or queries into a report. If you do use multiple tables/queries in the report, the Wizard will ask you to select the primary item on which the report will be based ...
... and will ask you how you want the data grouped below the primary item ...
... and decide how to display the data in the sections of the report.
If the data can be manipulated by some sort of math operator, you will have the opportunity to perform summary operation in the form by selecting the appropriate option ...
... which will insert selected functions into the design.
It will then guide you through setting up the display properties ...
... and then carry you through the print view ...
... from which you can alter the appearance by using the design view.
what appears at the top of the report
includes the title
what appears at the top of each page in the report
similar to showing the column headings on each page of an Excel printout
if the report is grouped, what appears atop each grouping of data
where the data from the tables/queries will appear
what appears at the bottom of each page
what appears on the last page of the report
You can add new components and functions to reports
see this short PPT show for one tool you need to have