Need some work done? Post a Project Today
I have an ms access database that houses client information for a weight-management fitness facility. The purpose is to provide individual client assessments, historical data and reporting. A record includes name, dob, age, orientation dates (start dates), weights (lbs), body (fat), weekly weigh-ins, notes, probation, weight goals, and stage category (1 thru 4). We have clients that leave and come back therefore they have various orientation dates with different starting weights. I have a goals section and once a client reaches a goal they advance to a different Stage. Currently the database has errors due to multiple hands on the file. The reporting is also limited as reports do not include historical data if clients are not marked as active. What
I am seeking is:
•Ability to have concurrent sessions of the database (Need to have at least two staff members access the file at the same time)
•Enhanced Reporting - Missed weigh-in Report currently doesn’t provide the proper information due to the implementation of the stages noted below. All new (Stage 1) clients are charged a fine if they miss a weigh-in, therefore a weekly and/or monthly report is needed. This report is very important because it generates revenue
?Stage 1 clients weigh-in weekly
?Stage 2 clients weigh-in 3x/month
?Stage 3 clients weigh-in 2x/month
?Stage 4 clients weigh-in 1x/month
--Total pounds lost –even if client is not active, would like accumulative totals
•Add ‘Sex’ field to denote male or female
•Possibly ability to upload photos to client records – we take before photos when clients start
•Color change alert if client gains 1 pound or more and doesn't lose any body fat. Currently goes red but does not include the body fat parameter.
•Color change notication if client is on their cycle - currently blue but doesn't change after going to a new client record.
•Excused absence field doesn't remove the client from having a missed weigh-in in report
•Adding a new client record - when adding a record you have to close out to go back in to add another new one (corrupt)
•Better search option of names.
I am open to restructuring of the database if needed because this one is about 5 years old. I have basic database creation experience.