| Basics of
Relational Report Writing
Discussions regarding the nature of information organization within a
database application and the specifics of the application(s) to be used in
conjunction with ReportWorks. |
Definition of report |
| Review of databases used in the
class |
| Defining the "Master data file |
| Methods of linking Master and
Secondary data files |
| Categories of Secondary data
file relationships (1:1, 1:Many, 1:Maybe) |
| Use of database indexes |
| Relational report development |
| Tour of ReportWorks "topography" |
| Natural and reverse Master
file(s) |
| Identify likely linking
relationship among database files |
| Description of "Purpose-Driven"
reporting |
| Breakdown of existing report
items into relational specifications |
| Banded Report
Design Development of simple banded
reports to meet specifications. |
Description of each category of
report "band" |
| Common purpose(s) of each of the
7 band types |
| Cause / effect of band use on
report output |
| Breakdown of existing report
items into band specifications |
| Entry of text data variable into
each band |
| Creation of totals and entry
into appropriate bands |
| Combination / interaction of
variables within and among bands |
| Report Production and output
review |
| Report
Manipulation Techniques Discussion
of queries / filters, sorting / grouping.
|
Using query parameters to limit
the scope of data accessed in the report |
| Query elements and test
conditions |
| Logical connections between
query elements |
| Algebraic connections within the
query |
| Creation of standard query for a
report |
| Modifying queries to reuse
report formats |
| Relationship between grouping
parameters and headers / footers |
| Relationship between grouping
parameters and totaling variables |
| Relationship between grouping
parameters and sorting parameters |
| Breakdown of existing report
items into query / sorting / grouping |
| Entry of variables in grouping
bands |
| Creation of totals and entry
into grouping bands |
| Modification of query to
manipulate content of report |
| Modification of sorting to
manipulate organization of report |
| Data Manipulation
Techniques Discussion of the nature
of data elements and the methods of converting one type to another.
Discussion of the nature of data totals and methods of producing valid
statistics for subtotal and summary sections of reports. |
Breakdown of data element types
and behaviors |
| Description of data manipulation
functions, tests and results |
| Relationships between calculated
data elements for existing reports |
| Creation of calculated data
elements for existing reports |
| Creation of parameteRR data
elements for existing reports |
| Breakdown of data total types
and behaviors |
| Description of data total
functions, tests and results |
| Relationships between data
totals and records |
| Creation of data totals for
existing reports |
