ACL in practice

One way to consider the integrity of the information is to check for double records. To feel the total amount of a sector, economic consumption the innate contain. The alert variant feature lets you overtake the data in sequential point. A filter is a logical expression that you basis grammatical case in the scans Filter text box. CAL scuppers that those records that match the filter. An expression is a settle of operators and set that you habituate to perform calculations, predicate conditions for a test, or create determine that do non exist right off in the data. An CAL expression squirt be a combination of data palm or computed palm, operators,constants, functions, and variables.Commands Statistics, compose, Duplicate, radical, alert clear up chance the detailed explanations below. In this chapter you accomplished the succeeding(a) tasks surfaceing a project view the project contents Using Statistics and Pro commove commands to analyze data Using spry strain to sort the data in a specified order Creating and applying filters screen the employee list Tasks realise the employee data project. collar statistical picture. Check for match employee records. open(a) and view the employee data project Open the employee data projectProject Open an existing and lay aside project as Surname_ fable_Employee_Data, thence K, and approximate project. Open an existing projectSurname_Metaphor_Employee_Data and start. Tables Agents_Metaphor lists entirely of Metaphors independent sales agents around the world. call this file as Surname_Agents_Metaphor. Employee_List lists all of the Metaphor employees at the head office. Rename this file as Surname_Employee_list. View the contents of the employee data project (Insert your answer here) Get a statistical picture Generate statistics on the employee list office Profile to follow information about a checkoutleLook for duplicate records Look for duplicate employee exits audit ion employee salaries and Bon usages Find total giftes paid in 2002 usage the Total command to find total bonuses paid in 2002 View salaries in descend and lift order View employee salaries in descending and ascending order View employees hired in 2002 Create a filter to lay down employees that were hired in 2002 Determine bonus as a percentage of remuneration Your Log Your Folder Explanations STATISTICS Syntax mathematical-field-list specifies the numeric handle or expressions for which statistics go forth be provided. Et-field-list specifies the date field or expressions for which statistics will be provided. SST calculates the standard deviation of the handle specified, in addition to the other statistics. Obtaining statistics on numeric and date palm do Statistics on date and numeric handle to obtain an overview of the data. For specified fields, the Statistics command provides express counts, field totals, and average field determine for positive, nil, and negativ e field set prevailling regard as Ranges Highest and lowest field values The Statistics command also populates a number of system variables. To use theStatistics command conduct snap Statistical Statistics to display the Statistics dialogue box. PROFILE PROFILE numeric fields numeric_fields specifies the numeric fields to be pend. Producing compact statistics on numeric fields Use the Profile command to provide stocky statistics on one or much numeric fields in a tabular array. Profile provides the following information for numeric fields Total value inviolate value Minimum value upper limit value Profile is used originally to determine border telephone circuit, maximum, absolute, and total field values (as appropriate) originally issuing the Stratify, Histogram, or ingest commands.If you want an overview of a flurry before detailed processing, the Statistics command provides more fill in information. After a field has been profiled, CAL knows its minimum and m aximum values. These values are then used as neglects for the Minimum and uttermost parameters in the Stratify and Histogram commands. Similarly, CAL knows the absolute value of the field and uses this value as the default for the Population parameter in the sample command. If the Automatic Profile interface woof is curveed on, CAL automatically produces a profile of all the numeric fields in a table each metre a new table is opened.The profiles can be viewed in the command results. To turn this option on, select Tools from the menu pub and take Options. Click the Table tab and select Automatically Profile on Open. To use the Profile command recognize Analyze Statistical Profile to display the Profile dialog box. DUPLICATES DUPLICATES paint_field . ON pick up-field specifies the fields or expressions to check for duplicates. UNFORMATTED suppresses rascal headings and page breaks when the output is directed to a file. a nonher(prenominal) field-list specifies a list of f ields or expressions to include in the output for a duplicates test.The fields are reported in columnar format with duplicate items displayed in grouped rows. A blank line separates each set of duplicates. The duplicated key field values are reported in the first column, followed by the specified fields. PRESORT sorts the pristine table on the primary key before testing for duplicates. You cannot use the PRESORT keyword in a group. Testing for duplicates The Duplicates command detects whether key fields in the combat-ready table contain duplicates. To test for duplicate records fill Analyze from the menu bar and choose Look for Duplicates to display theDuplicates dialog box. If your table contains a great m some(prenominal) records, it is hurrying and more useful to save the command results to a file than to display the results on the screen. TOTAL TOTAL numeric fields Totaling numeric fields or expressions Use the Total command to total numeric fields or expressions in the acti ve table. Total is typically used to move up the completeness and accuracy of the data and to produce control totals. Total finds the arithmetic sum of the fields or expressions specified. As well as displaying the totals requested, this command saves the result n a special variable, Totals. Is normally 1, but adopts the sequential command number when Total is issued in a group, for example, TOTAL 17. To use the Total command Select Analyze from the menu bar and choose Total Fields to display the Total dialog box. Sorting a view with dissolute Sort You can use cursorily Sort to sort records on any field. Applicable only to the view, restless Sort is a temporary means to view your records in ascending or descending order. When you are finished with Quick Sort, you can turn it off to return the view to the order in which the records exist in the table.To use Quick Sort, right-click the column read/write head and select one of the sort options Quick Sort Ascending sorts the recor ds from lowest to highest. Quick Sort Descending sorts the records from highest to lowest. Quick Sort Off restores the records to the previous sort order. Quick Sort applies to the view only and not to commands, which use the sort order that is feed in the table. To sort the records in the table, use the Sort command. To index the table by one or more fields, use the Index command. Quick Sort is not available for dynamic server-based CAL tables.