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).
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.