Access database design and development #2
$250-750 USD
货到付款
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$
项目ID: #451812
关于项目
授予:
有37名威客正在参与此工作的竞标,均价$439/小时
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.
Dear Mr./Ms., North America graduated and Microsoft certified professional. Please refer your PMB. Regards
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 更多
Dear Sir, Please kindly refer to my PM for further detail. Thank you very much. Sincerely yours, Primasoft
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).
hi, We have experienced Software Engineers team able to provide you a quality solution. We found your attached excel file and understood your database. please check my Pm.
I am interseted in your project and I have gone through your requirements.I can assure you quality since i have done a few projects related to Excel Files. Thankyou hope to hear from u soon.