Microsoft Office Tutorials and References
In Depth Information
AC 166
Access Chapter 3 Maintaining a Database
To Specify a Required Field
To specify that a fi eld is to be required, change the value for the Required property from No to Yes. The
following steps specify that the Client Name fi eld is to be a required fi eld.
1
Show the Navigation pane, and
then open the Client table in
Design view.
Client table open
in Design view
Select the Client Name fi eld by
clicking its row selector.
Click the Required property box
in the Field Properties pane, and
then click the down arrow that
appears.
Row selector
for Client
Name fi eld
Client Name
fi eld selected
Click Yes in the list (Figure 3–33).
What is the effect of this change?
Users cannot leave the Client
Name fi eld blank when entering
or editing records.
Required property
box arrow
value changed
to Yes
Required
property box
Figure 3–33
To Specify a Range
The following step specifi es that entries in the Amount Paid fi eld must be between $0.00 and $100,000.00. To
indicate this range, the criterion specifi es that the amount paid value must be both >= 0 (greater than or equal to 0)
and <= 100000 (less than or equal to 100000).
1
Select the Amount Paid fi eld by
clicking its row selector, click the
Validation Rule property box to
produce an insertion point, and then
type >=0 and <=100000 as the rule.
Amount Paid
fi eld selected
Click the Validation Text
property box to produce an
insertion point, and then type
Must be at least $0.00 and
at most $100,000 as the text
(Figure 3–34).
Access automatically
converts and to And
validation rule
What is the effect of this change?
Users now will be prohibited from
entering an amount paid value
that either is less than $0.00 or greater
than $100,000.00 when they add records or change the value in the Amount Paid fi eld.
validation text
Figure 3–34
 
Search JabSto ::




Custom Search