Chapter AE, Problem AE3.2

Explanation of Solution

a.

 Double click on the file “Ch03Ex02_U10e.accdb” that is downloaded. The file will contain one table namely “customer”.

• Double click on the table “customer&...

Explanation of Solution

b.

Click “Create” in Access ribbon. Then, select the labeled named “Query Design”.

• Select the customer table by double-clicking on “Customer” table.
• Show table dialog box will appear as shown below:

Screenshot of Show Table

• Click “Close”.
• After clicking the “Close” button, the “Query1” is displayed as shown below.

Screenshot of Customer for query

Explanation of Solution

c.

In the row labeled Criteria, write the following text:

“[Enter Name of Customer:]”

S...

Explanation of Solution

d.

In the ribbon, click the red exclamation mark “Run”. It displays a dialog box as shown below.

Screenshot of Query Tools

• Enter “Maple, Rex” in the dialog box.

Screenshot of Query Tools

Explanation of Solution

e.

Save the query name as “Parameter Query”.

Screenshot of Parameter Query

Explanation of Solution

f.

Click on the “Home” tab and click “Design View”.

• Replace the text in the Criteria column of the “CustomerName” by the following text.

Like “*”...

Explanation of Solution

g.

Click the “Run” on the ribbon. A dialog box will appear as shown below. Enter the name “Maple” in the dialog box. Then click “OK”.

Screenshot of Customer Table

Explanation of Solution

h.

Save the query as “Parameter Query”. Then close the query window. The form looks like the screenshot given below...

Explanation of Solution

i.

Click create on the Access ribbon. Select “Form Wizard” under Forms group. A dialog box appears as shown below.

Screenshot of Form Wizard

• Click down arrow in the “Tables/Queries” box. Then select “Parameter Query”.

Screenshot of Form Wizard

• Click the “>>” symbol in the “Form Wizard”...

Explanation of Solution

j.

After clicking “Next” button the Form Wizard appears as shown below:

Screenshot of Form Wizard

Explanation of Solution

k.

After clicking “Finish” the dialog box appears as shown below.

Screenshot of Enter Parameter Value

• Enter “Maple” in the text field. The values for “Maple, Rex” is shown.

Screenshot of Customer Query

Explanation of Solution

l.

Close the form. Select “Object Type and Forms” in the Navigation Pane. Double click “Customer Query” and enter the value “Amanda”. Then click “OK”.

Screenshot of Enter Parameter Value

• The values for “Ashley, Amanda” is shown.

Screenshot of Customer Query