If you have a working knowledge of Visual Basic, you may wish to know how I implemented the SQL CREATE, INSERT, UPDATE and DELETE commands that are mentioned in section 10.

 

A simple form was created in Access with a number of Command Buttons on it. Each command button called the corresponding sub routine called via the on_click event.

 

Obviously the standard of the form and the usefulness of the code is not sufficiently robust or flexible to be of much practical use; the aim of the form and coding was simply to enable a table to be created, populated and updated using SQL commands.

 

The form in question is shown in Figure B-1.

 

Screen Shot of form. The form has 5 command buttons on it labled; "create a table (rooms)", "add room 1 to rooms", " add more data", "update record 5", "delete record 6".


Figure B-1: The form used to create and populate the table rooms