Making spreadsheets work in MS Access

[Uncle Gizmo]

I have noticed that some of the problems people experience in constructing a database are caused because they have not normalized their data.

Partly as an experiment to test some new software I found, I have constructed this presentation "Making spreadsheets work in MS Access" which goes some way to explain the reason you should seriously consider normalizing your data.

I have also posted it in the frequently asked questions section, and I have posted it here so that you can ask me any questions, and point out any mistakes I may have made!

Cheers Tony

 

[llkhoutx]

No only should data be normalized, but tables should also have indexed primary keys (whether one or more fields) and carelfully created relationships.

Query, forms and reports are significantly easier with normalized index tables.

Spending a significant amount of time normalizing will significantly reduce code time.

 

[The_Doc_Man]

Nicklaus Wirth, the "father" of the Pascal language, is often quoted regarding the source of errors in programming. Paraphrasing, he said that 80% of all programming errors originate from poor data design. 'nuff said.