Microsoft Office Tutorials and References
In Depth Information
Validation Rules AC 169
To Save the Validation Rules, Default Values, and Formats
The following steps save the validation rules, default values, and formats.
Click the Save button
on the Quick Access
Toolbar to save
the changes
(Figure 3–38).
Save button
Click the No button
to save the changes
without testing
current data.
Microsoft Offi ce
Access dialog box
message about
data integrity rules
Close the
Client table.
Should I always
click the No button
when saving
validation rules?
If this were a
database used to run
a business or to solve
some other critical
need, you would
click Yes. You would
want to be sure that
the data already in
the database does
not violate the rules.
message about
the process
No button
Figure 3–38
Updating a Table that Contains Validation Rules
When updating a table that contains validation rules, Access provides assistance
in making sure the data entered is valid. It helps in making sure that data is formatted
correctly. Access also will not accept invalid data. Entering a number that is out of the
required range, for example, or entering a value that is not one of the possible choices,
will produce an error message in the form of a dialog box. The database will not be
updated until the error is corrected.
Changing Data Types
It is possible to change
the data type for a fi eld
that already contains
data. Before you change
a data type, however,
you should consider
what effect the change
will have on other
database objects, such
as forms, queries, and
reports. For example,
you could convert a Text
fi eld to a Memo fi eld
if you fi nd that you do
not have enough space
to store the data that
you need. You also could
convert a Number fi eld
to a Currency fi eld or
vice versa.
Search JabSto ::

Custom Search