Need Help

[royal_sublime]

Dear Friends
I am a novice in database. I need help on the following
1- I created 04 tables with the following fields
Account No, Name, Father/Husband Name, CNIC No, Plot No, Block, Address
2- I also created forms based on above-tables
Now I want to know the way
to search the tables/forms in terms of
a)Account No, b) Name, c) Plot No, d)CNIC No,
being more simple, I give account no and in return all data relating to that account no should be retrieved.
May someone be helpful??
Thanks in ample.
B)
Can somebody tell me the procedure to do the same thing in excel and word?

Thanks again

 

[wiremonkey22]

Does this info have to be in 4 tables?
Why not use one and use queries to display the info you want on a form?
i.e build form from query.

 

[MSAccessRookie]

Does this info have to be in 4 tables?
Why not use one and use queries to display the info you want on a form?
i.e build form from query.

I see four usable tables, and perhaps only three (depending on the relationship between Account No and CNIC No), but I will proceed with describing the four.

tblAccounts
    AccountID --> AutoNumber
    AcctHolderName --> Number (FK to tblPeople)
    AcctOtherName --> Number (FK to tblPeople)
    AcctCNICNum --> Number (FK to tblCNIC)
    AcctPlotID --> (FK to tblPlots)
 
tblPeople
    PersonID --> AutoNumber
    FirstName --> Text
    MiddleInitial --> Text
    LastName --> Text
    {Any other People related info follows}
 
tblCNIC
    CNICID --> AutoNumber
    CICNumber -- > Number
    {Any other CNIC related info follows}
 
tblPlots
    PlotID --> AutoNumber
    Block --> Number
    Address --> Text
    {Any other Plot related info follows}

Using these four tables, you can clearly see how you can use MS Access to identify the information and classify it as you require.

• As far as Forms are concerned, you probably only need to use one one as long as you base the Form on a Query that joins all of the tables and has a place for entering each data field.
• As for as using MS Excel or MS Word to do anything similar, I defer to other experts in this forum.

 

[royal_sublime]

Thanks, that works. Once again Thanks for help