should i normalize this?

[yepwingtim]

http://img528.imageshack.us/my.php?image=normalnp9.jpg

any advice thanks
im talking about the rf1 rf2 rf3 lf 1....
when i print all of this info needs to be shown also
________
PLYMOUTH BELVEDERE

 

[georgedwilkinson]

In short, if you are doing transactional work in your database, yes, you should normalize it.

If the only thing you're doing with the data is reporting, you may need to re-arrange it (star or snowflake schema) but you don't have to normalize, if you're not inserting new records/modifying old records.

 

[yepwingtim]

how would i normalize this though i have around 3000 entries of these...
can i use update query?
how do i do star and snowflakes
Thanks george
________
MAZDA MAZDAGO SPECIFICATIONS

 

[Pat Hartman]

In general, the process of loading normalized tables from a spreadsheet is to run an append query for each column that you need to turn into a row. If you are only going to do this once, you can create one query and modify it to pivot each column in turn. If you will need to do this more than once, create and store the queries. If there are too many queries, write VBA code that creates and runs them on the fly.

 

[georgedwilkinson]

Star & Snowflake schemas are only valid for incredibly large enterprise data warehouses. That you had to ask tells me you don't need them and that, yes, you should normalize.

Pat's answer should get you started.