Using Microsoft Excel and Access 2016 for Accounting 5th edition Glenn Owen - Solutions

Unlock the full potential of your accounting studies with our comprehensive resources for "Using Microsoft Excel and Access 2016 for Accounting" by Glenn Owen. Dive into our online answers key, offering detailed solutions and a complete solution manual in PDF format. Explore solved problems, chapter solutions, and a test bank designed to enhance your understanding. Benefit from our step-by-step answers and instructor manual to master complex concepts with ease. Access this essential textbook and download your free copy of solutions today. Elevate your learning experience and excel in your accounting courses effortlessly.

When creating a report, what does the process of summarizing accomplish?
Why are combo box controls used on a form?
Describe the process of adding lines to a report.
What function is used (and how is it written) to count records in a report?
What type of control is used in a report to add values?
How do you determine where information appears in a report?
What do the [ ] (brackets) signify in an Access formula?
Is it possible to group more than one item?
When creating a report, what does grouping accomplish?
Can you always add a field from any table to a report based on a query?
Why create a report from a query? Why not just print your query results?
Rosey’s Roses. Now the company would like you to help it create some forms to illustrate information from the database. Make the following changes using the ch11-06_student_name file you created in Chapter 11. (Open your ch11-06_student_name file and then save it as ch12-06_student_name before
In the last chapter you created some queries for the Snick€™s Board Shop. Now Caitlin would like you to help her create some forms to view information from the database. Make the following changes for Caitlin using the ch11-05_student_name file you created in Chapter 11.a. Note the
Modify the Products form (not the Ch 12 Assignment 5 form you just created) by changing the Category ID text box control to a special combo box control, listing the choices of CategoryID and CategoryName from the Category table. Be sure to first remove the relationship between the Product and
Add a new field (Taxable) to the Product Table. Make the field a Yes/No data type. Add this new field to the Products form (not the Ch 12 Assignment 4 form you just created) to the right of the Reorder Level control. Make Product ID 116 taxable. Save the form as Ch 12 Assignment 5. Print Product ID
Salespeople earn a 10 percent commission on the price of each sale. Create a new unbound calculated control to compute the possible commission on each product. Modify the Products form (not the Ch 12 Assignment 3 form you just created) by adding a calculated control called Commission Per Unit. (The
Modify the Product form (not the Ch 12 Assignment 2 form you just created) by changing the Category ID text box control to a combo box control that lists choices of A, B, C, D, E, or F. Save the form as Ch 12 Assignment 3. Print the newly created form for Product ID 110.
Modify the Products form by changing the Category ID text box control to a list box control that lists the choices as A, B, C, D, E, or F. Save the form as Ch 12 Assignment 2. Print the newly created form for Product ID 103.
Using the Ch12-02 file, modify the Buyers form for What SUP so that it looks like Figure 12.40. Save this form as Ch 12 Assignment 1, and print record 1 using this form.
What type of relationship must exist if a subform is used on a form?
Why must an existing relationship be deleted before modifying a field’s data type?
When is the Lookup Wizard used?
Why are check box controls used on a form instead of list box controls?
Why are calculated controls used on a form?
Why are list box controls used on a form?
Why are text box controls used on a form?
What is the difference between bound and unbound controls?
What view of a form is used to edit an existing form?
In the last chapter, you modified some tables for Rosey€™s Roses. Now the company would like you to help it create some queries to extract information from the database. Make the following changes using the ch10-06_student_name file you created in Chapter 10. Open your
In the last chapter you modified some tables for the Wine Depot. Now Barbara would like you to help her create some queries to extract some information from the database. Make the following changes for Barbara using the ch10-04_student_name file you created in Chapter 10. (Note:Open your
Create action queries for What SUP. (Use the Ch11-02 student file, or use the file you used in answering the previous question.)a. Create and run an update query that increases the unit price for all products by 6 percent. Save this query as Ch 11 Assignment 7a. Create and print an additional query
Create additional select queries for What SUP using statistics. (Use file you used in answering the previous question.)a. Create and print a select query that calculates the total sales value of all Flatwater SUPs in inventory. You’ll need to use your completed query from assignment 5b as the
Create additional select queries for What SUP using computed fields. (Use the Ch11-02 student file, or use the file you used in answering the previous question.)a. Create and print a select query that lists the product name unit price, unit cost, and unit gross profit for all products. Sorted in
Create select queries for What SUP using comparison operators. (Use the Ch11-02 student file, or use the file you used in answering the previous question.)a. Create and print a select query that lists the product name, unit cost, supplier name, and supplier contact name for any unit cost between
Edit select queries for What SUP. (Use the Ch11-02 student file, or use the file you used in answering the previous question.)a. Edit Query1 by adding the field PostalCode from the Supplier Tableand deleting the field StateorProvince. Save this query as Ch 11 Assignment 3a before you print it.b.
Create select queries for What SUP. (Use the Ch11-02 student file, or use the file you used in answering the previous question.)a. Create and print a select query that lists the product name, quantity, supplier contact name, and supplier phone number for any Inflatable SUPs. Save this query as Ch
Create select queries for What SUP using specific criteria (use the Ch11-02 student file).a. Create and print a select query that lists the buyer name, buyer phone number, and product name of product number 234. (The product number should not appear on your printed query if you answered the
When might you use a delete query?
What is a parameter query?
What is an action query? Give examples
Are the results of a calculation stored as a field in a table?
What will compound criteria allow you to accomplish in Access?
What are the three key comparison operators used in a query?
In Chapter 9, you created a database for Rosey’s Roses consisting of a Product table, a Type table, and a Grower table. You also created an initial query, form, and report. You have now been asked to make some changes to those files.Make the following changes using the ch9-06_student_name file
Change the structure of the What SUP database (Use the Ch10-02 file; do not use the file you just updated in Assignment 1 or 2.)a. Add the following product to the Product table. ProductID: 117; ProductName: LadyG; Length: 8.5; SupplierID: 6; CategoryID: F; ProductNumber: 3983AE; UnitCost: 620;
Add pictures to the What SUP database (use the Ch10-02 file;do not use the file you just updated in Assignment 1)a. Add pictures for the remaining products in the Product table using the picture files provided. Each product has a picture associated with it and is labeled with the product ID
Add, change, and delete records to the What SUP database (use the Ch10-02 file)a. Add the following record to the Buyers table: BuyerID 605, Farley, 555-7187.b. Add G as a CategoryID with a CategoryName of Women’s as a category to the Category table.c. Delete the following record from the Buyers
Why would you establish default values for a field?
What do validation rules do?
Define OLE.
Rosey€™s Roses is interested in more effectively managing their inventory. They would like you to put together a database of their current inventory. Create a new database file using the information below. Name the file ch9-06_student_name (replacing student_name with your name).a. Use
Create and edit tables for What SUP (use the Ch9-02 file)a. Create a new table for What SUP that includes fields BuyerID, BuyerName, and BuyerPhone. The first field (BuyerID) is a Number data type; the rest are Short Text data types. All should have captions that separate each word (e.g., Buyer
Create new reports for What SUP (use the Ch9-02 file)a. Create and print a report for What SUP that lists the supplier ID, supplier name, and city from the supplier table. (Use the supplier table to locate field names.) The report should have no grouping, be sorted by supplier ID in ascending
Create new forms for What SUP (use the Ch9-02 file)a. Create and print a form for What SUP that lists all fields from the supplier table in a columnar format. Once again, use the supplier table to locate field names. Save the form as Supplier Form, and print the first record only.b. Create and
Create new queries for What SUP (use the Ch9-02 file)a. Create and print a query for What SUP that lists the supplier name, contact name, and phone number of every supplier. Save the query as Supplier Query 1.b. Create and print another query for What SUP that lists the supplier name, address,
How do you switch between the Design view and the Layout view when creating reports?
To be useful, how should reports be organized?
What are reports?
Are headers and footers also a part of the record source?
How are controls used to create forms?
From where does most of the information in a form come?
What questions are asked by the Simple Query Wizard?
What facts must be identified for each query?
What are queries?
Which tool is used to establish relationships between tables?
Why isn’t all information entered into a single table?
Describe ways in which Access is used in Accounting.
What is the quickest way to access help while in Access?
What and where is the navigation pane?
Why would you use the File menu in Access?
Identify some new features in the 2016 version of Access.
How are tables related?
What is a DBMS?
Rosey’s Roses has several questions for you that Excel can help answer. Use student file ch7-13 to solve 3 of these problems. This file has three worksheets labeled: Present and Future Values, Cost Prediction, and Allowance for Uncollectibles. Complete the file answering the questions below and
Snick’s Board Shop has several questions for you that Excel can help answer.1. The company is planning for the future and would like you to prepare a present value analysis. Using the file ch7-10, complete a present value analysis for the following situations. Save the file as ch7-10_student_name
Wine Depot has several questions for you that Excel can help answer.1. The Wine Depot is planning for the future and would like you to prepare a present value analysis. Using the file ch7-07, complete a present value analysis for the following situations. Save the file as ch7-07_student_name
Kelly’s Boutique has several questions for you that Excel can help answer.1. 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_student_name
Create a new What SUP Cost Analysisa. Using the ch7-02 file to start your work, create a worksheet to do the following:i. Calculate the Hi-Lo Method variable cost/hour open and fixed cost.ii. Predicted expense under the Hi-Lo Method assuming 2,000 open hours.iii. Calculate the Least
Create a new What SUP Present Value Analysisa. Using the ch7-01 file to start your work, modify that worksheet to do the following:i. Calculate the annuity payment required at the end of each year for the next 4 years at 4 percent such that the value in 4 years is $95,000 and illustrate the annual
Compare the percent of sales and aging methods of determining uncollectible accounts expense and the ending allowance for the uncollectible accounts balance.
Describe how Excel can be used to calculate an allowance for uncollectible accounts using the aging method.
Describe how Excel can be used to calculate an allowance for uncollectible accounts using the percent of sales method.
Describe how to create a trend line for a chart.
What function is built-into Excel to help you calculate straight-line depreciation?
What arguments does the SLN function take?
Should the arguments in the SLN function be values or references?
Why should the arguments in the SLN function be values or references?
Should references used as arguments to the SLN function be absolute or relative?
What is the purpose of a depreciation summary?
What other depreciation functions are built into Excel?
What additional argument is added for these depreciation functions?
How do you add a new series of data to an existing chart?
Modify What SUP’s Straight-Line Depreciation Schedule You are to add another depreciation schedule for What SUP. Use the ch4-01_SLN_student_name.xls worksheet you created in this chapter. Add a new depreciation worksheet, labeled Asset 1003, using the Move or Copy Shortcut menu. The asset to
Modify What SUP’s Double Declining Balance Depreciation Schedule You are to add another depreciation schedule for What SUP. Use the ch4-01_DDB_student_name worksheet you created in this chapter. Add a new depreciation worksheet, labeled Asset 1003, using the Move or Copy Shortcut menu. The
Modify What SUP’s Sum-of-the-Year’s Digits Depreciation Schedule You are to add another depreciation schedule for What SUP. Use the ch4-01_SYD_student_name worksheet you created in this chapter. Add a new depreciation worksheet, labeled Asset 1003, using the Move or Copy Shortcut menu. The
What SUP’s Depreciation Comparison Chart for Asset 1002You are to add another depreciation chart for What SUP. Use the h4-01_Chart_student_name workbook you created in this chapter. Add a new depreciation chart by changing the name of Sheet2 to Asset 1002. Following the steps shown in the
What SUP’s Depreciation Comparison Chart for Asset 1003You are to create a depreciation chart for What SUP for Asset 1003. After completing assignments 1, 2, and 3, and following the steps shown in the chapter, create a new chart comparing straight-line, double declining balance, and
What SUP Partial Year Straight-Line Depreciation for Asset 1004 Create a new worksheet to calculate depreciation for a table purchased on August 1, 2017, for $95,000. It has an estimated salvage value of $2,000 and is to be depreciated over 10 years using the straight-line method. Follow the same
What SUP Partial Year Double Declining Balance Depreciation for Asset 1004Create a new worksheet to calculate depreciation for a table purchased on August 1, 2017, for $95,000. It has an estimated salvage value of $2,000 and is to be depreciated over 10 years using the double declining balance
What SUP Partial Year Sum of the Year’s Digits Depreciation for Asset 1004Create a new worksheet to calculate depreciation for a table purchased on August 1, 2017, for $95,000. It has an estimated salvage value of $2,000 and is to be depreciated over 10 years using the sum-of-the-year’s digits

Showing 1 - 100 of 176

Using Microsoft Excel and Access 2016 for Accounting 5th edition Glenn Owen - Solutions

Step by Step Answers