Question

Auditors must gather evidence, and obtain documentation around identified risks. A risk in the purchasing process is that a purchase is made from an unauthorized vendor. To gather evidence around this risk, we first want to open and join the two data sets (Accounts_Payable and Vendors) for Roger Company to begin the process for identifying the unauthorized vendors. Once the file is open, join the databases. With the Accounts_Payable file open, on the Analysis tab, in the Relate group, select Join to open the Join Databases window. Select Vendors as your Secondary database. Join both databases by vendor number in the Match menu (refer to Section 4 of the tutorial for additional help. Hint: AP Vendor Number must both be the same field format, i.e., either both numeric or both character). Choose to retain all records in both files. How many total records are there in the joint database

Answer 1

To gather evidence around the risk of making a purchase from an unauthorized vendor, auditors should open and join the Accounts_Payable and Vendors databases for Roger Company, using vendor number as the matching criteria. Retain all records in both files and determine the total number of records in the joint database.

Step-by-step explanation:

To gather evidence around the risk of making a purchase from an unauthorized vendor, auditors can open and join the Accounts_Payable and Vendors databases for Roger Company. Firstly, open the Accounts_Payable file and go to the Analysis tab. Then, in the Relate group, select Join to open the Join Databases window. Choose Vendors as the Secondary database and join both databases by vendor number in the Match menu. Retain all records in both files and determine the total number of records in the joint database.