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 [login to view URL] should go to the same window.
1. the first sub routine should create a new table named dao_reservations to hold reservations for entire [login to view URL] this table using DAO DDL.
2. the second sub routine should accept reservations for [login to view URL] user enters the flight number and day desired and if seats are available on all legs a reservation is [login to view URL] not possible a suitable error message is [login to view URL] a reservation is made customer information (eg name,phone) is [login to view URL] 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 [login to view URL] 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 [login to view URL] this is not possible,a message is printed and the user is prompted to change the aircraft type to an appropriate [login to view URL] 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 [login to view URL] 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..