Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

'ms access+course' - normalisation

Forum home » Delegate support and help forum » Microsoft Access Training and help » 'ms access+course' - Normalisation

'ms access+course' - Normalisation

ResolvedVersion Standard

Ian has attended:
Access Intermediate course
Access Advanced course

Normalisation

What is first normal form?

RE: Normalisation

The definition for first normal form (1NF) is:

Each column must contain only a single value and each row must contain the same columns.

In 1NF a table must be guaranteed not to have any duplicate records; therefore it must have at least one Primary key.

There must be no repeating groups. For example, suppose that an employee can have multiple skills: a possible representation of employees' skills is {Employee ID, Skill1, Skill2, Skill3 ...}, where {Employee ID} is the unique identifier for a record. This representation would not be in 1NF.

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.