3.44 Tech Tool: Database Software Software Video: Database Queries EspressoCoffee has asked for your assistance in creating a query to retrieve vendor information.

1. Download the Microsoft Access database file for this exercise.

2. Using Microsoft Access database software, create a query to retrieve information about vendors from the state of Texas. When your query is run, your results should appear as follows (see table below).

3. Run the query and print the result.

4. Select the SQL view. Copy and paste into Excel and print.

Vendors Living in Texas VENDOR NAME Compete, Inc. Light Speed Holiday Skate & Cycle STREET ADDRESS 11231 Main Street CITY STATE ZIP COUNTRY Austin TX 78737 USA 431 Golf View Dr. Houston TX 77053 USA 6 10th Street Dallas TX 75252 USA