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

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.08 secs.