Store data in a multi-dimensional table
Posted on 2014-01-28
Please forgive a very naïve, basic question.
I want to make a database to describe certain characters in a novel or any work of literature. I begin with a table in Word or Excel. Across the top are the names of the characters. Down the left side are page numbers in the book. If there is something on page one in the book I want to note about character A, I then write it in the cell at the intersection of Page 1 and Character A. Cells in Word can expand to hold lots of information. In Excel the cells can also expand, but they can equally well spill out their contents into the adjacent cell if the latter is empty. Both applications can hold all the data I need, and the above system works very well.
The table is two-dimensional, but what if I want to add more dimensions? How about having an axis to contain appearances or some other trait? I could have a two-dimensional table to have characters along the title row and other characteristics down the left side: age, origin, religion, personality, and so forth. A third axis could contain the page references for the notes, if that is possible.
My basic, simple (I hope) question is how can I make a multi-dimensional table for data in Word or Excel? Would it be easier to learn to use Access? I’d prefer to use Word since I’m more familiar with it, but if Access would be easier for this problem, then so be it.
Thanks for any suggestions.
JR in Priddis, Alberta