Forum home » Delegate support and help forum » Microsoft Access Training and help » access database microsoft training - Normalisation

access database microsoft training - Normalisation

ResolvedVersion Standard

Mon 8 Oct 2007, 15:13 Delegate 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:39 Trainer 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

Mon 8 Oct 2007, 15:42 Delegate Paul said...

RE: normalisation

I have done this because I was told elsewhere that primary keys should ALWAYS be autonumber, even though my order number fields will be unique

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

access database microsoft training - Normalisation

Normalisation

RE: normalisation

RE: normalisation

Access articles

Access tip:

Choosing data types in Access