Arthur Fuller
artful at rogers.com
Sun Feb 22 21:38:06 CST 2004
Yes, I published the recipe notion a while back. And am about to revive it with a few bells and whistles :) Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson Sent: Wednesday, February 11, 2004 6:59 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Re: Teaching Access Course Thanks Robert and Gustav Excellent! The recipe idea is simple enough for most people to understand. I disliked the typical examples of a dog kennel or Vet office. Everyone eats, everyone should be able to identify with a recipe. I looked up the archive example Arthur did March 2002. Gustav you came up with the answer! Was this puzzle ever published in an article? Thanks all - lots of great advice. Jim -----Original Message----- From: Gustav Brock [mailto:gustav at cactus.dk] Sent: Wednesday, February 11, 2004 3:24 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Re: Teaching Access Course Hi Robert Good example. Arthur Fuller did work with recipes too. Look up the archive for "SQL Puzzle" in Mar. 2002. The question was, given a certain mix of ingredients, how to list which recipes could possibly be chosen ... /gustav > Jim, > I think you are trying to cover way too much in too short of a time. > I > have taught Access, from people who were not sure of the spelling of it to > people who thought they knew everything there was to know about it. > What are they wanting to accomplish? You should tailor the sessions > to the > purpose they want to accomplish. For example, I am teaching a 3 hour > introduction to queries a week from Saturday to a class of 4 or 5 > people. The purpose is for them to be able to query the database for > themselves to get information, create mail merge lists, etc. > Normalization itself is a two day class. But here is the 10 minute version > of it. > We are going to build a database to hold recipes. Write down on a > sheet of > paper the things we need to store about a recipe. Now, look at each > item > and ask the question, "Can there EVER be more than one of this item?" If > the answer is "Yes," then you will need another table to hold the data. If > you follow that without wavering, you will get to 5th normal form. > ;-) > For example "ingredient" Can a recipe ever have more than one > ingredient? Yes, then there needs to be a table to hold them. Can an > ingredient ever use more than one kind of measure? Yes. Then the > measurement method needs to be in a table. Can a recipe fit into more than > one category (dessert, main course, bread, etc)? Yes. Then there > needs to > be a table to hold it. > My guess would be that they want to be able to query the database and > do > reports. Day 1 - Queries Day 2 - Reports ;-) > Robert _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com