Questions from Microsoft Excel and Access for Accounting

Q: Create a Financial Analysis for What SUP, Inc. as of

Create a Financial Analysis for What SUP, Inc. as of December 31, 2020. You are to create What SUP’s financial analysis as of December 31, 2020, from the information found on file ch3-03.xls. This fil...

Q: For each buyer name, create a form (using the Forms

For each buyer name, create a form (using the Forms Wizard) that contains the product name, quantity, and unit price of each product that the buyer is responsible for. Use the sub-form option with a d...

Q: Using the Ch13-02 file, create a report using all

Using the Ch13-02 file, create a report using all the fields present in the Buyer Query. View the data by Product Table with no grouping or summarization in a portrait orientation and adjusting the fi...

Q: Create a report using the Buyer Name, Product Name, Quantity

Create a report using the Buyer Name, Product Name, Quantity, Unit Cost, and Total Cost fields present in the Buyer query. View the data by Buyers Table and group by Buyer Name. Use the summary option...

Q: Open the report created in Assignment 2. Change the title of

Open the report created in Assignment 2. Change the title of the report to Products by Buyer. Add lines to separate each buyer. Add a line above the grand total amount. Save the new report as Ch 13 As...

Q: Kelly has a very fluctuating workforce based on seasonal demand. She’s

Kelly has a very fluctuating workforce based on seasonal demand. She’s ranged from having 10 employees in one month to 35 employees in another month. Some employees are paid a salary, others are paid...

Q: During a recent year Kelly’s Boutique had sales on account of $

During a recent year Kelly’s Boutique had sales on account of $6,025,000, collections of $5,800,000, write-offs of $50,000, a beginning balance in accounts receivable of $500,000, and a beginning bala...

Q: Kelly is planning for the future and would like you to prepare

Kelly is planning for the future and would like you to prepare a present value analysis. Using the file ch7-04 complete a present value analysis for the following situations. Save the file as ch7-04_s...

Q: The Wine Depot is trying to better understand the behavior of their

The Wine Depot is trying to better understand the behavior of their selling expenses. They have accumulated selling expenses over the last 6 months and believe units sold are a good predictor of expen...

Q: During a recent year, the Wine Depot had sales on account

During a recent year, the Wine Depot had sales on account of $1,601,542, collections of $1,523,541, write-offs of $23,487, a beginning balance in accounts receivable of $758,271, and a beginning balan...