Creating report or query

[Zakoota]

Hello there,
I am quite new to MS access and started to develop a small database for my practice.
I have made four tables that are for Patient details, their doctor detail, their problem and their treatment. I have successfully created form to enter the data.

However I an unable to proceed, now I want to create a discharge letter which will be addressed to the doctor (based on the tables described above)

I want to make this in a way that if I enter the patient details i-e date of birth, ID and / or name a letter is created based on the tables above. I also want this letter to be saved for future use.

Can any body advise me how to design that letter and should it be a query or report.

Thanks
Ahmed

 

[spikepl]

Tables are for holding data, and are not to be shown to users. Queries are used to extract and manipulate data, and are not to be shown to users.

Forms can be based on tables or queries, and are used for user interaction with data. This is the only access to manipulate data that users should have.

Reports are based on tables or queries to supply the data , and are used to output data in a print-friendly and well-formatted way.

You do not save the letter as such - you just retain the data required to generate it.

Find a tutorial on Access reports and work through it.

 

[Zakoota]

Many thanks for reply, now I understand more of forms. My problem still remains how to create form for print out that fetches the data from tables once I enter patient details (name / birth date etc)
I am reading few books but still cant get my head around this.
Ahmed

 

[spikepl]

Don't read books anymore - find some tutorials, one on queries, one on forms and one on reports, spend the 2 hours and you'll be much wiser. Or get a database template from microsoft and see how they do stuff. google access templates

 

[spikepl]

Don't take my posts as a brush-off - it's not. We will help you, but you simply have to work your way through some basic stuff, so we can speak a common language

 

[smig]

if you know how to build forms you should know how to build reports.
basically they are built the same.

if you make a letter out of your data you must make sure the relevant data will never be changed again once the letter was printed.
If you allow a data change you might get a different copy of the letter at a later time.

 

[Zakoota]

Many thanks for reply.
Perhaps I am doing some thing wrong.
The purpose of data base is following:
Patient registration (i have made form and table for this purpose)
Patient Referring Doctor details (form / table made)
Patient Examination and diagnosis ( form and table done )
Patient treatment (form and table done)
Relation of tables done.

Now I am left with creating discharge letter Which have data from above tables at the time of discharge. I want at this level a form / report / query in which I enter patient details and it fetches the data from these tables and populate a letter to send with patient.

I hope you understand situation.
Thanks
Ahmed