What are some business rules for databse design in Access?

[Guest]

I am researching database design business rules. I would like responses or
examples of these business rules or data integrity constraints for Access
databases.

 

[tina]

the *business* rules that are supported/enforced in an Access database are
specific to the company for which the database is being developed, or
sometimes the broader rules that apply to a specific type of business or
industry (like some banking rules, for instance).

are you, instead, asking about the principles of data modeling, which are
the "rules" used to define a business process and develop a relational data
structure to support the process?

hth

 

[Guest]

Tina

I understand business rules by definition. I am looking for translation by
examples. Thanks for responding.

 

[Allen Browne]

The business rule for a Birthdate field might be:
<= Date()
so you cannot people who are not yet born.

For an event table, you might enter a rule on the table of:
[EndDate] >= [StartDate]
so the event cannot end before it begins.

For an invoice, the rule of a TaxRate field might be:
Between 0 And 0.40
to prevent negative taxes or excessive taxes.

It could also be for ensuring the quantity ordered is not less than
something the bean counters want, e.g.:
[Quantity] >= 10

The table rule can get more complex. For example if you have a yes/no field
named IsCorporate, and you want to ensure that a FirstName is entered for
non-corporate customers:
([IsCorporate]) OR ([Firstname] Is Not Null)

Is that a suitable sample of rules?

 

[John Vinson]

For an invoice, the rule of a TaxRate field might be:
Between 0 And 0.40
to prevent negative taxes

Well, negative taxes would be great. Now we just need to get them
through the legislature...!

John W. Vinson[MVP]

 

[Guest]

A common one that I use is conditional formatting of a date field in a form,
that flags an entry that is outside of my set parameters. I usually do this
by having the background turn red, and the text become bold. There are
several types of constraints that I commonly work with: Dates cannot be in
the future, or dates must be within a window calculated from the current date.

 

[Tim Ferguson]

Well, negative taxes would be great. Now we just need to get them
through the legislature...!

UK has had a tax credit system for some years. Only trouble with it is the
computers that run it...

Tim F