Critque new database.

[94Sport5sp]

Hi:

I have been asked by a friend to create a database to help them balance sales information. Although it has been a while (10 plus years) since I did this last I thought I would welcome the challenge. Before I get too far into the development I thought I would ask for critiques and suggestions on improving my plan.

The overall purpose of the database is to record daily sales data, balance cash to sales, report sales information, and update a simple inventory file. I believe I will need the following:

Path Table
Path Primary Key
Disk Location
Comments
SalesLocation Table
Location Primary Key
Location Name
Last Balance Date
Notes
Path Primary Key links to Path Table
SalesDetail Table
Sales Primary Key
Sale Date
SalesClass/Group
SalesClass Count (Quantity of Group)
SalesAmount (Total of Group)
Adjustment OverShort
AdjustmentAmount (Adjustment to Group Total)
Adjuster (Person adjusting Group total)
AdjustReason (Reason adjustment was necessary)
ProcessTable (Tracks progress during balance procedure to facilitate recovery restart).
Process Primary Key
Process Date
Process Location
Process Location Balanced
Group Table (optional table)
Group Primary Key
GroupName
GroupNo (modifier to GroupName)
Comments
Import tables (One for each unique sales location. Raw data from sales units in a readable text format. Data needs to be parsed to remove unusable information.)

Forms:
Import form: User selects or identifies process date.
Software PathTable for list of sales locations and builds list of locations having data to import. (FileDate can be used for this.)
Software checks that this date is one day more than last balance date per sales location.
Clerk Selects location and starts Import.
Software verifies ImportTable for location is empty (software can empty table if needed).
Once import data is parsed it can then be added to SalesDetail Table.
Repeate for each location from list and print error reports where necessary.
Balance Form: (Form used to balance sales by location. Only the Adjust fields are to be modified.)
Process date from Import from controls which records to process.
Clerk selects location to balance and performs necessary adjusments. (Grand total from Imported file should agree when finished.)
Optional print balance report now or later.
Manual Balance Form: (Form used when Import file lost and only paper report exists.)
Clerk all data for SalesDetail Table and balances like Balance Form.

Maintenance Forms:
Add location form: Update SalesLocation Table and Path Table.
Delete old records (based on obsolete date) as needed.

Reports:
Balance report:
Summary report by Groups by location
Month end reports

Utilities:
Generate data for Accountant.
Backup database and import files daily.

I welcome any comments or suggestions.

Client currently has Access 2003 but if there would be a benefit I could upgrade them to the newer version.

Thanks