Wednesday, January 21, 2009

Session 3 - Databases

This week we learned how data is organized in a relational database. We looked at actual tables in a database, and we learned how to create a query and a report using MS ACCESS.

Videos showing how to build the query and report in MS ACCESS have been uploaded to our course web site on SOUL. Look for the videos under the "General Documents" folder. You need Windows Media Player to view the videos. Let me know if you can't view the videos as I can provide you with another (free) player.

For the lab exercise, we continued building the Products page. A table is used to layout the product catalog, and hyperlinks are used to allow the user to jump quickly to specific sections on the same page (e.g. by defining anchors named top, shoes, balls, apparel).

A lightbox effect can also used to show an enlarged version of the product photo within an expanded box in the browser window.

Here's the output of the Monday group.

Here's the output of the Tuesday group.

No comments:

Post a Comment