[AccessD] Mucking around

John Bartow john at winhaven.net
Fri Sep 28 13:53:38 CDT 2007


Use a normalized data structure. It is the flexible and efficient way of
entering/storing/maintaining data.

Creating a flat file derived from the data in a normalized data structure
can be as easy as creating a select query. Don't use flat file for data
storage. That would create redundancy, inefficiency and well, eventually a
mess.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
max.wanadoo at gmail.com

Q1: What do I  do with my normalised tables.  If the answer is to leave the
data in the normalised table and then re-post it to a flat table, then why
could that not have been done at data entry.
Q2: If the answer to Q1 is go straight to flat tables, then what do I do
AFTER that.






More information about the AccessD mailing list