3.45 Tech Tool: Database Software and Spreadsheet Software Software Video: Database Search STATE TX TX TX ZIP . COUNTRY .

78737 USA 77053 USA 75252 USA EspressoCoffee's management has asked your assistance in searching the vendor table. They wish to search this table in Microsoft Access as well as Excel.

1. Download the Microsoft Access and Microsoft Excel data files for this exercise.

2. Use the Microsoft Access query-by-example (QBE) to retrieve vendor information with name equal to "International."

3. Use the Microsoft Excel search tool to retrieve vendor information with name equal to

"International."

Notice that the search tool in Microsoft Excel is different than the Find tool. The Find tool shows only the search item, but the search tool shows the record (row) containing the search item.