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.

Taidot: Tietokannan hallinto, Microsoft Access

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Euclid, United States

Projektin tunnus: #4281849

19 freelanceria on tarjonnut keskimäärin 288 $ tähän työhön


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

195 $ USD 5 päivässä
(244 arvostelua)

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

380 $ USD 15 päivässä
(622 arvostelua)

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 Lisää

250 $ USD 15 päivässä
(196 arvostelua)

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 4 päivässä
(29 arvostelua)

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 Lisää

250 $ USD 14 päivässä
(38 arvostelua)

Hello, Please check PM for my queries. Thanks

600 $ USD 30 päivässä
(4 arvostelua)

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 10 päivässä
(6 arvostelua)

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 15 päivässä
(11 arvostelua)

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

750 $ USD 30 päivässä
(11 arvostelua)

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 Lisää

500 $ USD 30 päivässä
(2 arvostelua)

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 10 päivässä
(4 arvostelua)

We can do the Project,Please see Private Message.

180 $ USD 10 päivässä
(2 arvostelua)

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

150 $ USD 4 päivässä
(3 arvostelua)

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 Lisää

140 $ USD 20 päivässä
(1 arvostelu)

I could help you

250 $ USD 5 päivässä
(0 arvostelua)

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 15 päivässä
(0 arvostelua)

Hi, Let me do it! Thanks,

250 $ USD 15 päivässä
(0 arvostelua)

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 Lisää

200 $ USD 10 päivässä
(0 arvostelua)

I am interested

300 $ USD 20 päivässä
(0 arvostelua)

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 5 päivässä
(0 arvostelua)