Skills Approach Access 2013 Chapter 4: Using Queries 030845

A Skills Approach Access 2013 Chapter 4 Using Queries And Organizing

A Skills Approach: Access 2013 Chapter 4: Using Queries and Organizing Information 1 | Page challenge yourself 4.3 Last Updated 4/3/15 challenge yourself 4.3 In this project you will continue working with the greenhouse database from Chapter 3, Challenge Yourself 3.3. Improve the functionality of this database by creating filters and queries for information that is commonly searched for. Skills needed to complete this project: ï‚· Using the Simple Query Wizard ï‚· Creating a Query in Design View ï‚· Adding Text Criteria to a Query ï‚· Adding Numeric and Date Criteria to a Query ï‚· Using AND and OR in a Query ï‚· Specifying the Sort Order in a Query ï‚· Hiding and Showing Fields in a Query ï‚· Adding a Calculated Field to a Query ï‚· Finding Unmatched Data Using a Query ï‚· Filtering Data Using AutoFilter ï‚· Filtering Data Using Filter by Selection ï‚· Sorting Records in a Datasheet 1.

Open the start file AC2013-ChallengeYourself-4-3. 2. If necessary, enable active content by clicking the Enable Content button in the Message Bar. 3. The file will be renamed automatically to include your name.

Change the project file name if directed to do so by your instructor. 4. Create a new query named: GreenhouseTechsFT a. Add all the fields from the Employees table. b. The query should list all employees whose Position contains the word greenhouse and whose weekly hours are greater than or equal to 30. c. Modify the query design so results are sorted alphabetically by last name. d. Add the MaintenanceLog table to this query and include the Date_Time field after the WeeklyHours field. e. Run the query to review the results. f. Save and close the query. 5.

Create a new query named: MediumSizePlants. a. Add all the fields from the Plants table except ScientificName. b. The query should list all white or yellow colored plants whose MaxHeightFeet is at least 3 and not greater than 5. c. Modify the query design so results are sorted by values in the MaxHeightFeet field with the shortest plants listed first. d. Run the query to review the results. e. Save and close the query. Step 1 Download start file A Skills Approach: Access 2013 Chapter 4: Using Queries and Organizing Information 2 | Page challenge yourself 4.3 Last Updated 4/3/. Create a new query named: RedPlantSale a. Add the following fields from the Plants table to the query: CommonName, FlowerColor, PurchasePrice. b. Select only those plants with a red color, but don’t show this field in the query results. c. Add a calculated field that displays a sale price that is 80 percent of the purchase price. Use the name SalePrice for the new field. d. Run the query to review the results. e. Save and close the query. 7.

Use the Find Unmatched Query Wizard to create a new query that identifies the plants that have no entry in the MaintenanceLog. a. Include all fields from the Plants table except the PlantID. b. Name this query: PlantsMissingMaintenance c. Close the query. 8. Open the MaintenanceLog table. Apply a filter that shows only those plants that have been watered and pruned. Save and close the table. 9. Open the Plants table. Use sorting (in ascending order) so the records are sorted by flower color and then by the date planted for each color. Save and close the table. 10. Close the database and exit Access. 11. Upload and save your file. 12. Submit project for grading. Step 2 Upload & Save Step 3 Grade my Project Guided Response: discussion 1: Review your peers’ posts and respond to at least two of your classmates. Describe how job order costing, process costing, or activity based costing could resolve or exacerbate the issues your classmates discussed in their initial posts.

Peer 1:Vice If any company is evaluating the performance by comparing the current results with the actual results of previous accounting periods they may face problems or in other words if the company will base their decisions entirely on the basis of past performance then the company has to face the following problems. 1) It is not necessary that the two problems will necessarily be solved in the same manner as it was solved in the past .Suppose last time supplier had given you discount and as a result the cost of production has came down but it is not necessary that the supplier will also give you same discount as in the previous year. 2) If we evaluate our performance based on the past results then it gave rise to rigidity and it is not possible to change according to the requirements of the current year. 3) If the company is evaluating the performance based on the past results then it may be possible that the company has to face net loss because the company is not changing according to the current year requirements. Therefore on the basis of above reasons it is not said that the company will not rely on the past performance to compare the current results. It must rely on the past performance but if there is requirement to change then it must change according to the requirements and not become rigid in changing the results Peer2:ROYBAL: Many companies/organizations use the previous accounting periods as a tool to forecast for the current period; for quite some time this worked pretty well; however, with the turbulent economy and the costs constantly increasing, it is hard to grasp the true cost for any company/organization.

There could potentially be problems that arise from using this approach, as the previous accounting periods could have resulted in lower costs for materials or inaccurate information was inputted; it is best to look at the previous accounting periods and understand what exactly caused that particular outcome, as it may not have occurred in the past and may not occur again. Discussion 2: Flexible Budgets Flexible budgets provide different information than static budgets. Discuss some of these differences. Is a flexible budget always better? Are there times when you’d recommend using a static budget over a flexible budget?

Guided Response: Review your peers’ posts and respond to at least two of your classmates. Discuss whether you agree or disagree with the uses of a flexible budget and why. Peer1:Evans A budget is similar to a roadmap – it steers a company in the right direction (Hallinan, 2004). It is an annual battle to squeeze out information from operating units to provide a guess at the upcoming year results (O’Sullivan, 2007). A comprehensive, or static, budget is insensitive to fluctuations, and based on a single level of activity.

This can be a challenge to a business in regards to performance evaluations. The goal of a flexible budget is being able to adjust for levels of fluctuations (Principles of Accounting, 2012). The master operating budget considers the previous year’s performance in addition to expectations for the upcoming year. As variable costs fluctuate and change with production, using static budgets can be way off of actual levels of performance. Flexible budgets can forecast set amounts so adjustments can be made (Hallinan, 2004).

Results are conflicting, as to whether a fixed or flexible budget should be used – it depends on the business. It depends on whether a company is retail or service-oriented. There are a lot of variances. Traditional budgets allegedly do not work well where situations are uncertain (Ekholm & Wallin, 2007). This is where flexible budgets come into the picture.

Small or large, businesses must choose what works best for them. I own a small retail business, and honestly, it is possible to use both types of budgets to make my business work. Hallinan, E. (2004). Tracking Your Cost-Management Performance. Reeves Journal: Plumbing, Heating, Cooling, 84(3), 10-13.

O'Sullivan, K. (2007). By the numbers . Cfo , 23 (12), 23. Ekholm, B., & Wallin, J. (2011). The Impact of Uncertainty and Strategy on the Perceived Usefulness of Fixed and Flexible Budgets.

Journal Of Business Finance & Accounting , 38 (1/2), . doi:10.1111/j..2010.02228.x Peer2: ROBERTS: Flexible budgets provide different information than static budgets. Discuss some of these differences. A Flexible and Static budgets are two separate parts of business accounting. However, they serve as different business information providers. First the Static budget is a good way of advance planning and tracking the revenue and production cost of a business within a given period of time.

The Flexible budget allowing management to make adjustments in the business’s static budget to match the changing circumstances of the business operating cost and / or production need. Is a flexible budget always better? The flexible budget is good for manufacturing companies which production cost could change based on the number of goods needed to meet the consumer’s demand. The reason I think the flexible is better is because business cycle analysis tool and cannot be compiled before the end of the business cycle However, the flexible budget is not that good for service type companies, because they do not own or produce anything. Service companies usually have little overhead and the static budget work best for the business owner has a reasonable amount of certainty of what its operation cost.