Access 2000 – Mental Block

This may sound like an Access 101 question but here goes:

I want to design a DB that can do the following:

1) Import data from an external source.

2) parse the data and send each record to a different table (e.g. record 1 goes to TABLE1,record 2 goes to TABLE2, …)

3) in TABLEn, I want 3 fields that receive data from the insert, and other fields to be populated by formulas (based on input in the new record and other records already in TABLEn).

4) I want to generate charts.

I’ve designed the DB several times and each time it doesn’t do what I want it to do. I’ve gotten steps 1 and 4 to work, but I’m mystified on how to accomplish steps 2 and 3.

Any pointers would be greatly appreciated.