Author Question: You are trying to assess the performance of your North American branches. The performance measure is ... (Read 19 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 eye muscles are the most active muscles in the whole body. The external muscles that move the eyes are the strongest muscles in the human body for the job they have to do. They are 100 times more powerful than they need to be.

Did you know?

The term bacteria was devised in the 19th century by German biologist Ferdinand Cohn. He based it on the Greek word "bakterion" meaning a small rod or staff. Cohn is considered to be the father of modern bacteriology.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

About one in five American adults and teenagers have had a genital herpes infection—and most of them don't know it. People with genital herpes have at least twice the risk of becoming infected with HIV if exposed to it than those people who do not have genital herpes.

Did you know?

More than 30% of American adults, and about 12% of children utilize health care approaches that were developed outside of conventional medicine.

For a complete list of videos, visit our video library