Normal form

Resolved · Low Priority · Version 2003

Tue 27 May 2008, 16:16 Delegate Anna said...

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

Normal form

what is first normal form?

Thu 12 Jun 2008, 10:01 Trainer Carlos said...

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

	98.7 % recommend us
	More live stats...

Training information:

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