Chapter 6 Practice #1
1. Verify all fields in the table. Note any exceptions. a. There were zero validity errors.
2. Compare the record count on the bottom of the screen with information provided in the client
memo. Notice any exceptions. a. There are 932
I used the count command to confirm that there were 42 records.
No exceptions found.
The command Total fields (TOTAL FIELDS BONUS SALARY
PAY_PER_PERIOD) on table Metaphor_EmpMast. I got Bonus of $23,100, Salary
$1,152,525, and Pay_Per_Period
Chapter 8 Assignment #1
1. Sales Invoice (Type = IN and AMT <0): all numbers are positive as
they should be. Payments (Type= PM and AMT>0): Payment is a negative
number Write offs (Type= WO and AMT>0): Writeoff should a negative number