Search results

Hi RainLover attached db as done so far. Thank you. Im very grateful that you will look at it! Ani :)

Oh how amazing! You would look at what Ive done! Thats awesome! Thank you. Errm the joins and relationships thing has me slightly confused. Its the terminology. From what I understand a table is a 'relation' so I wasnt sure how to explain that Id put the lines on joining the tables. I will...

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...

I suppose 'cheap' is comparative....our standard of living and general living wage is low compared to the USA and quite a few other countries, or so I believe. Im not much of a traveller anyway, probably because as a child we moved around so much. My Dad was in the army. I like to stay close...

Yes! As I have been playing with designing forms there have been a few fields Ive had to change, Im just worried now that I havnt missed something that cannot be changed at a later date. The normalisation explanations have helped enormously though. I think that perhaps I should make a back up...

Thanks Paul! I should imagine your daughter will be glad to get back to some nice dry Nevada weather, it is very soggy here at the minute.....it is in darkest Derbyshire anyway! But good reason to stay indoors and play with Access! :) Ani

Hello everyone I've done everything the wrong way round, jumped in with both heavy hands on the keyboard, asked questions without really understanding what I wanted to know and which order I should be doing things in and I've posted a fair few questions without bothering to introduce myself...

Thank you. I think I can see what you mean. For some of the forms I envisage, it will probably help to keep the forms precise, to use a query. The db is only going to be used by myself, I am running a service that is really more of a hobby than a business. However I want to learn how to...

OK, Ive had to read that 3 times but I think I understand, for instance - I could write a query to find a customer (address and all details needed for sending a letter or contacting them) which will then help me create the form. Is that what you mean? Am I understanding correctly? Thanks Ani

Ok Thanks. Ani

Hi folks My Tables are created (with relationship joins) and Ive done my best to normalise them. Can you please tell me if I should I move on to create forms next or queries? Is it a matter of preference or are there reasons for doing either/or in a certain order? If there are reasons for...

Thanks Dave...no I couldnt work in the tables anyway. I dislike working with spreadsheet or listed information, Im afraid my brain doesnt work in the correct way to work with linear stuff! I have a rather untidy way of working things out and tend to think in abstract ways, which is why the db...

Thank You! Im obviously jumping a bit ahead of myself because Im not ready to start queries yet! I will modify the fields to DOB where needed though, now! Im a bit confused as to what I should do after creating and normalising tables. Should I do queries or forms or something else first...

Thanks! Im going to be the only 'user' but the idea of putting everything from paper onto the db is to make things easier and more efficient for myself so I will treat everything as if someone who has little knowledge of what I do can interface with the db itself. Hopefully that way I should...

The attached pdf is much easier to understand! Have picked up a few things so far that will help! One being its possible to put more than one foreign key into the tables! Slowly but surely its beginning to make sense! Thank you again! Ani

I think that is my next move then. Many fields are customers answers, some can be descriptively quantified but the problem I am having, moving my service from paper to MSDB, is that much of the data I collect is descriptive, subjective and unquantifiable. I understand the importance of setting...

Thank You! Yes the article is a great help. I will have to read some of it again but the section about normalisation is probably the most useful, atm. I do think I have normalised my tables but will check them through again now that I understand what it is! I am slightly confused as to how far...

Hi out there I think I need some words of encouragement! Im trying really hard to understand the logic of MS Access and failing! However Im not prepared to give up...its confusing, frustrating and totally addictive! I am going to bed trying to work out what Im doing wrong and waking up in the...

Thank you for your reply. I am not sure that I understand the points you are making. All of the data in the tables is related to the end point of the service I offer, except the Invoicejctn tbl. The customer owns the horse. The customer is responsible for the pasture management. The customer...

Thank You! Probably not; I will have a look and let you know. Ani :)