Ja'nice launched an online jewelry business several months ago to sell her handmade jewelry. As her business expanded, Ja'nice developed product codes for her jewelry and a database to track orders, track supply orders, and maintain customer information. The tables and fields in her database are illustrated in the figure below.

-Ja'nice wants to create a query that will show her all orders placed on or after July 1, 2015. Which table does Ja'nice need to use for this query?
A) Customer Info
B) Product Info
C) Vendors
D) Order Info

Question

Ja'nice launched an online jewelry business several months ago to sell her handmade jewelry. As her business expanded, Ja'nice developed product codes for her jewelry and a database to track orders, track supply orders, and maintain customer information. The tables and fields in her database are illustrated in the figure below.
 
-Ja'nice wants to create a query that will show her all orders placed on or after July 1, 2015. Which table does Ja'nice need to use for this query?
A) Customer Info 
B) Product Info 
C) Vendors 
D) Order Info

Quizplus · Accepted Answer

Ja'nice needs to know which orders were placed on or after a specific date, so she needs to use the Order Info table. This table contains date and time information for each order, allowing her to filter the data based on specific dates. The other tables, such as Customer Info and Product Info, are important for other purposes but are not necessary for this particular query. The Vendors table is also not necessary for this query, as it does not contain information about specific orders or order dates.

Ja'nice Launched an Online Jewelry Business Several Months Ago to Sell