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 customer order query.

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

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

3. Run the query and print the result.

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

FIGURE 3.17

Customer Order Query in MS Access

Compare the query with the query in Figure 3.16. What differences do you see?

FIGURE 3.16

SQL Programming Code in MS Access

SQL Data base Queries

After building a database query with Query by Example, developers can view the SQL programming code for the database query as shown. Developers can edit and modify the SQL code as needed. Each SQL statement contains action(s), table(s), field(s), and criteria.