Forum Home | Log in | Signup | My Page | Rules | FAQ | Boards | Members | Search
Replies to Msg. #1203500
.
 Msg. #  Subject Posted by    Board    Date   
31119 Re: Access
   I vaguely remember, De, that microsoft had (once upon a time) 'sample... 		Zimbler0   6TH POPE   08 Apr 2022
 2:24 AM
31097 Re: Access
   ...don't let ya "files" become so important that you don't have time t... 		ribit   6TH POPE   07 Apr 2022
 8:34 PM
31092 Re: Access
   you are more ambitious than I am !! Glad you are going to ustilize... 		micro   6TH POPE   07 Apr 2022
 8:09 PM

The above list shows replies to the following message:

Access

By: Decomposed in 6TH POPE
Thu, 07 Apr 22 4:04 PM
Msg. 31083 of 60008
Jump to msg. #  

I've wanted to do some things in Microsoft Access for a long time but didn't knuckle down and start learning it until a couple of weeks ago. My goal was to create a media management database flexible enough to track my books, magazines, DVDs, CDs, Collectible Newspapers, vinyl records, X-box games ... pretty much anything along those lines that could move around or be lent out.

Books are the main interest. I have thousands... I'd guess seven thousand but I really don't know. Nor do I know what they are, where they are, how many are duplicates. I don't know which ones I've read, what I particularly liked, which ones won awards, etc. When I've found interesting books (pretty near all science fiction is interesting to me), I've often bought them only to find that I already had them, maybe even in hardback or in better condition.

The database, the easily generated queries and the reports I can produce off of it and distribute (say to my wife's smart phone for use when we're on the road), should go a long way toward solving this.

The image below shows the main lookup/entry screen of my little database. It has combo boxes to simplify the entry of authors, media types, genres, categories, valid locations and a few other things. It has validation to minimize entry mistakes and to ensure, where appropriate, that only valid options are entered. The result probably looks simpler than it is. The truth is that writing a media manager - even in first draft, which is how I'd describe this - was more difficult than I expected. I couldn't have done it without the 'For Dummies' book I found - or something like it that holds the beginner's hand and walks him through the process of creating a database.

I'll probably rewrite the program several times as I learn more. I haven't yet cracked the spines of the VBA and SQL books I also bought. Both add enormously to what can be done with Access.

Thank you very much, micro.


Avatar

Gold is $1,581/oz today. When it hits $2,000, it will be up 26.5%. Let's see how long that takes. - De 3/11/2013 - ANSWER: 7 Years, 5 Months