Ani
Registered User.
- Local time
- Today, 18:04
- Joined
- Mar 10, 2012
- Messages
- 196
Hi folks
Please can you help with my thought processes for my first ever hobby db. I have done the following:
I have created 7 tables, one of which is a jctn table.
I have joined the tables.
I have normalised the tables and added LookUp parts to the fields with options.
I have read about creating forms and created and deleted forms for some practice.
I have read and looked at how queries are created and how/why it is good practice to create forms using queries.
I have written down what queries I will need to perform, that will be useful to me. Some are obvious and will require a few fields from several tables. These make sense to me and I should not have a problem creating, using the queries to create the forms.
I now have a number of questions in my head which I would greatly appreciate advice about
How do I know if the relationship joins on my tables are correct?
Should I create forms and queries to test the joins or is there more to read?
I have read sections about what the types of joins 'do' and have a basic understanding.
The major question in my head is "how do I bring together, all the information, I need to perform my end task?"
My end task is writing a letter which advises the customer about the health of their horse. This letter is based on information the customer provides and results of the tests I perform and is formed from my interpretation of the information, my knowledge and experience.
The information needed is placed in 4 tables-
CustomerDetails - just FirstName and LastName needed
HorseDetails - all fields except ID's - total of 14 fields
PastureManagement - all fields except ID's - total 14 fields
Results - total 4 fields
Should I create a query for this as well and then worry about how it is displayed afterwards? What would be the most efficient way to achieve this or do I need to approach this in a different way?
It is quite a chunk of information, at present I gather the paper forms together and sit at my pc flicking through the forms to write the letter. Oh perhaps I have just answered my own question! I am interested to know how others would deal with this though.
I hope I have written this in a way that makes sense. Please let me know if I need to think about this in a different way.
Many Thanks
Ani
Please can you help with my thought processes for my first ever hobby db. I have done the following:
I have created 7 tables, one of which is a jctn table.
I have joined the tables.
I have normalised the tables and added LookUp parts to the fields with options.
I have read about creating forms and created and deleted forms for some practice.
I have read and looked at how queries are created and how/why it is good practice to create forms using queries.
I have written down what queries I will need to perform, that will be useful to me. Some are obvious and will require a few fields from several tables. These make sense to me and I should not have a problem creating, using the queries to create the forms.
I now have a number of questions in my head which I would greatly appreciate advice about
How do I know if the relationship joins on my tables are correct?
Should I create forms and queries to test the joins or is there more to read?
I have read sections about what the types of joins 'do' and have a basic understanding.
The major question in my head is "how do I bring together, all the information, I need to perform my end task?"
My end task is writing a letter which advises the customer about the health of their horse. This letter is based on information the customer provides and results of the tests I perform and is formed from my interpretation of the information, my knowledge and experience.
The information needed is placed in 4 tables-
CustomerDetails - just FirstName and LastName needed
HorseDetails - all fields except ID's - total of 14 fields
PastureManagement - all fields except ID's - total 14 fields
Results - total 4 fields
Should I create a query for this as well and then worry about how it is displayed afterwards? What would be the most efficient way to achieve this or do I need to approach this in a different way?
It is quite a chunk of information, at present I gather the paper forms together and sit at my pc flicking through the forms to write the letter. Oh perhaps I have just answered my own question! I am interested to know how others would deal with this though.
I hope I have written this in a way that makes sense. Please let me know if I need to think about this in a different way.
Many Thanks
Ani