HELP!!!!! PLEASE!!!!

[PS]

I am trying to create an Access table from an Excel Spreadsheet that has more
than one tab (I guess you would call it a workbook). The Spread sheet is set
up that all the tabs connects to This one form called Central. For example:

I have 7 branches within the Central Region the Central region has all the
information, from all branches summarized on the one of the tabs called
Central in order for me to create a table would I have to create a Table for
each individual branch? Also the Workbook has a rolling 12 month total. Can
you tell me how I would set this up as a report in Access? Please any help
would be helpful!!!!

PS

 

[BruceM]

Access is a relational database, and as such works very differently from the
way a spreadsheet does. If there is more than one region you would need a
Regions table. Some regions have more than one branch, so you would create
not a table for each branch, but rather a Branches table for all branches.
Branches are related to regions, so you will need to set up that
relationship so that each region can have more than one brance. There is a
lot of new stuff in Access if your experience has been with spreadsheets.
It may help if you remember that each Access table stores information about
one entity: Region, Branch, Employee, etc.
It will help if you describe the real-world situation that is behind the
project. I don't know what to make of "The Spread sheet is set up that all
the tabs connects to This one form called Central". I doubt I am alone in
being puzzled.
For starters, describe the hierarchy of the company (regions, branches,
etc.), and state what information you wish to produce on reports.

 

[PS]

Ok, sorry I was not clearer, here we go:
I have an Excel Spreadsheet with 9 worksheets within one workbook.For the
Central region I have 8 branches under that Region. Now within the Central
Spreadsheet there is also aWorksheet itself called Central and it gathers all
of the accidents that have been entered from each region and tally those
numbers so that if someone wants to find out the accidents for just the
Centra Region , then can go to this sheet instead of going through each
branch and counting. I am trying to create a database that will allow me to
do as I am in Excel (Enter in the information) and the formula automatically
gives the total for 12 months for example: If I wanted to see the Accidents
that occurred in Jan-05 and compare them to Jan -06 for the Central Region,
This is what my company refer to as a rolling total it would give me this
information. Or say if I wanted to see this same information just for a
particular branch. I hope this makes since.

Thanks for the Branch Table Idea

 

[mnature]

If Excel is working for you, you might consider staying with it.
Transferring your data to a relational database is not a trivial exercise.
You will need to normalize your data, set up appropriate tables, create
relationships. All of this is before you even enter data into the database.
Then you will create queries, forms and reports that will allow you to enter
and see your data in a convenient way. Your data will not look anything like
Excel, except in how you structure your forms and reports.

First of all, you need to study your data, and see how to normalize it.
Bruce gave you some ideas, already.