Multiple Choice
Sheng has been asked to provide data from the Inventory database of a regional auto parts store to the store's regional manager.He has been given specific requirements to narrow the data based on the information the manager needs.Sheng will apply filters to the tables in the Inventory database to provide his manager with the requested information.
-Sheng also considers creating a second SQL SELECT statement within the query used to create the datasheet containing the filter he plans to save.If Sheng does this,he is creating a(n) ____.
A) outer query
B) subquery
C) parent query
D) filtered query
Correct Answer:

Verified
Correct Answer:
Verified
Q30: To display a multivalued field in expanded
Q31: In order to isolate a subset of
Q32: An Access database created using Access 2007
Q33: A second query included in a SQL
Q34: The database created when using the Database
Q36: Table design for tables in a split
Q37: Sheng has been asked to provide data
Q38: The objects in a front-end database use
Q39: The primary purpose of the _ is
Q40: Using Backstage View and Access Options,set the