Overview You now have all the parts of your database working correctly, including Tables, Forms, Queries, Reports. You have used Commands, Controls and Look-up Fields to make your database easier to u

Overview

You now have all the parts of your database working correctly, including Tables, Forms, Queries, Reports. You have used Commands, Controls and Look-up Fields to make your database easier to use. In this Module, you will be adding the finishing touches to your database!

Objectives

1. Create and modify macros, sub macros, and a menu form with command buttons and with an option group
2. Create datasheet forms, user interface macros, navigation forms, data macros, and control layouts
3. Create custom categories and groups in the Navigation Pane
4. Encrypt a database and set password, lock and split a database.

Instructions

The final and finishing touch to your database will be Navigation Forms and of course, Security! The requirements of this assignment include:

1. Create a set of Navigation Forms, using Command Buttons to make your database easy to navigate. You may need to draw this, much like you did your database design, to decide how you want the Navigation system to work. It needs to include the following techniques:
2. Create and/or modify Macro(s)
3. Create Navigation Form, including Command Buttons, and User Interface Macros
4. Create Custom Categories and Groups in the Navigation Pane of the Database
5. Encrypt the database and set password.
6. Lock the Database
7. Write a summary of the changes you made to the database, including providing the password for the database. In your summary, include reasoning or justification for each of the changes you made.