Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Wine database.

May 21, 2005 8:46PM PDT

I have no clue about MS Access. However I would like to create a database of wines that I have had. What is the easiest way to do it?
I know I can look it up in Google and the software, but I want a shortcut.

JJ

Discussion is locked

- Collapse -
Re: wine database
May 21, 2005 10:53PM PDT

Jimmy,

As long as you can put every information you want into ONE table: use Excel or any other spreadsheet.

Otherwise: start with making a good normalized database design as outlined in http://www.geekgirls.com/databases_from_scratch_1.htm, (through Cool, for example.

On your MS Office CD (provided it contains MS Access) there's an few-100-page e-book titled "Making Applications with MS Access" or something like that (on the Office 97 CD at least, I didn't check later versions). Good stuff, but not really something to master in a few days.

In fact, my university IT-students have serious trouble to design a workable 15 table-database for a more or less real case-study (part of a garage), and then I don't even speak about the rubbish they produce trying to make a somewhat working prototype in MS Access.

Kees

- Collapse -
Thank you!
May 22, 2005 9:16AM PDT

I think you're right about the spreadsheet. I think all will fit on one table.

Thank you Kees

JJ

- Collapse -
A few thinks.
May 21, 2005 11:38PM PDT

Given that such an idea was asked in 1996 and nothing happened... see -> this link and that so many ask this, here's the deal. There's nothing new about this database versus any other database. That is, if you use MS Access for other things, then this is just another thing.

That being said, it would be hard to top http://phpwims.sourceforge.net/ given it's maturity.

Bob

- Collapse -
Not a special data base
May 22, 2005 9:09AM PDT

I didn't mean a special database, but just a database. I don't know how to create a normal database.

JJ

- Collapse -
MS Access comes with a tutorial.
May 22, 2005 9:44AM PDT

Start with that or "a class" or "a book."

Bob