Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Data Normalization

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Data Normalization

Resolved · Low Priority · Version Standard

Reply Tue 12 Feb 2008, 09:53Delegate Christie said...

Christie has attended:
Access Intermediate course

Data Normalization

Does it make sense to have a table of first names and last names to be used as a look up in a contacts table? The DB is for a school where there are many siblings yet the person who enters the data often makes mistakes. Thanks! Christie

For upcoming training course dates see: Pricing & availability

Reply Tue 12 Feb 2008, 16:13Trainer David said...

RE: Data Normalization

Christie,

I would say that it does not make sense. I would just have one table called Students that stores details such as name, address, DOB etc. It is not normal to separate this information. The normalization process is only to stop data being duplicated not to create as many tables as possible.

Hope this helps
David

Access articles

· It's so easy to Access the information you need
· Why Do I Need To Use Access?
· Convert a Paper Trail to a DBMS
· Learn The Secrets Of Customising An Autonumber Primary Key In Access
· A Quick Intro On How Access Uses SQL

Please browse our web site to find out more about
microsoft access training and other Microsoft training courses.

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