*32.1 (Access and update a Staff table) Write a program that views, inserts, and updates staff information stored in a database, as shown in Figure 32.27a. The View button displays a record with a specified ID. The Insert button inserts a new record. The Update button updates the record for the specified ID. The Staff table is created as follows:

create table Staff ( id char(9) not null,

lastName varchar(15), firstName varchar(15), mi char(1),

address varchar(20), city varchar(20), state char(2), telephone char(10), email varchar(40), primary key (id)

);

 

 

 

 

(a)                                                                                                                                     (b)

FIGURE 32.27    (a) The program lets you view, insert, and update staff information. (b) The PieChart and BarChart

components display the query data obtained from the data module.