Forum Home | Log in | Signup | My Page | Rules | FAQ | Boards | Members | Search
« 6TH POPE Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next

Re: Access 

By: ribit in 6TH POPE | Recommend this post (2)
Thu, 07 Apr 22 8:34 PM | 42 view(s)
Boardmark this board | 6th Edition Pope Board 		Msg. 31097 of 60008
(This msg. is a reply to 31083 by Decomposed)
Jump:
Jump to board:
Jump to msg. #

...don't let ya "files" become so important that you don't have time to read any of them.




Avatar

Liberals are like a "Slinky". Totally useless, but somehow ya can't help but smile when you see one tumble down a flight of stairs!


 - - - - -
View Replies (1) »



» You can also:
- - - - -
The above is a reply to the following message:
Access
By: Decomposed in 6TH POPE
Thu, 07 Apr 22 4:04 PM 		Msg. 31083 of 60008

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.

« 6TH POPE Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next