Medalla4C Ch2 Exer
Chapter 2 Examine Employee Data
ACL in Practice
Name: Josie Mae Medalla Course & Section: BSAT 4C Date: November 17,2014
NOTE: Rename or Save this file as your Surname4A_Ch2_exer and if you’re finished, submit it to \\b501-server under submit ---chap2 exercises folder.
Exercises (page 18)
Project: Open an existing project---Surname4A_Metaphor_Employee_Data and start.
Tables: Agents_Metaphor and Employee_List
1 Can you run the Profile command on just the HireDate in the Employee_List? NO
Can you run the Statistics command on just the HireDate? YES
What results do you get?
When are the Statistics and Profile commands useful?
2 Quick Sort the Employee_List on the Bonus_2002 column.
3 Quick Sort Agents_Metaphor on the Comm_2002 column in ascending order, then in descending order.
Run Statistics and Profile on this table.
4 Find the total commissions paid to Metaphor agents in 2002.
5 Make the view easier to read by adjusting column widths and dragging columns left or right. You can adjust the columns at any time while you follow the tutorial.
6 Log
7 Folder
ACL in Practice
Name: Josie Mae Medalla Course & Section: BSAT 4C Date: November 17,2014
NOTE: Rename or Save this file as your Surname4A_Ch2_exer and if you’re finished, submit it to \\b501-server under submit ---chap2 exercises folder.
Exercises (page 18)
Project: Open an existing project---Surname4A_Metaphor_Employee_Data and start.
Tables: Agents_Metaphor and Employee_List
1 Can you run the Profile command on just the HireDate in the Employee_List? NO
Can you run the Statistics command on just the HireDate? YES
What results do you get?
When are the Statistics and Profile commands useful?
2 Quick Sort the Employee_List on the Bonus_2002 column.
3 Quick Sort Agents_Metaphor on the Comm_2002 column in ascending order, then in descending order.
Run Statistics and Profile on this table.
4 Find the total commissions paid to Metaphor agents in 2002.
5 Make the view easier to read by adjusting column widths and dragging columns left or right. You can adjust the columns at any time while you follow the tutorial.
6 Log
7 Folder