normal form

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Normal form

Normal form

resolvedResolved · Low Priority · Version 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:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips


Server loaded in 0.09 secs.