Project a new database

[John]

Hello to everybody.
I try to explain what I would like to do considering that I am fairly new to
the database
I have something like more 80 word files and I want to combine all files in
a better application like Access 03.
Each file (that represent a niche) has 5 column and 10 rows.
Within each cell there is a name and its birth/dead date.
How my I project the database to obtain the report with the same layout as
the table in Word with the name within each cells in the same position?
And build up also a form to search by name, birth date, dead date?
Is there any sample where I can study and learn something more?

Any suggestion is really appreciate. Thanks for all your time.
Kind reagards
John B

 

[John Vinson]

Hello to everybody.
I try to explain what I would like to do considering that I am fairly new to
the database
I have something like more 80 word files and I want to combine all files in
a better application like Access 03.
Each file (that represent a niche) has 5 column and 10 rows.
Within each cell there is a name and its birth/dead date.
How my I project the database to obtain the report with the same layout as
the table in Word with the name within each cells in the same position?
And build up also a form to search by name, birth date, dead date?
Is there any sample where I can study and learn something more?

Any suggestion is really appreciate. Thanks for all your time.
Kind reagards
John B

You will need to do some mental adjustment here.

Word is a word processor; it is designed to produce documents that
look on the screen as they will be printed (with words or graphs or
text laid out in a certain order).

Access does NOT produce documents, except as an end product. Instead
it's a relational database. You would come up with a *logical*
structure for your data (probably all as one table, based on your
sketchy description); in order to display or print the information
with the records in a certain order, you would need to include a field
(or fields) that can be sorted. For instance if you have FirstName,
LastName, BirthDate and DeathDate fields, you can create Queries to
sort the data by any one or any combination of these fields; the query
can also have criteria that let you select which records to see; you
can then base a Report on the query and see or print the data however
you like. Don't fall into the trap of designing your *table* based on
the final report - they are separate!

Importing the data from Word tables into Access tables is considerably
harder than you might expect (or like). It's often easiest to copy and
paste the data into Excel, since Access can import data directly from
Excel whereas it cannot do so from Word.

If you could explain a bit more about the nature of the data and how
you plan to use it we'll be glad to try to help design an efficient
database for you.

John W. Vinson[MVP]

 

[John]

First of all thanks for your clear explanation.
As you mention I really need some mental adjustment as I am not used to work
with databases.
The "Word table" represent the structure of the niche as you can see from
the outside and this is what I would like to see on the report.
My main problem is how to project the Access table and how to relate the
table.
After your suggestion I tried in this way:

tblNiche
-ID
-Niche name

TblNicheCell
- ID
- IDNiche
- Cellnumber
-
TblNames (person that is the niche)
- ID
- IDNiche
- FirstLastName
- BirthDate
- DeadDate

What do you think? Any other suggestions?
Thanks again for your time and patiente
Regards
JohnB