MSAccess Database Restructure

CLOSED
Bids
21
Avg Bid (USD)
$282
Project Budget (USD)
$30 - $250

Project Description:
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:
•Errors removed
•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
?Weekly/Monthly/Annually
•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.

Skills required:
Database Administration, Microsoft Access
Qualifications required:
us_eng_1 US English - Level 1
Additional Files: Bootcamp.zip
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 195
in 5 days
Hire fastudiovw
$ 380
in 15 days
Hire Premshanks
$ 250
in 15 days
Hire kulhanekd
$ 200
in 4 days
Hire amcsummers
$ 250
in 14 days
$ 600
in 30 days
$ 250
in 10 days
$ 300
in 15 days
$ 750
in 30 days
$ 500
in 30 days