Question: A table contains a field named Region ( Character ) and another named Invoice _ Amount ( Numeric ) . How would you create a

A table contains a field named Region (Character) and another named Invoice_Amount (Numeric). How would you create a new table that contains all of the transactions in Regions AOl and A02 where the Invoice_Amount exceeds $5,000? Select all that apply.
A. Create a View filter using the syntax Region = "AOl" AND Region ="A02" AND Invoice_Amount >5000. Then Extract to a new table.
B. Run the Extract command with a command filter using the syntax MATCH(Region "AOl" AND "A02") AND Invoice_Amount >5000.
C. Create a View filter using the syntax (Region = "AOl" OR Region ="A02") AND Invoice_Amount >5000. Then Extract to a new table.
D. Run the Extract command with a command filter using the syntax (Region = "AOl" OR Region ="A02") AND Invoice_Amount >5000.
E. Run the Extract command with a command filter using the syntax MATCH(Region, "AOl", "A02") AND Invoice_Amount >5000.00.}

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 Databases Questions!