If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Project a new database
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 |
#2
|
|||
|
|||
Project a new database
On Sun, 5 Mar 2006 13:17:43 +0100, "John" wrote:
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] |
#3
|
|||
|
|||
Project a new database
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Database or project contains a missing or broken reference to the | Charlie | General Discussion | 0 | January 11th, 2006 01:00 PM |
visual basic for application project in the database is corrupt | cirruse | General Discussion | 1 | November 27th, 2005 02:45 PM |
Exclusive access to the database | Steve Huff | General Discussion | 17 | December 24th, 2004 06:23 PM |
Database Window Gone | DaveB | General Discussion | 2 | July 29th, 2004 12:24 AM |
Problem using subforms in a multiple database project | David G. | Using Forms | 0 | June 10th, 2004 04:12 PM |