Author Question: You are trying to assess the performance of your North American branches. The performance measure is ... (Read 59 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?

The average office desk has 400 times more bacteria on it than a toilet.

Did you know?

Multiple sclerosis is a condition wherein the body's nervous system is weakened by an autoimmune reaction that attacks the myelin sheaths of neurons.

Did you know?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

Did you know?

Individuals are never “cured” of addictions. Instead, they learn how to manage their disease to lead healthy, balanced lives.

Did you know?

Automated pill dispensing systems have alarms to alert patients when the correct dosing time has arrived. Most systems work with many varieties of medications, so patients who are taking a variety of drugs can still be in control of their dose regimen.

For a complete list of videos, visit our video library