Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Tuesday, October 28, 2008 – Permalink –

Normalization Model

Excel Mock-up


Normalization, simplistically, is setting up tables of data so that information is entered only one time. Access is not as malleable as Excel, so for demonstration purposes, spreadsheet entries can be used to show the concept.

"This article explains how to use Microsoft Excel to create prototypes of your Access databases and how to make sure your data adheres to a set of rules called normal forms. Normal forms aren't hard to understand, and they're critical to designing useful databases."




Design Access databases with normal forms and Excel

Also see:

Database normalization Webcast

An Introduction to Database Normalization

Database normalization basics

Database Normalization Basics for Developers

Also see:

Tushar-Mehta.com:
Building and using a relational database in Excel


See all Topics

Labels: ,


<Doug Klippert@ 3:44 AM

Comments: Post a Comment