Final%20Exam%202008

Final%20Exam%202008 - St. Johns University Tobin College of...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
St. John’s University Tobin College of Business Fall 2008 Final Exam Accounting 3354 Name: Download the database named Final2008 from Blackboard and answer the following questions. You must show ALL your queries in how you arrived at your answer, and you MUST show me at least 5 rows of your results table. Points will be deducted for not following instructions. The database is comprised of a table of Vendor Names, a table of Offices and a table of accounts payable transactions. I will ask you to query this data and find answers to questions. Question 1: Write a query to find all the accounts payable transactions in the month of February (perpost should be September) that are more than $10,000. Partial Answer (9): Question 1 Journal Type Period ID Account Sub CuryTranAmt AP 200709 00MIXIT 14180 000 13000 AP 200709 00PRAMASEC 17100 000 12500 Post your query and or queries below and at least 5 records. SELECT jrnlType, PerPost, vendid, account, sub, CuryTranAmt from APTransTb where perpost = '200709' and CuryTranAmt > 10000 Query1 Journal Type Period ID account sub CuryTranAmt AP 200709 00MIXIT 14180 000 13000 AP 200709 00PRAMASEC 17100 000 12500 AP 200709 00RAPTOR 52210 400 10600 AP 200709 00ACTIV 58200 100 10500 AP 200709 00AUTOMATE 58200 100 24094 AP 200709 00AUTOMATE 58200 400 43025 AP 200709 00AUTOMATE 58200 900 10326
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Question 2: Write a query to find any records that that a Journal Type other than AP. Partial Answer (49): Question 2 Tran Type Journal Type Period ID Account Sub CuryTranAmt VO PO 200708 00ATLASSIN 17050 000 4800 VO PO 200704 00DAMBRA 17050 000 0 Post your query and or queries below and at least 5 records. answer1 Tran Type Journal Type Period ID account sub CuryTranAmt VO PO 200708 00ATLASSIN 17050 000 4800 VO PO 200704 00DAMBRA 17050 000 0 VO PO 200708 00DATAEXCH 17050 000 100 VO PO 200708 00DATAEXCH 17050 000 2298 VO PO 200708 00DATAEXCH 17050 000 3562 SELECT trantype, jrnlType, PerPost, vendid, account, sub, CuryTranAmt from APTransTb where jrnltype <> 'ap'
Background image of page 2
Question 3: Write a query to find records with a Transaction Type not equal to VO Use the exact same fields as question 2. There are only 2 records. Post your query and or queries below and both records. answer2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/26/2010 for the course ACC 639 taught by Professor Mccarthy during the Spring '10 term at St. Johns Duplicate.

Page1 / 14

Final%20Exam%202008 - St. Johns University Tobin College of...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online