Access database design and development #2

The attached zip file contains excel sheets. These sheets are the basis for an access database I need developed.

Your first step would be to analyze the sheets and understand how the client uses them. Its not too hard to visualize - their entering some basic information and the sheets are doing some basic calculations. You can see the problem as well - their creating tabs, having huge spreadsheets that follow a pattern. The 1st 2nd and 3rd shift sheets are really identical.

After spending time to understand what they are doing here, you need to create an access database to support these sheets. I.e. you build a table structure, forms, reports, etc. Your form would have a place where they select the date, shift, etc, then they enter the data, calculations are shown, etc. The excel sheets are a guide to help you design a database that collects this information.

On acceptance, I fund the escrow of this project. After doing a draft of the access database, you send it back to me, (you can encrypt the database at this point since you have not recieved payment, no problem). After I get something from you I will give you a list of suggestions/changes, and release 50% of the project. After you incorporate those changes we should have a working model that I will then have the client try out.

I let the client use the draft, give me feedback, which you incorporate into the database, and once the client is happy, you get the remaining 50%. After that point, if the client wants more changes, we will consider it a separate project.

This project requires you to **think and use your access design experience to build a database that will do the job that the excel sheets are doing.** Should you develop it to look like the excel sheets? Absolutely not - develop it in the way you think works best, and operates best, based on your access database experience. Besides wanting a good way to enter data, the client has no preference, so your input on the design is crucial.

There will be a period of 1-2 weeks while the client uses the program and gets used to it.

Things to note:

Should be developed in Access 2007

Should not an .exe, needs to be an access database (for the final version)

Good code and doc - no sloppy code thats not properly doc'ed - I will check.

I am VERY BUSY - I have a traveling schedule, and manage quite a bit of projects - sometimes you will not hear a response from me for days because I do not have the time to review your work or get feedback. On top of that, the client has their own schedule we have to work around. I need you to be patient.

The project budget is a FIXED BUDGET - all changes and additions by the client are part of the fixed fee - keep that in mind when posting a bid.

As stated above, you will be paid 1/2 at the first delivery and 1/2 on completion. This project has a budget of 500$

Taidot: Visual Basic

Näytä lisää: database design develop installation payment proposal, access database design, getafreelancer access database, access database design freelance, freelancing sharepoint projects, when is escrow paid out, uses of data structure, support by design, shift job, select design, schedule design pattern, projects works design, patient point, no problem part 1, manage client information, keep busy, job posting design, in-step design, in step design, i need an access database, huge things, huge design, how to get a design job, how to develop database in access, how to create database program

Tietoa työnantajasta:
( 10 arvostelua ) las vegas, United States

Projektin tunnus: #451812

Myönnetty käyttäjälle:


Hello - Please see PMB for details of my bid. Thank you. Chandra Ram.

$500 USD 25 päivässä
(55 Arvostelua)

39 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


HI, I m the best analyst and VBA expert. Plz check PM Regards, Hussien Sharaf

$500 USD 8 päivässä
(40 arvostelua)

Interesting project. Willing to work with.

$500 USD 7 päivässä
(20 arvostelua)

I am an IT professional with 10 yrs experince. I have completed many projects on GAF in MS-Access skill. I will provide quick & professional service.

$500 USD 10 päivässä
(18 arvostelua)

Hello Please see ur PMB for details Thanks

$275 USD 5 päivässä
(12 arvostelua)

Please see message on PMB.

$500 USD 5 päivässä
(4 arvostelua)

Exceptional quality & Fast work. Please refer to Profile & PMB for details. Thanks FAZ

$500 USD 15 päivässä
(13 arvostelua)

Hi Good day, Expert in Access VBA, office Addin development and automation. Ready to start the work. Regards [url removed, login to view] B.E

$450 USD 7 päivässä
(8 arvostelua)

Please check PMB. regards

$745 USD 20 päivässä
(4 arvostelua)

Dear Mr./Ms., North America graduated and Microsoft certified professional. Please refer your PMB. Regards

$500 USD 20 päivässä
(5 arvostelua)

Dear Sir, Please kindly refer to my PM for further detail. Thank you very much. Sincerely yours, Primasoft

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

I went through the spreadsheet and it seems to me that this is a pretty simple job. I do not know if it makes any difference, I am US based (West Coast).

$400 USD 7 päivässä
(2 arvostelua)

Good day, I have gone through each and every sheet of the attached 3 shifts and the weekly/monthly/yearly report and have analyzed the data minutely. I have just finished a complete VBA Access development work recent Lisää

$275 USD 5 päivässä
(2 arvostelua)

I've got the project ready to be delivered. Please PM

$250 USD 1 päivässä
(3 arvostelua)

It's a lot to do but I have done it a lot of times.

$500 USD 14 päivässä
(1 arvostelu)

Hi I have reviewed your attachment and certainly understand why you want to move away from Excel. I can complete this project in 2 to 3 days. I am an Access/VBA expert with 10 years experience with database design a Lisää

$600 USD 2 päivässä
(2 arvostelua)

I have not much experience about doing project so help me and cooperate.

$400 USD 4 päivässä
(0 arvostelua)

Hi We have experience in vb6.0 and access 2007 We have experience in data migration from excel to access . We have experience in IT from last 15 years. We have the capability to deliver the product within deadlin Lisää

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

Bidder Comments : Dear Sir, Kindly refer to your PM for more details. Thanks & Regards, SANDS Team.

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

I am ready to work on this.. let me know if you want the sample of this project...

$500 USD 14 päivässä
(0 arvostelua)

i can do it. pl. give me a chance

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