Case Study: Personnel

[R_6]

• With the Personnel table open in Table view.
• Place the cursor in the field you wish to sort by, then click on the sort ascending or sort descending button.

• Sort the database into numerical order on Store Number
• Sort the database into alphabetical order on last name.

• When databases get really large we sometimes want cascading sorts. For example;
  Sort first by TownCity then within TownCity sort the lastnames alphabetically.
• This is achieved as follows;
• From the menu bar, select
   Records | Filter | Advanced Filter/Sort...
• This will bring up the window below;
  
• Use the drop box on the right of the field to select TownCity, and choose Sort Ascending.

• In the next column choose LastName, and sort ascending.
• Finally Click the Apply filter button.
• Look carefully at the data. See how the names are sorted within TownCity.

• Try the following cascading sorts
  • Hourly rates within job title
    (Order is Job title, Hourly rate)
  • Ascending departments within address, AND in descending order of Hourly rate!
    (The order is Address, Department, Hourlyrate)

• Review the querying function (see Membership M_6)
  With the Personnel table open in Table view.
• Who are the employees in the Operations Department?

• Who are the employees in NAPIER and employed in Store No 1 ?
• Which employees earn $8 or more per hour?
• Printout 3: Preview then print out one of the queries.