Exercise 9

 

  1. Open the Premium database file and then open the Employees table.
  2. Sort records in ascending order by city by completing the following steps:

a)      Click any city name in the table.

b)      Click the Sort ascending button on the Table Datasheet toolbar.

c)      Print the Employees table in landscape orientation.

  1. Sort records in descending order by employee number by completing the following steps:

a)      Click on any number in the Emp # field.

b)      Click the Sort Descending button on the Table Datasheet toolbar.

c)      Print the Employees table in landscape orientation.

  1. Click the Save button to save the table.
  2. Close the Employees table and then close the Premium database file.