From your description, you have ... a spreadsheet!

While you are pretty much limited to "adding columns" to add fields when you
work with a spreadsheet, Access is a relational database. You won't get
easy use of Access' relationally-oriented features/functions if you feed it
'sheet data.

If the terms "normalization" and "relational database" don't make much
sense, spend some time studying up on them before trying to design an Access
database.

Is there a reason you can't just use a spreadsheet?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Mykas_Robi" wrote in message
...
I have a table that consists of the following fields
name, number, effect date, term date, date posted1, item1, debit1,
credit1...date posted13, item13, debit13, credit13. I submitted a
question
on query design and was informed that my table is poorly designed.

I need to know what to break this table up that so that it is designed
properly. Please any assistance would be greatly appreciated.

Thanks and have a nice day.