Create a menu of forms (Switchboard) for the forms shown in Review Exercises 6.2 and 6.4. Note: only one switchboard can be active in a database. You must make this your Default switchboard to activate it.

Review Exercise 6.2

The figure that follows shows a single table form for the MATERIAL table, which is in the Material_Manager_CH6_stu database. It is used to maintain the table (i.e., to add new material descriptions and to delete obsolete materials).

(a) Implement this single table form in Access as shown.

(b) Add function buttons as in Access Exercise 6.2.

Review Exercise 6.4

Review Exercise 6.4

Shown here is a master/detail form based on the following tables: MATERIAL, VENDOR, and VENDOR_MATL_XREF. The form is used to view the vendor material IDs in the cross-reference table associated with each material of the enterprise. It is also used to add new materials and their cross reference with vendor materials.

(a) Implement this form in Access without command button functions.

(b) Add command buttons for the insert, delete, and save functions.