MSAccess Database Restructure

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


•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: Database Administration, Microsoft Access

See more: access body fat database, restructuring access database reporting, restructuring access database, writing stages, writing out dates, writing goals, writing dates, writing assessments, writing a field report, stages of writing, writing removed, writing new age, weigh, staff photos, revenue reporting, reporting writing, red bull , record writing, ms access reporting, ms access 2013, LBS, change fitness, report individual, access notes database, individual report

About the Employer:
( 0 reviews ) Euclid, United States

Project ID: #4281849

19 freelancers are bidding on average $288 for this job


Over 13 years experience developing MS Access simple and advanced database development, finished 430 projects successfully.

$195 USD in 5 days
(244 Reviews)

I have 20+ years of experience programming ms-access, .net & sql server. At your disposal for any doubt or question, Regards Fabio

$380 USD in 15 days
(622 Reviews)

Hi - I ran Bootcamp database and what I propose to do for you is as follows 1. Concurrent sessions of the database. I am planning to split the frontend and backend and we can have the frontend run in multiple PCs More

$250 USD in 15 days
(196 Reviews)

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

$200 USD in 4 days
(29 Reviews)

Welcome to Freelancer! There are a lot of good coders out there. Freelancer asks everyone to review the people they work with after every project. This will give you some insight on what to expect from the person yo More

$250 USD in 14 days
(38 Reviews)

Hello, Please check PM for my queries. Thanks

$600 USD in 30 days
(4 Reviews)

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.

$250 USD in 10 days
(6 Reviews)

Hi, I can do the job, MS Access expert, software developer for a several years. I am looking forward to work with you Regards Diego

$300 USD in 15 days
(11 Reviews)

Hi, Please check the details on my private message sent to you. Thanks djain01

$750 USD in 30 days
(11 Reviews)

Hi, if you require a multi user environment you will need to split the database into two parts - one for the data and the other for the code. The data structure looks good, but the code isn't very good at all and would More

$500 USD in 30 days
(2 Reviews)

Hello, please see my profile reviews. I have done quite a lot of similar projects. I have checked the attached database. Can help you with it.

$160 USD in 10 days
(4 Reviews)

We can do the Project,Please see Private Message.

$180 USD in 10 days
(2 Reviews)

I am very proficient in programming, c++, java, VBA etc, I can do this, please let expert do this.

$150 USD in 4 days
(3 Reviews)

Hello. I'm an experienced developer with multiple Microsoft certifications (MCP, MCT, MCAD, MCSD, MCDBA). I own a deep experience on .NET development and Microsoft database systems, including Access. I'm also a write More

$140 USD in 20 days
(1 Review)

I could help you

$250 USD in 5 days
(0 Reviews)

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.

$200 USD in 15 days
(0 Reviews)

Hi, Let me do it! Thanks,

$250 USD in 15 days
(0 Reviews)

I have over 12 years of Access/SQL design and development experience, with a particular concentration working with small businesses and non-profit organizations. My goal is to make the solution fit your needs, not the More

$200 USD in 10 days
(0 Reviews)

I am interested

$300 USD in 20 days
(0 Reviews)

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.

$225 USD in 5 days
(0 Reviews)