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 needs to determine which vendors provide the most options for floor mats that are compatible with the specific car model.To do this,he will apply a filter that is based on multiple selection criteria and that sorts the records that are selected by vendor name alphabetically.Which type of filter will Sheng apply to the datasheet?
A) Advanced Filter/Sort
B) AutoFilter
C) Filter by Form
D) Filter by Selection
Correct Answer:

Verified
Correct Answer:
Verified
Q39: The primary purpose of the _ is
Q40: Using Backstage View and Access Options,set the
Q41: Where is an Access database password stored?<br>A)in
Q42: The process of linking an outside data
Q43: The database created when using the Database
Q45: The <u>AutoNumber</u> data type allows the option
Q46: The protection of a database against intentional
Q47: Why is it a good idea to
Q48: Access versions prior to 2007 do not
Q49: Attachments associated with a field whose data