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

Data Normalization

ResolvedVersion Standard

Tue 12 Feb 2008, 09:53 Delegate 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

Tue 12 Feb 2008, 16:13 Trainer 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

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips

Data Normalization

Data Normalization

RE: Data Normalization

Access articles

Access tip:

Using the Quick Access Toolbar in Access 2010