Author Question: You are trying to assess the performance of your North American branches. The performance measure is ... (Read 20 times)

tatyanajohnson

  • Hero Member
  • *****
  • Posts: 569
You are trying to assess the performance of your North American branches. The performance measure is gross profit. The relevant figures are contained in the Gross Profit field. If Gross Profit is greater than or equal to 55, the custom field, named Status, will read Approve. If Gross Profit is between 54 and 30, the custom field will read Attention. If Gross Profit is less than 30, the field will read Fail. What is the field name that will be entered?
 
  A) IIf(Gross Profit >=55, Approve, IIf(Gross Profit >=30, Attention, Fail))
  B) IIf(Gross Profit >=55, Approve, IIf(Gross Profit >30, Attention, Fail))
  C) IIf(Gross Profit >=55, Approve, >30, Attention, Fail)
  D) IIf(Gross Profit >=55>30, Approve, Attention, Fail)

Question 2

Which of the following is NOT true when creating fields and entering data in those fields?
 
  A) When you have fields such as name or address that are composed of several smaller fields, you should split them into their component parts.
  B) Consider whether you might want to report on smaller parts of the field to determine what fields to create.
  C) Enter first and last names in alphabetical order in case two people have the same last name.
  D) Splitting fields into smaller parts allows for more flexibility for reporting.



quynhmickitran

  • Sr. Member
  • ****
  • Posts: 330
Answer to Question 1

A

Answer to Question 2

C



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Parkinson's disease is both chronic and progressive. This means that it persists over a long period of time and that its symptoms grow worse over time.

Did you know?

Vital signs (blood pressure, temperature, pulse rate, respiration rate) should be taken before any drug administration. Patients should be informed not to use tobacco or caffeine at least 30 minutes before their appointment.

Did you know?

According to animal studies, the typical American diet is damaging to the liver and may result in allergies, low energy, digestive problems, and a lack of ability to detoxify harmful substances.

Did you know?

The calories found in one piece of cherry cheesecake could light a 60-watt light bulb for 1.5 hours.

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

For a complete list of videos, visit our video library