ASSIGNMENT #4 (RELATED TO ACCESS DATABASE)

After successfully completing this assignment, you will be able to:

Develop a process typically used in Master Table Maintenance

Control the enabling/disabling of tasks available to the user

Use VBA commands to manipulate database records

include simple validation rules at the field and table levels

Users will be allowed to browse through the records in a table (in Description order) with no chance of the data being accidentally damaged.

If the user finds a record that requires editing (changing), the Edit button will be pressed, and the state of the form will be changed to allow editing. When the user is finished editing the data, either the Save or Cancel button will be pressed to save/ignore the changes and return the form to the browse mode.

If the user decides to add a record to the table, the Add button is pressed, and the state of the form will be changed to allow a complete record to be added. As above, the user can select the Save or Cancel button.

The database AS4.mdb is supplied on Scratch, containing Parts and Vendor information.

Browse State:

When in the browse state, all data controls are locked, not allowing any modifications to the data.

Disable the Save and Cancel buttons and enable the Add, Edit and Exit buttons.

Notice the record navigation bar is visible, allowing the user to move through the table to select a part, but not allowing adds to the table.

Modify State:

When the user selects either Edit or Add place your form in Modify state. Disable the Add, Edit andExitbuttons; enable the Save and Cancel buttons; and hide the record navigation bar.

Save - If the data is valid (rules below), commit the record to the database and switch back tobrowsestate.

- If the data is not valid leave the form in the modify state. Users will then either correct the error(s) or cancel out of modify state.

Cancel - Discard any changes made to the data and switch back to browse state.

Exit - Close the form and return to Access.

Validation - The following validation is to be done by a VBA function:

Description must be at least 4 characters

OnHand and OnOrder must be 0 or greater

Cost must be greater than 0

ListPrice must be greater than Cost

- Ensure that meaningful error messages are provided for all errors.