Week 6:
- Required Reading: Microsoft Office97:
Introductory Concepts and
Techniques: A1.1 - A 3.61, AI 1.1 - AI 1.9 ;
- Required Reading: Understanding and Using the
Internet: Unit 7;
- Written Assignments: Microsoft Office97: Introductory Concepts and
Techniques: Using the
Museum Mercantile Database (A 1.65 In The Lab 1) as a guide, create a
new database
to store information on products you sell in a sporting
goods store which you
own. Create a product table listing at least 10 products,
a vendor table
listing at least five vendors and an inventory report showing
all the products and
their quantities in the report. Create a form for the product
table that can be used
to enter or edit product data one record at a time. Create a
Query that will display
the product id, product description, the vendor's name, and the
vendor's telephone number
from the product table and vendor table in one query.
- Submit the written assignments by e-mail to the instructor,
- Send your instructor a summary of what you learned in class this
week. This report
will be used to record your attendance in class this week.
- Post the address of a favorite website about Access in the Virtual
Classroom Conference
and tell why you like it.
- Post the address of a place outside the United States you would
like to visit or have
visited. Tell why you like it.
- Share something in the conference classroom you learned from this
week's lesson. Post a
question or a response in another student's thread in the classroom
conference.
- Complete additional exercises from the text as needed to become
proficient with the
software and online environment, but do not submit them to the
instructor.