![]() |
|
|||||||
| Final Fantasy | Final Fantasy Forums | Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| 1001001011 Come to this forum to get technical help, or just discuss technology as a whole; computers, electronics, phones, and other accessories that make us drool. |
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|
#1 (permalink) |
|
Senior Member
|
We were assigned to make a reservation system for IPT using Microsoft Access, I've looked in my textbook and cannot find any information on the topic. I've messed around with stuff in it but none of it does the job it does and I'm starting to worry cause this is due on Wednesday.
For the first part we had to create 2 queries to select the following specific data: Flights by flight No, Departure Date, Departure city, departure time, arrival date, destination city and Arrival date. The other one was flights by departure date, flight no, departure time, class, seat no and customer name. For the parameter query we had to do all data by destination city and class of seat, save as PARQ_1 And the hardest part was to create a form based on the following specifications, 1. Create a travel reservation form based on the parameter query for PARQ_1. The form will allow the travel agent to book seats for a customer. The form should include travel agency's logo (i made one already) and adhere to good principles. Well that's what I have to do, I've made the database already just need to sort the query business out, any help is greatly appreciated. I've included a image of the database below.
__________________
|
|
|
|
|
|
#4 (permalink) |
|
Member
|
I don't have Access on my laptop, so I couldn't help you sooner. I'm in college right now, so give me half an hour, and I'll walk you through it. ;D
EDIT: Well, I'm confused. I've gone over creating a Query with Wizard, but there doesn't seem to be anything there that you shouldn't be able to do. Are you sure you don't just mean Reports? That's the only thing I can think of which could even remotely confuse anyone. |
|
|
|
|
|
#5 (permalink) |
|
Senior Member
|
For the parameter query we had to do all data by destination city and class of seat, save as PARQ_1
And the hardest part was to create a form based on the following specifications, 1. Create a travel reservation form based on the parameter query for PARQ_1. The form will allow the travel agent to book seats for a customer. The form should include travel agency's logo (i made one already) and adhere to good principles. These two are the parts which I'm unsure of how to work with them ![]()
__________________
|
|
|
|
![]() |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Trouble with iso mounting | EoT | 1001001011 | 6 | 04-08-2007 10:13 AM |
| Trouble Loading FFE | Saint | Feedback & Inquiry | 15 | 03-25-2007 06:23 PM |
| Alright... Someone with the access... | My Final Heaven | Green Eggs and SPAM | 4 | 02-06-2007 10:45 AM |
| Gallery Trouble | Scrutator | Feedback & Inquiry | 5 | 02-02-2007 11:21 AM |