In this exercise, you will learn how to create a query based on data that a user enters and how to use that query to create a data entry form. a. Download the Microsoft Access file Ch03Ex02_U9e.accdb . Open the file and familiarize yourself with the data in the Customer table. b. Click Create in the Access ribbon. Click the icon labeled Query Design . Select the Customer table as the basis for the query by double-clicking on Customer . Close the Show Table dialog. Drag CustomerName, CustomerEmail, DateOfLastRental, BikeLastRented, TotalNumberOfRentals, and TotalRentalRevenue into the columns of the query results pane (the table at the bottom of the query design window). c. In the CustomerName column, in the row labeled Criteria, place the following text: [Enter Name of Customer:] Type this exactly as shown, including the square brackets. This notation tells Access to ask you for a customer name to query. d. In the ribbon, click the red exclamation mark labeled Run . Access will display a dialog box with the text “Enter Name of Customer:” (the text you entered in the query Criteria row). Enter the value Maple, Rex and click OK. e. Save your query with the name Parameter Query . f. Click the Home tab on the ribbon and click the Design View (upper left-hand button on the Home ribbon). Replace the text in the Criteria column of the CustomerName column with the following text. Type it exactly as shown: Like “*”&[Enter part of Customer Name to search by:] &“*” g. Run the query by clicking Run on the ribbon. Enter Maple when prompted Enter part of Customer Name to search by . Notice that the two customers who have the name Maple are displayed. If you have any problems, ensure that you have typed the phrase above exactly as shown into the Criteria row of the CustomerName column of your query. h. Save your query again under the name Parameter Query . Close the query window i. Click Create on the Access ribbon. Under the Forms group, choose Form Wizard . In the dialog that opens, in the Tables/Queries box, click the down arrow. Select Query: Parameter Query . Click the double chevron << symbol and all of the columns in the query will move to the Selected Fields area. j. Click Next two times. In the box under What title do you want for your form ? enter Customer Query Form and click Finish . k. Enter Maple in the dialog box that appears. Access will open a form with the values for Maple, Rex. At the bottom of the form, click the right-facing arrow and the data for the second customer named Maple will appear. What is that customer’s first name? will appear. l. Close the form. Select Object Type and Forms in the Access Navigation Pane. Double-click the Customer Query Form and enter the value Amanda . Access will display data for all three customers having the value Amanda in their name.

EBK USING MIS

10th Edition

ISBN: 8220103633642

Author: KROENKE

Publisher: YUZU

See similar textbooks

Concept explainers

SQL Query

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed …

Videos

Textbook Question

Chapter AE, Problem AE3.2

In this exercise, you will learn how to create a query based on data that a user enters and how to use that query to create a data entry form.

a. Download the Microsoft Access file Ch03Ex02_U9e.accdb. Open the file and familiarize yourself with the data in the Customer table.
b. Click Create in the Access ribbon. Click the icon labeled Query Design. Select the Customer table as the basis for the query by double-clicking on Customer. Close the Show Table dialog. Drag CustomerName, CustomerEmail, DateOfLastRental, BikeLastRented, TotalNumberOfRentals, and TotalRentalRevenue into the columns of the query results pane (the table at the bottom of the query design window).
c. In the CustomerName column, in the row labeled Criteria, place the following text: [Enter Name of Customer:] Type this exactly as shown, including the square brackets. This notation tells Access to ask you for a customer name to query.
d. In the ribbon, click the red exclamation mark labeled Run. Access will display a dialog box with the text “Enter Name of Customer:” (the text you entered in the query Criteria row). Enter the value Maple, Rex and click OK.
e. Save your query with the name Parameter Query.
f. Click the Home tab on the ribbon and click the Design View (upper left-hand button on the Home ribbon). Replace the text in the Criteria column of the CustomerName column with the following text. Type it exactly as shown: Like “*”&[Enter part of Customer Name to search by:] &“*”
g. Run the query by clicking Run on the ribbon. Enter Maple when prompted Enter part of Customer Name to search by. Notice that the two customers who have the name Maple are displayed. If you have any problems, ensure that you have typed the phrase above exactly as shown into the Criteria row of the CustomerName column of your query.
h. Save your query again under the name Parameter Query. Close the query window
i. Click Create on the Access ribbon. Under the Forms group, choose Form Wizard. In the dialog that opens, in the Tables/Queries box, click the down arrow. Select Query: Parameter Query. Click the double chevron << symbol and all of the columns in the query will move to the Selected Fields area.
j. Click Next two times. In the box under What title do you want for your form? enter Customer Query Form and click Finish.
k. Enter Maple in the dialog box that appears. Access will open a form with the values for Maple, Rex. At the bottom of the form, click the right-facing arrow and the data for the second customer named Maple will appear. What is that customer’s first name? will appear.
l. Close the form. Select Object Type and Forms in the Access Navigation Pane. Double-click the Customer Query Form and enter the value Amanda. Access will display data for all three customers having the value Amanda in their name.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter AE, Problem AE3.1

Chapter AE, Problem AE4.1

Students have asked these similar questions

This battle room is focused on entry level tasks for a network analyst where you will be given trials and reconnaissance, sensor tuning, log aggregation, SIEM queries, and network analysis. For this week’s project, complete the following tasks: From your Project Ares portal, LOG IN Click on LAUNCH GAME. Select the region NORTH AMERICA Click on Battle School Under the BATTLE SCHOOL pop-up window, click on START TRAINING. Under the BATTLE ROOMS tile, click on ENTER. Under the NETWORK ANALYST tile, click on PLAY. Wait for the Battle Room to load. While loading, the BATTLE ROOM button will display red. Once the Battle Room is loaded, the BATTLE ROOM button will turn yellow and the center of the disk display will indicate CONNECTED. Click on the BATTLE ROOM button to enter the Battle Room. Below the TASKS folder, make sure you click on INSTRUCTIONS to download the Network Analyst Fundamentals material. In the Battle Room, under the TASKS menu select task INTRUSION DETECTION. Complete…

Create a relationship between the common field (Technician Number) of the two tables. Make sure that each client must have 1 and only 1 technician assigned, and each technician can have multiple clients. 2. Create a query to show the Client Number, Client Name, Billed, Paid for clients in Anderson city. Save the query. 3. Create a query to show the Technician Number, Last Name, First Name, YTD Earnings for technicians whose Hourly Rate is greater than or equal to 30. Save the query. 4. Create a query to show Client Number, Client Name, Billed, Paid for clients whose technician number is 22 and whose Billed is over 300. Save the query. 5. Create a query to show the Technician Number, Last Name, First Name, Client Number, Client Name for clients whose technician number 23. Save the query. 6. Create a query to show the Technician Number, Last Name, First Name, Client Number, Client Name for clients whose technician number 23 or 29. Save the query Help please Microsoft office access

Dijkstra's Algorithm (part 1). Consider the network shown below, and Dijkstra’s link-state algorithm. Here, we are interested in computing the least cost path from node E (note: the start node here is E) to all other nodes using Dijkstra's algorithm. Using the algorithm statement used in the textbook and its visual representation, complete the "Step 0" row in the table below showing the link state algorithm’s execution by matching the table entries (i), (ii), (iii), and (iv) with their values. Write down your final [correct] answer, as you‘ll need it for the next question.

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Solution Summary: The author demonstrates how to create a customer table by double-clicking on it in the Access ribbon.

Concept explainers

Videos

Want to see the full answer?

Chapter AE Solutions