IFS 106 Homework #3

 Queries


Due Fri Sep 22, 2006

Wrap Chapter 2 with these exercises:

Database Instructions
Babbage Bookkeeping ITL 2 (page 110)
Dog Walkers C&P 1 (page 112)
Regional Books C&P 3 (page 112)
Campus Housing C&P 4 (page 112)

And now, for something completely different...

Your final task for homework #3 is to use Access to create 2 web pages: a table and a query. What the heck? Try it:

  • Here are some notes on creating your own Noctrl web page: Prof Bill's Notes: Creating Web Pages
  • Once you have a web page up and running, you need to save one of your reports in HTML, the language of the web (sigh).

You can create your web pages using Access by doing:

  1. Open the thing you want to save as a web page... for this exercise, a table or query
  2. Use the File/Export menu, select HTML as your file type, and save your web page to your w: drive.
  3. You may want to play with the formatting options, but I won't take off for weird formatting in this homework

Once your Access-inspired web pages are saved, then try and create a link to them in your index.htm file. Explain in your main web page what each of the pages is. Hey, here's my example of this setup: Prof Bill's Web Page Example

I'll make you a deal because we've been working so hard. The web page stuff isn't due until Sunday night. I'll peek at your web sites Monday morning before class. Cool? Cool.

www... yow, bill

back to IFS 106... wtkrieger@noctrl.edu