BMATWT 452 - Building Materials Computing and Telecommunications

Assignment Final - Database Design and Marketing

Due Friday May 14, 2004

Using MS Access ( in 302 or H110)

Create a working database with the following Tables, Relationships and Fields'

Table 1: Contacts

Fields:
- ContactID
- FirstName
- LastName
- CompanyName
- City
- State
- ZIP

Table 2: SalesData

SalesID
ContactID
Date
SalesTotal (Total $)

Relationship, as you can guess is through ContactID with a 1:Many relationship (for Each ContactID there may be many Sales

Input sample data in both Tables and Create any one of the following:

QUERY

FORM

TABLE

of your choice, explain what you have created.

Many of the materials created for this course are the intellectual property of the instructor. This includes, but is not limited to, the syllabus, lectures and course notes. Except to the extent not protected by copyright law, any use, distribution or sale of such materials requires the permission of the instructor. Please be aware that it is a violation of university policy to reproduce, for distribution or sale, class lectures or class notes, unless the faculty member has explicitly waived copyright. Copyright 2006, David T. Damery