ACL in practice
Chapter 2 Examine Employee Data
ACL in Practice
Name: Samantha A. Babia Course & Section: ______________ Date: _______________
NOTE: Rename or Save this file as your Surname4A_Ch2_prac and if you’re finished, submit it to \\b501-server under submit ---chap2 practice folder.
Points to Remember: An ACL project is a holder for data that you import into ACL as tables. When you use ACL, you either create a new project to work with, or you open an existing project. A command is the name of a specific action taken in ACL. The Statistics command works with numeric and date fields. Profile works with numeric fields only. One way to ensure the integrity of the data is to check for duplicate records. To find the total amount of a field, use the Total command. The Quick Sort feature lets you view the data in sequential order. A filter is a logical expression that you can type in the view’s Filter text box. ACL displays only those records that match the filter. An expression is a set of operators and values that you use to perform calculations, specify conditions for a test, or create values that do not exist directly in the data. An ACL expression can be a combination of data fields or computed fields, operators,constants, functions, and variables.
Commands: Statistics, Profile, Duplicate, Total, Quick Sort--- See the detailed explanations below.
In this chapter you accomplished the following tasks:
■ Opening a project
■ Viewing the project contents
■ Using Statistics and Profile commands to analyze data
■ Using Quick Sort to sort the data in a specified order
■ Creating and applying filters
Examine the employee list
Tasks: View the employee data project. Get a statistical picture. Check for duplicate employee records.
Open and view the employee data project
Open the employee data project
Project: Open an existing project---Metaphor_Employee_Data and save project as Surname4A_Metaphor_Employee_Data, then OK, and close
ACL in Practice
Name: Samantha A. Babia Course & Section: ______________ Date: _______________
NOTE: Rename or Save this file as your Surname4A_Ch2_prac and if you’re finished, submit it to \\b501-server under submit ---chap2 practice folder.
Points to Remember: An ACL project is a holder for data that you import into ACL as tables. When you use ACL, you either create a new project to work with, or you open an existing project. A command is the name of a specific action taken in ACL. The Statistics command works with numeric and date fields. Profile works with numeric fields only. One way to ensure the integrity of the data is to check for duplicate records. To find the total amount of a field, use the Total command. The Quick Sort feature lets you view the data in sequential order. A filter is a logical expression that you can type in the view’s Filter text box. ACL displays only those records that match the filter. An expression is a set of operators and values that you use to perform calculations, specify conditions for a test, or create values that do not exist directly in the data. An ACL expression can be a combination of data fields or computed fields, operators,constants, functions, and variables.
Commands: Statistics, Profile, Duplicate, Total, Quick Sort--- See the detailed explanations below.
In this chapter you accomplished the following tasks:
■ Opening a project
■ Viewing the project contents
■ Using Statistics and Profile commands to analyze data
■ Using Quick Sort to sort the data in a specified order
■ Creating and applying filters
Examine the employee list
Tasks: View the employee data project. Get a statistical picture. Check for duplicate employee records.
Open and view the employee data project
Open the employee data project
Project: Open an existing project---Metaphor_Employee_Data and save project as Surname4A_Metaphor_Employee_Data, then OK, and close