Reflecting on this Chapter

Access is a multifaceted interface designed for both developers and users. Nowhere is that more apparent than in the toolbars and menus part of the user interface. Like other parts of the Access environment, this flexibility means that there are a lot of holes to plug to protect your database. This chapter should have provided you with the skill and knowledge to help you in that regard by discussing these relevant issues:

• How to build custom toolbars, menus, and shortcut menus.

• How to add VBA code to the custom toolbars.

• How to use VBA to change the relevant properties in your forms so that they use your custom toolbars and shortcut menus.

• What the toolbar related startup options are, how they work, and how custom menus are an important part of that mechanism.

• How to disable developer-specific toolbar commands on end-user computers.

Of course, this seems like a lot of material, but I can assure you that though toolbars and menus seem a little tricky at first, they really are quite easy to set up. As a first step, you should ensure that the developer-specific commands are not available to the end user, because this precaution will better protect your database and make it easier for your users.