Microsoft Office Tutorials and References
In Depth Information
Making a Main Menu for Your Database
Form controls that display data have properties with which you can validate
and format that data. In fact, they’re the very same properties that you can
set as part of your table design:
Default Value: The starting value for this field when you add a new
Input Mask: A pattern for field data to follow, including where letters,
numbers, and punctuation appear and how letters are capitalized
Validation Rule: A rule Access applies to values entered in this field
Validation Text: An error message you see if you try to enter data
that breaks the validation rule
These settings appear on the Data tab of the property sheet for controls. For
help with creating input masks and validation rules (which can be a little
complicated, frankly), click the setting on the property sheet and then click
the Build button to the right of the setting. For input masks, you see the
Input Mask Wizard, and for validation rules, you see the Expression Builder.
(For details about using these settings, see Book II, Chapter 5.)
Making a Main Menu for Your Database
As you set up your database, you end up with various forms and reports
that you (or the users for whom you’re creating the database) will use
regularly. The database would be easier to use with a main menu from which
these frequently used objects can be chosen. Older versions of Access used
switchboards to create menus from which you could open forms and reports.
Navigation forms replace switchboards, although switchboards in databases
created in earlier versions of Access continue to work.
Creating a navigation form
A navigation form is a form that includes a navigation control that can
display one or more forms and reports. The navigation control has tabs —
which can appear down the left side of the form, along the top, or in other
places — that you can click to choose the form or report to display. Very nice!
Book IV
Chapter 3
You can create a navigation form by running a wizard or by making it with
your bare hands. Here are some suggestions for using both:
By wizard: Click the Navigation button in the Forms group on the Create
tab of the Ribbon. Choose one of the options that the button displays to
create a form with one or two levels of horizontal or vertical tabs (that
is, form-name tabs that run horizontally along the top of the form or
vertically down the left or right side of the form).
Search JabSto ::

Custom Search