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.
19 freelanceria on tarjonnut keskimäärin 288 $ tähän työhön
I have 15 years exp in building custom access databases. I have repaired and created many from scratch. I would be grateful if you would choose me to make the repairs to your database. Thanks Donna
Hi, I have 20 years of Access database design - I can amend and restructure this database to make it very user friendly and multi-user. Please see private message.
Hi, I have 10 years experience as an Access developer. I will update your database in two weeks for the price indicated. Please see my portfolio for examples of work I have done. Thanks.
I am very proficient in MS Access. Queries, Automated Forms and Reports. More so I am extremely good at writing modules that can make your application do anything you can imagine.