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

Re: Access 

By: micro in 6TH POPE | Recommend this post (1)
Thu, 07 Apr 22 8:09 PM | 27 view(s)
Boardmark this board | 6th Edition Pope Board
Msg. 31092 of 60008
(This msg. is a reply to 31083 by Decomposed)

Jump:
Jump to board:
Jump to msg. #

you are more ambitious than I am !!
Glad you are going to ustilize some of microsoft office I have yet to have a use for..

I don't think you quite have enough to do to keep you busy.. You get all your planting stuff done already ?

Maybe go till and plow some more acreage for the gardens?

SCI FI is not interetsing to me in book form and with the exception of old original stupid Star Trek t.v. episodes I really never developed an appetite for it. I like HISTORY. Its always fascinating to note how different people develop entirely different tastes in things during their lives. You have your work cut out for yerself De with all those books.
Best of success for your endeavor !!


- - - - -
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