MISS

Subject: MIS 204 Semester: Fall 2016

Project: 6 Due on: 10/14/2016 11:59PM

Total points: 10

Mode of submission: Online through your blackboard account.

Assignment 6 Description: You work for the J Business Company which sell home appliances to retailers. The company has the following customer data.

Customers
Customer ID	Customer	Address	City	State	Zip
133212	The Happy Birder	44 West Main	Hartford	CT	06101
133222	Hiking HQ, Inc.	678 Smithson Road	Chico	CA	95926
133223	Martin's Mountain Shop	5000 Big Valley Road	Denver	CO	80012
133267	Wilderness Central	4200 Vintage Highway	Sonoma	CA	95476
332121	Country Goods	453 Mill Street	Puyallup	WA	98553
332125	Outside Nation	5365 Chestnut Stree	Detroit	MI	48901
332134	Fresh Air Mike's Deals	5 Oak Drive	Old Town	IL	66549
332167	Peppy's Hardware	102 Pine View Way	Portland	OR	97701
332178	Sully's Surf Shop	2565 Beach Street	Los Angeles	CA	91178

Create a database for the J Business with appropriate tables with necessary fields and store the above data in the database using MS Access. While designing the database

1) Set appropriate fields as primary keys for the tables.

2) Set appropriate data types for the fields.

Strictly follow the below mentioned naming convention.

Name your database as follows

1) Lastname Firstname Project 6 JBusiness.accdb

Use the following instruction for submission

Step 1: Go to the assignment submission section

Step 2: click on “Browse My Computer” button then select and attach the MS Access Database file from your computer.

Step 3: Click “Submit” button.