Chapter AE, Problem AE5.2

Program Plan Intro

a.

Double click on the file downloaded and click on the create menu and click on the “Query design” to implement the queries that are given below:

• On clicking the query design, a Show Table dialog box appear click on the required table and click on the “Add” button and the table piano will be added in to process the query and it can be made as show below:

Screenshot of adding table

• After adding click the “Close” button.

Program Plan Intro

b.

Double click on the file downloaded and click on the create menu and click on the “Query design” to implement the queries that are given below:

• On clicking the query design, a Show Table dialog box appear click on the required table and click on the “Add” button and the table piano will be added in to process the query and it can be made as show below:

Screenshot of adding table

• After adding click the “Close” button.

Program Plan Intro

c.

Double click on the file downloaded and click on the create menu and click on the “Query design” to implement the queries that are given below:

• On clicking the query design, a Show Table dialog box appear click on the required table and click on the “Add” button and the table piano will be added in to process the query and it can be made as show below:

Screenshot of adding table

• After adding click the “Close” button.

Program Plan Intro

d.

Double click on the file downloaded and click on the create menu and click on the “Query design” to implement the queries that are given below:

• On clicking the query design, a Show Table dialog box appear click on the required table and click on the “Add” button and the table piano will be added in to process the query and it can be made as show below:

Screenshot of adding table

• After adding click the “Close” button.

Program Plan Intro

e.

Double click on the file downloaded and click on the create menu and click on the “Query design” to implement the queries that are given below:

• On clicking the query design, a Show Table dialog box appear click on the required table and click on the “Add” button and the table piano will be added in to process the query and it can be made as show below:

Screenshot of adding table

• After adding click the “Close” button.

Program Plan Intro

f.

Double click on the file downloaded and click on the create menu and click on the “Query design” to implement the queries that are given below:

• On clicking the query design, a Show Table dialog box appear click on the required table and click on the “Add” button and the table piano will be added in to process the query and it can be made as show below:

Screenshot of adding table

• After adding click the “Close” button.