Curtis, Andrew (WAPL)
andrew.curtis at wapl.com.au
Wed Feb 11 20:44:49 CST 2004
Some excellent free tutorials and cheap online courses for access are here: http://tutorials.freeskills.com/index/category/104 Andrew -----Original Message----- From: Jim Hewson [mailto:JHewson at karta.com] Sent: Wednesday, 11 February 2004 10:59 PM 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 CONFIDENTIAL COMMUNICATION If you receive this confidential communication by mistake, please contact the sender immediately by return electronic mail. Worsley Alumina Pty Ltd ABN 58 008 905 155 is the manager of the Worsley Joint Venture - Bauxite/Alumina Operation. Liability and responsibility of the Joint Venturers is several in accordance with the following schedule of participating interests: Billiton Aluminium (RAA) Pty Ltd 56 percent, Billiton Aluminium (Worsley) Pty Ltd 30 percent, Japan Alumina Associates (Australia) Pty Ltd 10 percent, Nissho Iwai Alumina Pty Limited 4 percent.