(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