Sort+Consoles+(Access)

Open the // Consoles // database found in the // Game Console Stocks // folder, and change the layout to the portal. Use the database to answer the questions below: > (a) What is the primary sort field? > (b) What is the secondary sort field? > (c) Which shop do you think Jane would most like to work in? > (a) What are the 3 fields the database needs to be sorted on? > (b) Which shop is offering the cheapest new Microsoft Xbox? > (c) Which shop is offering the most expensive used Playstation 3? > > It is possible to answer this question with a combination of searching and sorting, as follows: > (i) Search Model = "Xbox" AND Condition = "New" > (ii) Sort the database in ascending order on the Price field. > (a) Which field should they search, and what should be the search term? > (b) Which field should they sort by? > (c) Should this field be sorted in ascending or descending order? > (d) What are the serial numbers of the consoles affected?
 * 1) Jane wants to get a job in a shop selling games consoles. She would prefer to work in a local retailer with a small number of employees.
 * 1) A computer magazine wants to do a report on which shops offer the best deals for new consoles. This means a sort on 3 fields.
 * 1) Nintendo have found an electrical fault with all models they have produced with a serial number in the range L0xxxxxxxx to L6xxxxxxxx. They know they should first search the database, and then sort the resulting fields: