Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello I am attaching pictures of the tables and the query that I need help solving in. Please solve it for me. 7 Database3 :

Hello I am attaching pictures of the tables and the query that I need help solving in. Please solve it for me.image text in transcribedimage text in transcribedimage text in transcribed

7 Database3 : Database - C:\Users amia OneDrive\Documents\Database3.accdb (Access 2007 - 2016 file format) Access Anisha ta Database Tools Help Table Fields Table Tell me what you want to do A Ascending 7 Selection Con New Totals Replace Calibri (Detail) v 11 Al Descending Advanced Save abc Spelling er - Go To Refresh Find 40 Remove Sort Y Toggle Filter All X Delete More Select BIU ARA Sort & Filter Records Find Text Formatting 3 X E Items s X ESL Orders X EF Order Line Item X Male Customer Query x Query1 X id - First Name Last Nam. Email Address Street Address City State - Zip Gender Credit Card. Click to Add . Ava Kerr ava.kerr@google.com 35A Cherry Orchard Denver CD 80201 F 122635211541 Victoria Bailey victoria.hannah@google.com 5 The Springs Denver 80201 F 254136597162 Hannah Mitchel hannah.mitchel@google.com 79 Rydal Ave Denver 80201 F 852462169841 Trevor Lee trevor.lee@google.com 101 Winchester Rd Denver CD 80201 M 952144520145 Phil Mackay phil.mackay@google.com 12 Hylton PI Denver 80201 M 951447520145 Abigail Russel abigail.russel@google.com 3 Ash CI 3 Denver 80201 F 857141058412 Keith Hill Keith.hill@google.com 25 Trewarton Rd Denver 80201 M 957410255412 Neil Underwood neil.underwood@google.com 111 Clarence Rd Denver 80201 M 944100547725 Sonia Wright sonia.wright@google.com 43 Emerson Ave Denver 80201 F 754512684524 Carl Jones carl.jones@google.com 10 Brynawelon Dr Denver 80201 M 954125874126 Barnadette Chapman barnadette.chapman@google 1 Central Circle Denver 80201 954711558742 0 0 0 8888eeeee Search Es Save V . Cut Y I Ascending 41 Ascending 7 Selection Dr. New Totals Sc Replace Calibri (Detail) Le Copy 11 Al Descending Advanced abc View Paste Go To Filter Spelling Refresh Find Format Painter 4 Remove Sort Y Toggle Filter All X Delete. More Select BIU A 2 Views Clipboard Sort & Filter Records Find Text Formatting Es Customers Items X All Access ... HD Orders x Order Line Item X Male Customer Query X Query1 X ID Item id Item Name Description Price Click to Add Search... Monthly? O 1 901 Single Cat Monthly Monthly box of cat toys and treats $19.99 Tables 2 902 Multiple Cats Monthly Monthly box of cat toys and treats for $35.99 EN Customers 3 903 Toy of the Month Monthly unique cat toys $9.99 Items 4 904 Treat of the Month Monthly mouth watering cat treats $4.59 5 905 Organic Litter Organic cat litter box Order Line Item $25.00 6 906 Cat Condo $219.99 6 foot tal cat condo with 3 platforms 28 Orders $18.99 7 907 Cat Bowls Multi coloured bowls with cat faces Queries $12.50 8 908 Cat Brush Two sided cat brush E Male Customer Query $5.99 9 909 Flea Comb Fine toothed flea comb for flea Forms (New) 0 Fel Orders 000000ROSS $0.00 Search 1 of 9 AoBook Assignment 2E: Creating a Parameter Query Create a parameter query that prompts for a keyword and then lists all the items whose descriptions hold that keyword. The query should include columns for Item Name, Description, and Price. (Hint: The parameter syntax for this query, including the wildcard, is Like "*" & (Enter your search term) & "s".) Save the query as Search for keywords. Your output should resemble Figure 1-8 after you enter "treat at the prompt. Price Search for keywords Item Name Description Single Cat Monthly Monthly box of cat toys and treats Multiple Cats Monthly Monthly box of cat toys and treats for multiple cats Tret of the month Monthly mouth watering cat treats $19.99 $35.99 $4.59 $0.00 FIGURE 1-8 Search for keywords query

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation And Management

Authors: Peter Rob, Carlos Coronel

6th International Edition

061921323X, 978-0619213237

More Books

Students also viewed these Databases questions

Question

mutual trust and teamwork;

Answered: 1 week ago