Questions and Answers of Using Microsoft Excel

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
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
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
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;
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
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
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
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;
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
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
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
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
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,
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,
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
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.
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
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
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
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
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
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
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
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
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

Showing 1 - 100 of 176