Using a template is the easiest way to get up and running quickly with Microsoft Access. Here's how to create an Access database using a template.

It's been quite a while since I've built an Access database, but I suppose it's like riding a bicycle and it will all come back to me. But I'm not sure Access is the proper tool for what I want to do.

We finally went through many years of cooking magazines and newspapers and clipped out recipes that we might potentially want to use at some point (there are a few hundred). Now I want to index them. I don't want to put the recipes themselves into a database; I will keep them in hardcopy in a yet to be determined number of folders.

But I want to go to the database and find recipes by type (meatloaf versus chocolate cake, or maybe barbequed beef ribs versus pork ribs, haven't decided all the keys yet). Is this a good use of Access? Or is it overkill?

Maybe I could do the same thing with Excel. Any thoughts or similar experiences? Wario Land Hack Snes. On Wed, 13 Apr 2005 14:55:19 GMT, Bob wrote: It's been quite a while since I've built an Access database, but I suppose it's like riding a bicycle and it will all come back to me. But I'm not sure Access is the proper tool for what I want to do. We finally went through many years of cooking magazines and newspapers and clipped out recipes that we might potentially want to use at some point (there are a few hundred). Now I want to index them. I don't want to put the recipes themselves into a database; I will keep them in hardcopy in a yet to be determined number of folders.

But I want to go to the database and find recipes by type (meatloaf versus chocolate cake, or maybe barbequed beef ribs versus pork ribs, haven't decided all the keys yet). Is this a good use of Access?

Or is it overkill? Maybe I could do the same thing with Excel. Any thoughts or similar experiences? You can download a Recipe database from Microsoft and adapt as much of it as you want. -- Fred Please only reply to this newsgroup. I do not reply to personal email. Bob, Give me a couple hours.

I am in the middle of something else. I have Access 97 and 2000 so I can run the conversion for you. It'll be at after 5pm or so EDT. -- Alan Webb 'It's not IT, it's IS' 'Bob' wrote in message news:P6****************@newssvr14.news.prodigy.com. 'fredg' wrote in message news:1f****************************@40tude.net.

You can download a Recipe database from Microsoft and adapt as much of it as you want. -- Fred Please only reply to this newsgroup.

I do not reply to personal email. Thanks for the suggestion, though this template is for Access 2000 and I have Office 97 (I said it had been a while). So I guess the template won't work for me. What I think you are asking for is a searchable filing system, not so much a recipe database with ingredients and instructions. Something more akin to a movie or music collection database. Good News Bible For Mobile Phones. You might look at one of those for inspiration.

As to Access or Excel - if you want to do complex queries (e.g., give me all the meatless appetizers of Greek origin), then I think Access is the tool. Excel will work, but will be messy.

That said, do you have the time and inclination to reaquaint yourself with Access? If not, then a messy Excel spreadsheet is better than a superior in concept, but unbuilt, Access database. Bob, Ok, I did the conversion to Access 97.

The URL is what I said it is in my other post. -- Alan Webb 'It's not IT, it's IS 'Bob' wrote in message news:P6****************@newssvr14.news.prodigy.com. 'fredg' wrote in message news:1f****************************@40tude.net. You can download a Recipe database from Microsoft and adapt as much of it as you want.

-- Fred Please only reply to this newsgroup. I do not reply to personal email. Thanks for the suggestion, though this template is for Access 2000 and I have Office 97 (I said it had been a while).

So I guess the template won't work for me. Bob & anyone else. If you need this database in Access 97 I did the conversion and put it on my blog..

No, not advertising, I don't want money or anything. Just closing the loop on a promised bit of work.

-- Alan Webb 'It's not IT, it's IS' 'Bob' wrote in message news:rp****************@newssvr14.news.prodigy.com. It's been quite a while since I've built an Access database, but I suppose it's like riding a bicycle and it will all come back to me.

But I'm not sure Access is the proper tool for what I want to do. We finally went through many years of cooking magazines and newspapers and clipped out recipes that we might potentially want to use at some point (there are a few hundred). Now I want to index them.

P5k-e Wifi Wake On Lan here. I don't want to put the recipes themselves into a database; I will keep them in hardcopy in a yet to be determined number of folders. But I want to go to the database and find recipes by type (meatloaf versus chocolate cake, or maybe barbequed beef ribs versus pork ribs, haven't decided all the keys yet). Is this a good use of Access? Or is it overkill? Maybe I could do the same thing with Excel. Any thoughts or similar experiences?