Question: You have created a query based on the Employee Info table that calculates projected salary increases for 2019. The field in the table is formatted

You have created a query based on the Employee Info table that calculates projected salary increases for 2019. The field in the table is formatted as General Number, but you want the query to display the field results as currency. What is the best way to accomplish this? A) In Query View, select the Project Salary Increases for 2019 field. Use the Sort/Filter drop-down menu to select Currency. B) Change the field formatting in the EE Info Table to Currency. OC) In Query Design View, select the Project Salary Increases for 2019 field. Go to Query Tools Design > Results > Format > Currency. D) In Query Design View, select the Project Salary Increases for 2019 field. Go to Query Tools Design > Show/Hide > Property Sheet. Use the Form Property drop-down menu to select Currency

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Dick Hoover, owner of Modern Office Equipment, is concerned about freight costs and clerical costs incurred on small orders. In an effort to reduce expenditures in this area, he has decided to...

Home Insert Draw Page Layout Formulas Data Review View Tell me Calibel (Body 11 ' ' Wrap Text General BIU Merge Center $ % 9 *all-23 Call Conditional Format Formatting Table H19 H M N 0 4 Statistics...

Jones & Bartlett Learning, LLC. NOT FOR RESALE OR DISTRIBUTION CHAPTER Hot Spot Analysis 10 LEARNING OBJECTIVES C A R R Provide a working definition of a \"hot spot.\" , Be able to explain different...

I have no idea how, please help. AutoSave . Off 1 7 8 ~ Exp19_Excel App_Cap_Comp_Tech_Store Instructions - Read-Only - Word Search Austin Lindzy AL X File Home Insert Draw Design Layout References...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

help! payroll project for glo-brite paint company for 2020 7-6 CHAPTER 7. Paytoll Project Payroll Accounting PROJECT AUDIT TEST At the start of each pay period remove the Project Audit Test beginning...

Old MathJax webview please complete 1 2 and 3( there is no additional information) thanks **UPDATED QUESTIONS*** 1) what discourses or information, if any, does the company include about their...

answer problem 1 2 and 3 **UPDATED QUESTIONS*** 1) what discourses or information, if any, does the company include about their products in inventory. What key details are important to understanding...

Case requirements 1.Imagine yourself in Nancy John's position. Recall that Nancy was openly critical of the previous Executive Director (ED). Using the fraud triangle as a guide, speculate on the...

Deposit Rules for Glo-Brite Paint Company The FICA taxes and FIT taxes must be deposited on or before the 15th of the month following the month in w Federal taxes were withheld. Since Glo-Brite is a...

Describe the legal implications of electronic and Internet property transactions. 1. Examine one of the following acts and explain how it impacts the purchasing and selling of real estate. o Dower...

Sensitivity to life variation: 4 years to 7 years (20% to +40%). A new online patient diagnostics system for surgeons will cost $200,000 to install, cost $5000 annually to maintain and will have an...

Reverse annuity mortgages can be useful for elderly homeowners who want to access the equity in their homes without selling. True False

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...