(a) Outline the steps involved in creating the Query By Example (QBE) in figure 1 assuming the table customer exist already.
Figure 1 (b) Write the steps to generate the SQL statement for the action in 4 (a).
Explanation
(a) Steps involved in creating the query in MS Access; - Click on Create - Select Query Design - Add table tbl Customer to QBE interface - Select the field Last Name from the grid - Select the field First Name from the grid. - Select the fields Town from the grid. - Type 'John' in the criteria row under the last Name field. - Tick all the check boxes in the show row under last Name, first Name and Town fields. (b) Steps to generate the SQL statement for the action in 4(a) - Right click on Query (QBE) Interface - Select SQL view OR - From Design view, click view - Select SQL view OR - Click on SQL at the bottom right corner
