Import Data and Build Relationships

Assignment: Import Data and Build Relationships Instructions

In this assignment you will work with both MS Access and Excel. Much of the work you do this module you have done already in module 2. The only new task in this assignment is to ‘import’ data from Excel into Access. Reference the MS Access textbook for instructions on importing data. Note that the Module 3 data file referenced below is located as an attachment in the assignment submission folder that follows this page.

Here is what you need to do:

Don't use plagiarized sources. Get Your Custom Essay on

Import Data and Build Relationships

Just from $13/Page

Order Essay

Download Module 3 Data file. (Module 3 Data.xls – a link is provided in the assignment submission folder that follows this page)
Open the Excel file that you just downloaded and take note of the three tabs: Customers, Products, and Sales.
Open MS Access and create a new database named Module 3.
Create three tables named Customers, Products, and Sales.
Open each table in Design View and add fields to accommodate data in each of the columns. Use the column titles as field name. Determine proper data type for each field.
Be sure to assign Primary Key to each table.
After creating the three tables, import data from each tab in the Excel file to the appropriate table in Access.
Create a Relationship between the three tables.
Submit your database to the appropriate assignment submission folder.

Sheet: Customers

Sheet: Products

Sheet: Sales

CustomerID

Company

Address

City

State

ZipCode

Phone

Fax

Email

WebSite

InitialCustomerDate

CreditLimit

CurrentBalance

CreditStatus

LastSalesDate

DiscountPercent

Notes

Active

1.0

Fun Zone

105 S Dubuque Street

Iowa City

IA

52240-

(319) 352-0725

(860) 555-1930

sales@@funzone.com

www.funzone.com

OK

0.35

2.0

Exelon Shoppe

123 South Street

Newington

NH

12301-

(603) 555-6887

(603) 555-6880

sales@ExelonShoppe.com

www.ExelonShoppe.com

OK

0.4

3.0

Southwest Softies

Rt 9

Pine Plains

NY

12567-

(518) 555-6699

(518) 555-6690

schina@SouthwestSofties.com

www.SouthwestSofties.com

OK

0.3

4.0

Pinnacle Playables

560 Broadway

Salem

NH

03079-

(603) 555-4422

(603) 555-4420

sampsg@PinnaclePlayables.com

www.PinnaclePlayables.com

OK

0.35

5.0

Toys in the Basement

100 Elm Street

Sunnyville

GA

12305-

(478) 555-8822

james@ToysInTheBasement.com

www.ToysInTheBasement.com

OK

0.4

6.0

Rockin And Rollin

60 Newbury Rd

Carlsen

NY

10554-

(212) 555-9639

(212) 555-9630

Johnson@RockinAndRollin.com

www.RockinAndRollin.com

1205.63

OK

0.3

7.0

Mary’s Merchandise

95 south Main Street

Summerville

CT

06028-

(860) 555-1285

(860) 555-1286

Tierney@MarysMerchandise.com

www.MarysMerchandise.com

OK

8.0

World’s Best Toys

54 Oak Street

New Town

NY

10555-

(212) 555-7774

(212) 555-7755

joann@WorldsBestToys.com

www.WorldsBestToys.com

OK

0.3

9.0

Carmen’s Collectibles

15 Hatter Drive

Allison

PA

15413-

(724) 555-9874

(724) 555-9870

ch@CarmensCollectibles.biz

www.CarmensCollectibles.biz

OK

0.35

10.0

Red Hat Hattery

1600 Mountain Rd

Montclair

CA

91763-

(909) 555-6666

(909) 555-6000

rob@RedHatHattery.com

www.RedHatHattery.com

OK

0.3

11.0

Adorable Stuff

93 Prospect Ave

Bell Gardens

CA

90202-

(323) 555-4777

(323) 555-4700

robbie@adorables.com

www.adorables.com

OK

0.35

12.0

All Your Needz

8 River Run

Island Lake

IL

60042-

(847) 555-1234

(847) 555-1230

matt@AYNeedz.biz

www.AYNeedz.biz

OK

0.4

13.0

Terriffic Toys

64 Highland Street

Sale Creek

GA

31784-

(912) 555-4567

(912) 555-4500

casper@ttoys.com

www.ttoys.com

OK

0.35

14.0

Regis Toys

15 Mineral Drive

Iron Springs

AZ

86330-

(520) 555-6888

(520) 555-6800

pete@registoys.com

www.registoys.com

OK

0.45

15.0

Top End Toys

60 State Street

Salado

TX

76571-

(254) 555-1236

(254) 555-1200

jon@topendtoys.com

www.topendtoys.com

OK

0.45

16.0

Coventry Collectibles

15 Main Street

Elsa

TX

78543-

(956) 555-4544

(956) 555-4500

will@CoventryCollectibles.com

www.CoventryCollectibles.com

OK

0.3

17.0

The Toy Box

15 Long Ave

Greenleaf

ID

83626-

(208) 555-6914

(208) 555-6910

BigT@TheToyBox.com

www.TheToyBox.com

OK

0.35

18.0

Zoomy Collectibles

55 West North Street

Knox

IN

46534-

(219) 555-3666

(219) 555-3660

Zoomie@ZoomyC.biz

www.ZoomyC.biz

OK

0.35

19.0

Paul’s Best Toys

54 Plains Rd

Turon

KS

67583-

(316) 555-7778

(316) 555-7770

paul@PaulsBestToys.com

www.PaulsBestToys.com

OK

0.4

20.0

Midwest Collectibles

16 South Hill Road

Truxton

MO

63381-

(636) 555-9560

(636) 555-9566

queenie@MidwestCollectibles.biz

www.MidwestCollectibles.biz

OK

0.35

21.0

All Star Toys

971 E Main St

Detroit

MI

12345-6767

(989) 555-2222

(989) 555-2220

nancy@allstartoys.net

www.AllStarToys.com

OK

22.0

Carl’s Collectibles

105 Main Street

Columbia

MA

12237-

(413) 555-1989

(413) 555-1980

chamm@yahoo.com

www.CarlsCollectibles.com

OK

23.0

Your Favorite Things

75 Main Street

Bedford

NY

10506-

(518) 556-5555

(518) 556-5550

mdennis@YourFavoriteThings.com

www.YourFavoriteThings.com

OK

24.0

Gleason’s

196 East Street

Derby

CT

06418-

(860) 555-3299

(860) 555-3290

Gleason@Gleasons.biz

www.Gleasons.biz

OK

25.0

Tommy’s Toys

46 School Street

Oneco

CT

06373-

(203) 555-9101

(203) 555-9100

Alex@ttoys.com

www.ttoys.com

OK

0.3

26.0

Too Many Toys

54 E Center Street

Granby

CT

06035-

(860) 555-4564

(860) 555-4560

Karla@tmt.com

www.tmt.com

OK

0.4

27.0

Grandma’s Closet

986 Buckingham St

Brewster

NY

10509-

(212) 555-1600

(212) 555-1605

Johnm@grandmas.com

www.grandmas.com

OK

0.3

ProductID

Description

Features

ModelYear

Make

Model

Color

Scale