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

normal form

ResolvedVersion 2003

Anna has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Normal form

what is first normal form?

RE: normal form

Hi Anna

A table is in First Normal Form if:

1. It has no duplicate records (ie It has a Primary Key)

2. Fiels are broken down (A field Name is divided into 2 fileds containing First Name and Last Name)

3. You must not duplicate data within the same row of a table

Hope this hepls

Carlos

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

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.