Last Updated on 01/25/2023 by Sophia

4- 0
GI (23,335 unread) X rs’ao ADP Secure Clie X * My VU Collabor X BA05524 Assig x
wid Mail – yashvardl X 1
I Secure I https://yucollaborate.vu.edu.au/d21/1e/content/147412/viewContent/2163147/View
Irtri Apps W Potentiometer – Wik ( et Welcome to UPSEE 2 Q University of Petrole www.facilitiesnetcor www.cse.iitb.ac.in/cc pi What is Virtualizatioa. A The Benefits of Virtu. ( www.ijetae.com/files
CD P — +
SECTION M CASE STUDY USING ACTIVE DATA FOR EXCEL John Alexander, the financial controller of Ecochemicals Ltd (ECL), has provided you with the following computerised data files: • Authorised Suppliers (ECL_Supplier.xls) • Random sample of ECL’s purchases (extracted under the supervision of a member of your team; ECL_Purch_Trans.xls)
Key field details of these data files are listed below:
ECL Supplier.xls Field Type Description Supplier_No Supplier_Name Address 1 Address 2 State Post_Code Last Active ASCII (Text) ASCII (Text) ASCII (Text) ASCII (Text) ASCII (Text) ASCII (Text) DATE Approved Supplier Code Supplier Name Supplier address Date of last transaction
ECL_Purch_Trans.xls Field Type Description Supplier No ASCII (Text) Approved Supplier Code Invoice_Date DATE Invoice_Date Invoice_No ASCII (Text) Supplier’s Invoice No Invoice Amt Numerical(2 decimals) Invoice Amount Product No ASCII (Text) ECL’s Item identification code Quantity Numerical Number of units purchased Unit Cost Numerical(2 decimals) Price per unit
12:05 PM •lli 6/1/2018