ACCT 3122 Accounting Information Systems McGraw-Hill Course Project
Section 3, Question 4 Move the Excel data to Microsoft Access and prepare queries to answer the following questions. Required: Continue with the same query; return to design view. Create a new field called purchase item amount to calculate the purchase amount for each item by multiplying quantity purchased (qty_purch) times price (purchase_price). Return to datasheet view, select Home > Records > Totals to add the total row to datasheet view. What is the sum of values in the purchase item amount field? (Round your answer to 2 decimal places.)
$1,109,973.39
Required: Compute the truck depreciation expense for the quarter (one fourth of the annual depreciation) for each store. Note that this is completed with two queries: 1) calculate the quarterly depreciation for each truck, and 2) sum the quarterly depreciation amount by store. Which of the following is the truck depreciation for the first quarter of 2022 for the Austin TX store?
$1,225.00
Section 3, Question 2 Move the Excel data to Microsoft Access and prepare queries to answer the following questions. Required: Continue with the same query; return to design view. Create a new field called item amount to calculate the sale amount for each item by multiplying quantity sold (qty_sold) times sale price (sale_price). Return to datasheet view, select Home > Records > Totals to add the total row to datasheet view. What is the sum of values in the item amount field? (Round your answer to 2 decimal places.)
$2,105,610.50
Compute the quarterly store depreciation for each store. Which of the following is the store depreciation expense for the first quarter of 2022 for the New York, NY store?
$612.50
In the above diagram, the correct multiplicities designated with the number 11 is which of the following?
0..*
In the above diagram, the correct multiplicities designated with the number 2 is which of the following?
0..*
In the above diagram, the correct multiplicities designated with the number 6 is which of the following?
0..*
In the above diagram, the correct multiplicities designated with the number 8 is which of the following?
0..*
In the above diagram, the correct multiplicities designated with the number 9 is which of the following?
0..*
In the above diagram, the correct multiplicities designated with the number 4 is which of the following?
0..1
*Section 2* Review the Excel data, prepare the UML class diagram (REA) for Y Not Flowers and then choose the correct fields to complete the Y Not Flowers table listing below:
1. retail price 2. store location 3. annual depreciation 4. check# 5. store# 6. store# 7. receipt amount 8. order# 9. sale date 10. store# 11. check# 12. check date 13. none of these 14. check# 15. account# 16. timecard# 17. store# 18. (FK) 19. store# 20. (FK) 21. order# + Inventory# 22. none of these
In the above diagram, the correct multiplicities designated with the number 7 is which of the following?
1..*
In the above diagram, the correct multiplicities designated with the number 1 is which of the following?
1..1
In the above diagram, the correct multiplicities designated with the number 10 is which of the following?
1..1
In the above diagram, the correct multiplicities designated with the number 3 is which of the following?
1..1
In the above diagram, the correct multiplicities designated with the number 5 is which of the following?
1..1
Section 3, Question 6 Move the Excel data to Microsoft Access and prepare queries to answer the following questions. Required: Use the Purchase Misc table. Limit purchases to the first quarter of 2022 beginning on January 1 and ending on March 31. How many records are there in your query?
109
Move the Excel data to Microsoft Access and prepare queries to answer the following questions. Required: Join the Timecards table with the Payroll table. Include the following fields in this query: timecard#, timecard_date, reg_time_hours, overtime_hours, emp#, supv_emp#, store#, check#, check_date, gross pay, emp_fica, employer_fica, emp_mc, employer_mc, fed_tax_wh, state_tax_wh, net_pay_to_employee. Limit timecard records to the first quarter of 2022 beginning on January 1 and ending on March 31. How many records are there in your query?
180
Section 3, Question 3 Move the Excel data to Microsoft Access and prepare queries to answer the following questions. Required: Join the Purchase Flowers table with the Purchase Flowers Items table. Include the following fields in the query: purchase#, purchase_date, grower#, purch_emp#, truck_vin, store#, check#, inventory#, qty_purch, purchase_price. Limit purchases to the first quarter of 2022 beginning on January 1 and ending on March 31. How many records are there in your query?
2,506
Move the Excel data to Microsoft Access and prepare queries to answer the following questions: Required: Join the Orders and Sales table with the Orders and Sales Items table. Include the following fields in the query: order#, order_date, customer#, order_emp#, sale_date, truck_vin, cash_receipt#, store#, inventory#, qty_ordered, qty_sold, sale_price. Limit sales to the first quarter of 2022 beginning on January 1 and ending on March 31, by entering BETWEEN #1/1/2022# AND #3/31/2022# for the sale_date field in the Criteria row of the query by example grid. How many records are there in your query?
2,636
In the above diagram, the correct name of the class designated with the letter B is which of the following?
Cash Receipts
*Section 1* In the above diagram, the correct name of the class designated with the letter A is which of the following?
Customers
In the above diagram, the correct name of the class designated with the letter D is which of the following?
Flower Inventory
In the above diagram, the correct name of the class designated with the letter E is which of the following?
Payroll
In the above diagram, the correct name of the class designated with the letter F is which of the following?
Purchases of Flowers
In the above diagram, the correct name of the class designated with the letter C is which of the following?
Stores
In the above diagram, the correct name of the class designated with the letter G is which of the following?
Vendors miscellaneous
