starting a DB from excel spreadsheet, lots of calculations

[mike02]

Hey,

Im starting to build a Database to keep track of managing clients. I have setup a spread sheet that works well, the issue is that it takes to long to add a new client, and the data isnt in the most appealing way. I am hoping to set it up, to allow forms and reports to display information. my biggest road block is how to start since A lot of the columns are calculated. from my experience, and research you want to stay away from calculated fields. So I was planning on using queries to do this. No I have attach a sample spread sheet, With some of my notes, I am stuck on how to construct tables from this. Obviously We need a clients table, but from there im stuck.Attachment 12649

[RuralGuy]

Have you reviewed the templates that come with Access and those on line to see if there is something close to what you need that you can modify?

[mike02]

yes I have, the templates I have viewed in access do not suit my needs. I have set up my clients table up like Northwind templates customers