Access Project
$30-40 USD
Paid on delivery
this project is to be done in access database and i am sending the database and the description is fully there so that you guys can work it out...
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
this project is in microsoft access i tried my bit but i am concentrating on my exams which are approaching soon i am sending the access database as an attachment too and in this project we are required to create dao subroutines using access and NOT USING VISUAL BASIC....
in the mdb file which i am sending you
you will create four DAO subroutines to be run from the VBA IDE by entering the name in the debug [url removed, login to view] should go to the same window.
1. the first sub routine should create a new table named dao_reservations to hold reservations for entire [url removed, login to view] this table using DAO DDL.
2. the second sub routine should accept reservations for [url removed, login to view] user enters the flight number and day desired and if seats are available on all legs a reservation is [url removed, login to view] not possible a suitable error message is [url removed, login to view] a reservation is made customer information (eg name,phone) is [url removed, login to view] seats are assigned at this point.
3. the third sub routine makes a seat assignment on a particular flight leg instance for which a customer has already made a reservation as described above.a seat is assigned to the [url removed, login to view] may assume that seats are integers and assign seat 1 to the first customer to ask for seat assignment ,seat 2 to the second customer etc.
4. the fourth sub routine should check whether the airplanes being assigned to flight legs are able to land at the destination airport for flight [url removed, login to view] this is not possible,a message is printed and the user is prompted to change the aircraft type to an appropriate [url removed, login to view] sub routine then makes the change(after verifying it).
you may need to change the data stored in your tables to test your sub routines (eg make the number of seats on some aircraft small so that the plane can be filled easily).
you should test your sub routines(2-4) under various circumstances (multi-leg flight,attempt to reserve a sold-out flight,attempt to assign a seat to a cusatomer without reservation, etc).
do error checking.
your program should NOT use VB [url removed, login to view] VBA Debug WINDOW and message /input box.
## Platform
windows any version...
## Deadline information
AT ANY COST TODAY .... I MEAN LATEST BY 12:00 MIDNIGHT EASTERN STANDARD TIME..
Project ID: #2882209
