In Progress

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$

Skills: Visual Basic

See more: 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

About the Employer:
( 10 reviews ) las vegas, United States

Project ID: #451812

Awarded to:

schandraram

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

$500 USD in 25 days
(55 Reviews)
5.9

39 freelancers are bidding on average $445 for this job

HussienSharaf

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

$500 USD in 8 days
(40 Reviews)
6.3
Wonderer

Interesting project. Willing to work with.

$500 USD in 7 days
(20 Reviews)
5.6
nmppatel

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 in 10 days
(18 Reviews)
4.7
KellogITSolution

Hello Please see ur PMB for details Thanks

$275 USD in 5 days
(12 Reviews)
4.3
tootwotrue

Please see message on PMB.

$500 USD in 5 days
(4 Reviews)
4.2
oFAZo

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

$500 USD in 15 days
(13 Reviews)
4.1
crajeshbe

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 in 7 days
(8 Reviews)
4.1
ExactSystems

Please check PMB. regards

$745 USD in 20 days
(4 Reviews)
4.1
skujuira

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

$500 USD in 20 days
(5 Reviews)
3.5
primasoft

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

$250 USD in 5 days
(2 Reviews)
2.3
VBMagician

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 in 7 days
(2 Reviews)
2.2
freelancesol

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 More

$275 USD in 5 days
(2 Reviews)
2.1
guevanjr

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

$250 USD in 1 day
(3 Reviews)
2.2
grossekathoefer

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

$500 USD in 14 days
(1 Review)
2.0
crowdata

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 More

$600 USD in 2 days
(2 Reviews)
0.0
hjdeshmukh

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

$400 USD in 4 days
(0 Reviews)
0.0
dgtalindiasol

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 More

$450 USD in 10 days
(0 Reviews)
0.0
sands1

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

$250 USD in 5 days
(0 Reviews)
0.0
navinnirala

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

$500 USD in 14 days
(0 Reviews)
0.0
suddhashil

i can do it. pl. give me a chance

$400 USD in 20 days
(0 Reviews)
0.0