how to get started

[scottsoo9]

Question on where to start


Let me start off by saying I am very new to Access. I have only read a tutorial on the program, so my knowledge is limited.

I have an Excel spreadsheet filled with the following data which i would use as my fields

task number (primary key)
delivery order
description
customer
group
start date
end date
% complete
% of funds expended
dollars authorized
dollars expended
backlog
remarks
contract type
amount invoiced
amount paid
expended bill
authorized bill
bill paid

The rows that fill this information is the individual task number for each contract. There are about 100 contracts in total with many subtasks for each contract.

I was going to put the task number as the primary key.

My question is do I put all of this information in one table or do I split it up and put it in different tables. Any help on how to get this started would be greatly appreciated.

Thanks, Scott

[RuralGuy]

That's a pretty tall request Scott. You have a learning curve to cross. I'm going to suggest trying to find a template either on-line or one of the ones that ship with Access and modifying that. Also Google Normalization and read up as much as you can. Access is *nothing* like Excel.