Paul,
The Database design is goods enough for now. We will tweak it a bit as the Application design gets a little farther down the road.
It's time to start work on the Reports.
Make a new workbook named TDR Reports Design.v.01.xls
Put each Report on a different Sheet
Make the report look as much like the actual paper form that it is taken from.
If it is not taken from a paper form, make it look like the ones that are.
Do not add any colors except as noted below.
Use Borders (Underline or Box) to show where Values go.
Do not use any formulas.
If the Labels on a Report do not match the Column Label where the value comes from, change the DB Design Column Label to match the Report. Italicize the report label so I know the Column label has changed.
If any value on a Report can be calculated from various DB values, Obviously, there won't be a DB column Label to match the Report Label. Use a Box Border and Light Yellow colors to indicate that the Value is calculated. Use Cell Comments to show which Database Sheets are used in the calculations.
