98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » access database microsoft training - Normalisation
access database microsoft training - Normalisation
Resolved · Low Priority · Version Standard
Mon 8 Oct 2007, 15:13Delegate Paul said...
Paul has attended:
Access Intermediate course
Access Advanced course
Normalisation
Hi All
is having a table with
order ref (PK, Autonumber)
order number
part number
qty due
date due
date sent
in third normal form?
cheers
Paul
Mon 8 Oct 2007, 15:39Trainer Carlos said...
RE: normalisation
Hi Paul
Yes. The table is in Third normal form.
A table is in Third normal form, if it is a table with a single primary key where ALL the fields relate to the primary key.
In your table you seem to have 2 order identifiers:
Order ref as a Autonumber seems to be the Primary key and a Order Number.
Carlos
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Pop up propertyIf you want to focus the attention of a form / switchboard to a user then you can change the propeties of a form/switchboard for Pop up to On. |
