Evaluate your audit action sheets:

Look inside the Master File for the document titled Audit Action Sheets and open it to edit it$.$

Use the Yellow highlighter to identify any master or transaction tables, such as $$Vendors$$ or $$Purchase Orders.$$

Use the Green highlighter to identify any fields or attributes, such as $$Name$$ or $$Date$.$

Use the Blue highlighter to identify any specific values or rules, such as $$TRUE$,$January $1$st$,$Greater than $...$

Summarize your highlighted data:

Create a new Excel workbook in your Master File to summarize your highlighted data elements from the three audit action sheets. Use the following headers:

AAS# Table Attributes Values$/$Rules Step$($s$)$ Notes

Take a screenshot $($label it $5-4$MA$)$ of your completed spreadsheet.

Now that you have analyzed the action sheets, look through the systems documentation to see where those elements exist:

In the Master File, open the UML System Diagram and Data Dictionary files.

Using the data elements you identified in your Audit Automation Summary file, locate the actual names of tables and attributes and acceptable data values. Add them in three new columns in your summary:

Database Table Database Attribute Acceptable Values

Take a screenshot $($label it $5-4$MB$)$ of your completed spreadsheet.

After you answer the lab questions, save your file as Audit Automation Summary.xlsx and continue to the next part.