Project Detail

MS Access Project (Urgent)  

MS Access Project (Urgent) is project number 354828
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: psarun85

Budget: $30-250

Created: 12/08/2008 at 19:39 EST

Bid Count: 16

Average Bid:
$ 202

12/10/2008 at 19:39 EST

Project Creator: wfkjjang
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (1 reviews)

Bid On This Project
 

Description

DMV Revenue Project

In recent months, the DMV in New York started having difficulties in keeping up with the accounting issues associated with Driver Licenses and Road Tests.

The DMV has many offices in various places in the state (such as Queens, Brooklyn, Nassau, Suffolk) and each office houses many DMV Evaluators for road test. Each office is identified with a unique code. An application for a driver license is accepted after passing a written test (no application is accepted until a person passes the written test and eye examination).

At the moment of original application, a fee of $50 is collected from each applicant and then a road test is arranged for each applicant. An applicant can take many road tests until a DMV evaluator gives him/her an OK. However, an applicant must pay $100 for each road test given. Once the road test is passed, an applicant is issued a drivers license at a fee of $75.

The DMV director has asked your assistance in developing an accounting system to keep track of applications and the road test fees. Based on your expertise in Microsoft Access you accepted to design and ERD diagram that can be used to develop this new system.


Required:
a)Identify entities, attributes and primary keys for the system

b)With the help of foreign keys establish relationships between those entities that could be used for this purpose. Using the notation we used in the class draw an ERD diagram.

c)Create an MS ACCESS database tables and relationships based on the ERD diagram you have developed above…

d)Populate those tables with fictitious persons and transactions at least 3 DMV offices, with 2-4 Evaluators in each office, and 4-5 applicants with one or more road tests)

e)Print MS Access reports showing
a.Entity Relationship Diagrams
b.Road tests to given on a specific date by each DMV office and total revenue from road tests.






Additional information submitted:

12/08/2008 at 22:35 EST:
This project has to be done by 12/9 Tuesday Midnight.



Additional files submitted:
DMV Revenue Project.doc

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

250

7 days

12-08-2008 21:15 EST

Hello,Please refer your PMB.Thank you.

help

 

250

5 days

12-08-2008 21:08 EST

Dear Sir/Madam I can do this project best possible. I am a expert, in making website designs, graphic designs, logo designs, banner, flash,OSCommerce, Joomla, DotnetNuke, PHP/Mysql, ASP, ASP.Net, Smarty, Access, MS SQL Server, .Net, Ajax, CSS, DHTML, XHTML, XML, Javascript, Web promotion, SEO, Link building, Wordpress, Able dating and personals site, Open LD, SimpleCMS, classifieds script, Data Processing, Script Intallation, System Admin, develop a full site, security etc…. I am very pleasure if I can get a chance to work with you. I am hoping and hearing from you. Thank you very much.

help

 

250

3 days

12-08-2008 23:55 EST

Let's start

help

 

225

3 days

12-08-2008 23:23 EST

Hi, I have been developing software systems for several years now. Try me out, you won't be disappointed. Look forward to your reply. Regards, Shimona. Hi again, I cannot post a message on the PMB; it gives me an error so I'm writing here. 12/9 Tuesday Midnight is fine with me. Will you escrow the payment? If so, I am ready to begin. Regards, Shimona.

help

 

250

5 days

12-08-2008 23:14 EST

Dear Sir, SERIOUS BIDDER. Please check PM. Regards, Jainam Shah, iSoft Solutions.

help

 

225

6 days

12-09-2008 00:01 EST

Hi, Expert computer Engineer,I would providing you Right Solution..,Can Start work on Immediately effect. Thanx

help

 

150

1 day

12-09-2008 08:28 EST

hi, i can do this. kindly check PM

help

 

250

15 days

12-08-2008 20:09 EST

Hi Please refer the PMB Regards

help

 

100

4 days

12-08-2008 19:59 EST

PLEASE SEE PM

help

 

190

7 days

12-08-2008 22:16 EST

Hello thanks for review my bid. pl chk pmb for reference. with regards thanks

help

 

200

5 days

12-09-2008 05:58 EST

Hi, We are very much interested to do this project. Regards

help

 

100

7 days

12-08-2008 19:57 EST

(No Feedback Yet)

gret job... let's take it done...

help

 

220

1 day

12-09-2008 00:25 EST

(No Feedback Yet)

Hi, Please see the PM for more details of the project. Due to some problem not able to post Private Message. Can soon update you with our previous work. Thanks.

help

 

250

6 days

12-09-2008 01:40 EST

(No Feedback Yet)

i can provide you with the best solution.

help

 

99

4 days

12-09-2008 02:06 EST

(No Feedback Yet)

I am new but I can provide you an excellent job that you required.

help

 

222

5 days

12-09-2008 02:30 EST

(No Feedback Yet)

Please check sample file PM. I am ready to start your job.

help


    Bid on this Project