ACCT 431 To find sales revenue collected for food items

Description

ACCT 431 To find sales revenue collected for food items

To find sales revenue collected for food items by store by day requires which tables?

Question options:

CustomerBill

CustomerBill, CustomerPayment

CustomerBill, CustomerBillItem, CustomerPayment

CustomerBill, CustomerBillItem, CustomerPayment, FoodItem

2. The best expression for at attribute representing the week that food is received so it can be matched with food already in inventory is:

Question options:

recWeek: Format(DateAdd(“d”,-2,[ReceivedTimestamp]),”yymmdd”)

recWeek: Format(DateAdd(“ww”,-2,[ReceivedTimestamp]),”yymmdd”)

recWeek: DateAdd(“d”,-2,(Format([ReceivedTimestamp],”yymmdd”)))

recWeek2: DateAdd(“ww”,-2,(Format([ReceivedTimestamp],”yymmdd”)))