MS Access Project (Urgent)

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.


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

[url removed, login to view] Relationship Diagrams

[url removed, login to view] tests to given on a specific date by each DMV office and total revenue from road tests.

This project has to be done by 12/9 Tuesday Midnight.


Lihat lebih lanjut: Access project, system tests, purpose of accounting system, office relationships, ms project test, design access database, accounting test 2, accounting offices, accounting office design, urgent road test, erd diagram examination system, using diagram dmv, microsoft access project job, access erd project, revenue access database erd, money create projects microsoft access, dmv diagram, draw diagram msaccess data, dmv project, draw erd access, access projects york, access based erds, best access project websites, dmv erd, dmv revenue project answers

Tentang Majikan:
( 1 ulasan ) Bayside, United States

ID Projek: #354828

Dianugerahkan kepada:


hi, i can do this. kindly check PM

$150 USD dalam sehari
(63 Ulasan)

16 pekerja bebas membida secara purata $202 untuk pekerjaan ini


Hello,Please refer your [url removed, login to view] you.

$250 USD dalam 7 hari
(262 Ulasan)

Let's start

$250 USD dalam 3 hari
(93 Ulasan)

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

$250 USD dalam 5 hari
(75 Ulasan)

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 SQ Lagi

$250 USD dalam 5 hari
(401 Ulasan)

Hi Please refer the PMB Regards

$250 USD dalam 15 hari
(5 Ulasan)

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

$100 USD dalam 7 hari
(0 Ulasan)


$100 USD dalam 4 hari
(1 Ulasan)

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 Lagi

$225 USD dalam 3 hari
(64 Ulasan)

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

$190 USD dalam 7 hari
(1 Ulasan)

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.

$220 USD dalam sehari
(0 Ulasan)

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

$225 USD dalam 6 hari
(27 Ulasan)

i can provide you with the best solution.

$250 USD dalam 6 hari
(0 Ulasan)

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

$99 USD dalam 4 hari
(0 Ulasan)

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

$222 USD dalam 5 hari
(1 Ulasan)

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

$200 USD dalam 5 hari
(2 Ulasan)