Database Reference
In-Depth Information
TIP
To remove the Unassigned Objects group from the Navigation pane, display the
Navigation Options dialog box, click Garden Company, clear the Unassigned Objects
check box, and then click OK.
12
Test the new shortcuts by opening each form and report.
CLEAN UP
Keep the GardenCompany11 database open for use in the last exercise.
Controlling which features are available
If your database will be used by people with little or no experience with Access, you might
want to control which features are available when a database opens. You can control the
user environment by setting startup options for the database. For example, you can use
startup options to control whether ribbon tabs and the Navigation pane are available,
whether a specified object (such as a navigation form) is displayed on startup, and other
features.
TIP
Additional control can be achieved by the use of macros and Microsoft Visual Basic for
Applications (VBA) procedures. These topics are beyond the scope of this topic. For infor-
mation, search for
Introduction to Access Programming
on the Office website.
In this exercise, you'll set startup options that create a version of the database that is appro-
priate for inexperienced users. You'll give the database the appearance of being a custom
application, display the Home Page form when the database is opened, and hide program
elements that users don't need. Then you'll find out how to bypass the startup options.
SET UP
You need the GardenCompany11 database you worked with in the preceding
exercise and the Icon image located in the Chapter11 practice file folder to complete this
exercise. If necessary, open the database, and then follow the steps.
11
1
Display the
Backstage
view, and click
Options
to open the
Access Options
dialog
box. Then in the left pane, click
Current Database
to display that page.
