Tech Tool: Database SoftwareSoftware Video: Database QueriesEspressoCoffee has asked for y...

Tech Tool: Database Software

Software Video: Database Queries

EspressoCoffee has asked for your assistance in creating a query to retrieve customer information.

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

2. Using Microsoft Access database software, create the query shown in Figure 3.15.

3. Run the query and print the result.

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

FIGURE 3.15

Building Database Queries Using MS AccessDatabase Queries

To build a database query, the developer can use a Query by Example (QBE) template as shown. The developer displays the tables involved in the query. From those tables, the developer selects the fields required by the query. Search criteria are specified (for example, Customer Last Name = “Pico” as shown).