Hi.
I have been using a combination of Excell and Word to store details about magazines I collect. I use a form I made in Word as the layout is easier on the eye and to find information quickly, the Excel sheet as it is searchable for specific data (such as year or cover star for example).
I would like to combine the two into a usable access database if possible so that access stores all the data and lets me search it as I can in Excell (and maybe better) but also let's me display a single magazine entry in a nice format like word does.
My understanding is that I would create small Data-sections for things like the months, years, magazine titles, cover stars etc and these get linked to the main database which stores the magazine details. So rather than store "Glamour", "March", "2013" it would store (for example) 1,3,13 where 1=Glamour on the magazines titles, 3=March on the months section, 13=2013 on the years section. Thus it doesn't store more than it needs too, only references to other data which is called when needed.
Is that essentially correct?
I have not designed a database before and just want to see if I am on the right track. I gather the visual side of it (displaying the data) is down to a Form(?) and searching is down to a Query. Again am I understanding the basics right?
Thanks
Andy
I have attached an example of the word form I use to give you an idea of what I want to create.