4. Prioritizing Calls to Service Centres
a) Create a database table structure to store the data shown above, and enter the set of records above. (Use the short time format and a 24-hour clock for the Opening Hour and Closing Hour figures.) Print out a listing of this table.
b) Create a query that will allow the user to enter the current time and will Display a list of the locations and phone numbers of service centres that are open, sorted so that the location with the lowest communication cost per minute is listed first. Test your query to be sure that it works across all hours of the day. Print out results for 3:00, 10:00, 18:00, NS 23:00. (Note that centres open through Midnight have a closing hour that is earlier than their opening hour and require different treatment. Hint: Centres that open after 14:00 close at times earlier than their opening time. Literal time values can be entered in Access by placing # around the values, e.g., #14:00#.)
[See data/solutions files]
|
