Sorting+Passengers+(Access)

Open the // Passengers // database found in the // Flight Bookings // folder, and change the layout to // Customer - Flights Join //. Use the database to answer the questions below:

> (a) What is the primary sort field? > (b) What is the secondary sort field? > (c) What is the first flight number? > (d) What is the problem sorting the loyalty schemes in this way? Can you think of a way to resolve this? > (a) What is the primary sort field? > (b) What is the secondary sort field? > (c) Which passenger appears first alphabetically travelling to Madrid? > (d) Which passenger appears first alphabetically travelling to Sydney? > (e) What problem do you see with sorting the passengers alphabetically? Can you think of a way to resolve this? > (a) What is the primary sort field? > (b) What is the secondary sort field? > (c) Which airport appears first in the list? > (d) What is the postcode which appears first in the list of passengers leaving from Edinburgh?
 * 1) The check-in desk needs to sort passengers in order of flight number, and for each flight sort the passengers into Loyalty Schemes.
 * 1) The check-in desk wants to sort all passengers depending on their destination. Passengers going to the same destination should be sorted in alphabetical order.
 * 1) The check-in desk want to organise all passengers in order of their where they are leaving from, and passengers going to the same destination should be sorted into postcode.