CS 107 Computers and Their ApplicationsFall 2006Buckman Hall 120Team Assignment 6 - Creating a Customer and Transaction Database |
UNH Home Page | Contact Instructor |
Course Home PageSyllabusCourse ScheduleTeam Final Project |
Your business moving along just great and your customer list is expanding. You and your partners decide it's time to organize your customers into a database so you can quickly pull up information about your customers as you need to. You also decide to keep track of your business transactions in the database, so you can create invoices or statements for your customers. Since you purchased Microsoft Office, you decide that you will use Microsoft Access for your database. After much thought, you and your partners decide that you need to create at least three tables and two queries as a start for you business database. A description of each table and query is listed below.
Some business may wish to go even further with Access and create a form and/or a report to better serve their business's needs. The minimum database requirements are due by November 17, 2006 |
CustomerID | CustomerLastName | CustomerFirstName | StreetAddress | City | StateCode | ... |
---|---|---|---|---|---|---|
SJ100 | Smith | John | 3 South Main Street | Milford | CT | ... |
StateCode | State |
---|---|
CT | Connecticut |
VT | Vermont |
OrderNo | CustomerID | ProductNo | ProductName | QuantityOrdered | UnitPrice | BackOrdered | ... |
---|---|---|---|---|---|---|---|
100034 | SJ100 | A-04 | A1 Widget | 200 | 1.99 | No | ... |
CaseNo | CustomerID | WeekOf | HoursBilled | Provider | AdditionalCosts | ... |
---|---|---|---|---|---|---|
D0056 | SJ100 | 10/30/06 | 14 | E. T. Hammer | 20.00 | ... |
If you are using another piece of information for look up in your customer database, you will have to use your look-up table, and not the State code table in this query.
Which ever one of the extra credit options you may chose, your form or report must include your business logo (WordArt), business name, and business address.
Last Updated: 10/30/06 |