Search results

WooHoo progress :) I shall start to put some data into it and then probably start asking questions about queries and forms. Incidentally I went back to our "Single Table" effort and while it did a job of sorts, I now realise how bad it is :o Thank you for starting me on the straight and narrow path!

Nearly everyone has one Main Locker but not a FOD Locker (just a small locker for valuables). You can only have one of each type. Therefore whilst the majority will have one Main and one FOD it is not the case for everybody. Therefore I decided that the Locker Table was the right thing to do...

Plog; I have done the changes as you specified. The Fitness Table is now in the relationship. Like the GOLDLogin, not everyone will be exempt (in fact very few) so I have tied it in the same way. I have included, in the TblPersonnel, everything that is unique to the individual. If you could have...

My Business is Aircraft Maintenance (Military) and we have a terrible habit of using acronyms known only to ourselves :o I have attached some examples of the types of data and some notes to go with them. Also attached is V3 of the relationships. I will keep working away at understanding the...

@ AccessBlaster, just read it it and it is one hell of a thread. Quite a lot to take in :)

Think I have finally grasped what you mean...hopefully. My problem, other than stupidity :), was that in my head I saw a spreadsheet with names running down the left , courses etc across the top and data in the cells. The Add1,2,3,4 in both the Pri and NOK tables are where I have broken the...

Spikepl thank you for your reply and apologies for the way I answered. I was replying, initially to Plog, but should have replied to both of you. I have placed all the Qualifications into one table as you suggested and I have watched several very good Youtube presentations on Normalisation...

Hi, I have attached a screen shot of the Tables I think should exist. Where I think the relationship is correct I have connected the Tables. Where I am having a bit of difficulty, is in how to relate tables, with Qualifications (ie MTQual, AirQual etc) to a Table such as Spikepl suggested. I...

@ Plog First of all Thank You for your reply, and yes I generally work in Excel :) I shall read more and maybe post how it I think it should look for constructive (or destructive) criticism. @ Spikepl Thank you for your reply as well, and, as above I shall work on a structure and throw it up...

Hi, I asked a question in the Query section and mentioned that I had made a table with "the usual last name, first name, course1, course2 etc" The Query reply was very helpful but one of the replies said I should go look at the Normalisation post. I have indeed been and looked and have a...

Thank You for the quick reply. Is this a new query to call on my original query, or have I misunderstood? I shall give it a try anyway tomorrow (when I am back in work) and hopefully have something positive to report!

Hi, I am trying to learn Access (2003 at work and 2013 at home). I am fairly computer literate but have no programming skills whatsoever. Everything I have gleaned so far is from books and forums like this one. I have joined to a) ask questions and hopefully set me on the right path and b)...

Hi, I am using Acces 2003 and have created a Database for work. The main table has usual lastname, firstname etc and also courses (course1, course2 etc) which have a date carried out. Some of these records will be empty because the person has not done the course. I created Form(s) to input...