Recent content by pandzio

Re: beginner - easier to have big table & subdivide it or have couple table sharing I Thanks for the replies :) I am not implying that any data is lost when "deconstructing" from Flat to Normalised. No, I know it's not lost. I mean that - the way I saw people presented how it works (in ALL...

Re: beginner - easier to have big table & subdivide it or have couple table sharing I Dear SQLWayne, REGARDING NORMALISATION (My issues or unfitting with it? Perhaps just not understanding the use in complex cases, I wish) I will be working with at least 50 tag-categories for each item. Most...

Hi I would love to learn a way to: 1) put my cursor in first empty cell in the specific column (call it the "image" row) Magic happening: 2) Excel asks me to select the files - I navigate to the right folder and select a group of files 3) Excel pasts them (as links, not pasting as bitmap...

Re: beginner - easier to have big table & subdivide it or have couple table sharing I Thank you for your answer, The Doc Man, I almost lost all hope, that anyone would bare with me any more on this. When I will be fed up with Excel? Like... right now? I stopped using my database (it was a...

Re: beginner - easier to have big table & subdivide it or have couple table sharing I OK, so all you guys made me almost give up..> After some thought: I want many little things, but if I concise myself to what I actually WANT for now (as a total novice) it is one thing. And relational...

Re: beginner - easier to have big table & subdivide it or have couple table sharing I Thanks jdraw! I'm a total newbie for databases in general. Can you help me a bit more? Thesaurus is a common word. Searching for thesaurus +database (+create) gives mostly results that are tutorials for users...

Yeah, I know I must be one of those beginners that want to make their first thing in Access be a jack of all trades for guys who actually do work with it. Sorry. My examples are preliminary and indeed terrible. Can we ignore them? I know for sure my database will rely on RTF memo field and...

Re: beginner - easier to have big table & subdivide it or have couple table sharing I Thanks guys! I am looking at presentations on database theories and concept on normalisation especially. But this is just theory with examples that are simplified (perhaps I should rather read, as you suggest...

beginner - easier to have big table & subdivide it or have couple table sharing ID? [beginner question - easier to have big table & subdivide it or have couple table sharing ID?] I plant to have a big database that are on the same level of concept, but they are in different topical/thematic...

Hi, MarkK. You understand my planned database structure quite correctly. But this was only to illustrate my question of more general nature (as I anticipated I will be asked "what do you want to do?") :) However - if that was not clearly highlighted - I was asking for advice on CHOICE of...

I'd like to manage database-like my hard drive full of various types of files connected to my filed of interest. Its ancient sources and modern works that analyse and cross reference them. So it is a lot of images of old manuscripts, retyped old text in Ancient languages, scholarly books and...

articles and books divided in chunks that are of scholar matter. Contemporary text analysing and cross referencing the ancient texts. Several translations of same ancient texts with cross references. I am trying to have a database of old text ancient Greek corpus I work on with all the cross...

Hi. From tutorials I watched, I seem to get how NORMALISATION works. I can see myself using and appreciating it. I have this set of nagging questions, and I impatiently wonder will I be able to have them work that way, or should I calm down with planing to move my entire Excel databases into...

Hi! I am details-&-sorting lover artist, but not a programmer (not very good with such thing). I have been making my databases in Excel and OneNote, but to only limited satisfaction. I know a real database would be better, since I store strings of text and images (for example page scans and...