Final Fantasy Forums
Go Back   Final Fantasy Forums > Final Fantasy Extreme Discussion Central > 1001001011
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.

Reply
 
LinkBack Thread Tools Display Modes
Old 05-20-2007, 03:55 AM   #1 (permalink)
EoT
Senior Member
 
EoT's Avatar
 
Join Date: Feb 2007
Location: Sydney
Age: 19
Posts: 580
Rep Power: 5 EoT is on a distinguished road
Send a message via MSN to EoT
Default Microsoft Access trouble ( SQL, Parameter etc)

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.
Attached Images
File Type: jpg Database image.JPG (352.8 KB, 6 views)
__________________
EoT is offline   Reply With Quote
Old 05-21-2007, 05:02 AM   #2 (permalink)
Commodore Norrington
Member
 
Join Date: May 2007
Location: Britain
Age: 21
Posts: 47
Rep Power: 4 Commodore Norrington is on a distinguished road
Send a message via MSN to Commodore Norrington
Default

I may have misread, but are you just unsure about creating Queries? I'd rather not go into it all if I misinterpreted you. ;p
Commodore Norrington is offline   Reply With Quote
Old 05-21-2007, 05:12 AM   #3 (permalink)
EoT
Senior Member
 
EoT's Avatar
 
Join Date: Feb 2007
Location: Sydney
Age: 19
Posts: 580
Rep Power: 5 EoT is on a distinguished road
Send a message via MSN to EoT
Default

I'm unsure as to what to write in the criteria box's and how they work.
__________________
EoT is offline   Reply With Quote
Old 05-21-2007, 05:16 AM   #4 (permalink)
Commodore Norrington
Member
 
Join Date: May 2007
Location: Britain
Age: 21
Posts: 47
Rep Power: 4 Commodore Norrington is on a distinguished road
Send a message via MSN to Commodore Norrington
Default

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.
Commodore Norrington is offline   Reply With Quote
Old 05-21-2007, 06:13 AM   #5 (permalink)
EoT
Senior Member
 
EoT's Avatar
 
Join Date: Feb 2007
Location: Sydney
Age: 19
Posts: 580
Rep Power: 5 EoT is on a distinguished road
Send a message via MSN to EoT
Default

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
__________________
EoT is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT -4. The time now is 06:04 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.0.0