The Lounge is rated PG. If you're about to post something you wouldn't want your
kid sister to read then don't post it. No flame wars, no abusive conduct, no programming
questions and please don't post ads.
Well, my family is preparing a stock of survival supplies (Dehydrated/Freeze-Dried Food, drink powders, etc.), and I am going to be building a database application that can store the details on the items.
Why not use Access or Excel?
I want to be able to let my... technologically challenged mom enter the data as well. She knows nothing about Access or Excel (and doesn't even have them on her computer!)
The application will use a remote database, but I might set it up to be able to use a local database as well.
And a question: Would you guys like me to release the application online? Would you like me to write an article about it? (e.g The data access stuff, UI design, custom controls, etc.)
And to everyone: We will be keeping up-to-date hard copies of the data, the digital database is just for ease of access BEFORE an emergency. That is all. I will likely add a report generator system to create and print the lists.
I think computer viruses should count as life. I think it says something about human nature that the only form of life we have created so far is purely destructive. We've created life in our own image.
We went around europe in our 1976 VW Campervan this summer - it soon became apparent that our particular type of gas bottle was impossible to find so BBQd water was the norm for a couple of weeks - my daughter still managed to make pot noodles but it took half a forest to get the water anything near hot enough.
I suppose buying another cooker would have been preferable but we were always convinced we find a correct gas bottle at the next stop.
Go for it, Zac. It's easy to get advanced information here at CP, but beginners who ask for simple things are just as likely to be ridiculed as helped. A simple tutorial with detailed explanations would be an excellent introduction to database programming for those who haven't got access to anything better. And this sort of app is just what Access is suited to. I've seen huge, commercial products* inappropriately based on an Access system, and it would be better to illustrate the principles in an application properly scaled to its horsepower.
*The first versions of ESRI ArcInfo I used were built on a .mdb database, as is the SCADA system used at work for managing electrical substations remotely. It's embarrassing...
I've known many people, including my father, who did that. I was always amazed at how many forgot salt and spices. (My dad's system was to make the storage part of our regular eating cycle--it was basically a food warehouse in our basement, but since it was always being used, there wasn't a problem of things going bad. On the other hand, I knew someone who stored lots of raw foods, like soy beans. I asked him one day if he knew how to prepare this material for human consumption. The blank look on his face was priceless.)