Module 3: Data Normalization Assignment: Import Data and Build Relationships Instructions In this assignment you will work with both MS Access and Excel. M

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

Module 3: Data Normalization 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:

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

(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

Category

QtyInStock

RetailPrice

Cost

VendorID

PictureNumber

1.0

Buick Skylark

The 1953 Skylark featured V8 power and a 12 volt electrical system, both a first for Buick, as well as full-cutout wheel openings, a styling cue that would make its way to the main 1954 Buick line. Also making its way into the 1954 Buick line was the cut-

1953

Buick

Skylark

Red

1:18

Cars

16.794

2.0

Cord 810

What the maker called “The New Cord Front Drive” was the only front wheel drive car built in America in that era. (An earlier Cord was manufactured from 1929 to 1932.) Today, front drive has triumphed as the preferred method of propulsion the world over.

1936

Cord

810

Black

1:18

Cars

23.994

3.0

Chevrolet Corvette Convertible

Every year, more and more Corvette drivers are discovering the joys of fusing the classic looks of early Vettes with the modern technology of the C4. While the first of the genre were cobbled affairs with questionable geometry and shade-tree mechanics, to

1959

Chevrolet

Corvette

Red

1:18

Cars

15.594

4.0

Chevrolet Corvette Convertible

One noteworthy addition of optional fuel injection in mid-1957 (also available on Chevrolet Bel Air). Fuel injection first saw regular use on a gasoline engine two years prior on the Mercedes-Benz 300SL “gullwing” roadster.

1957

Chevrolet

Corvette

Yellow

1:18

Cars

13.194

5.0

Chevrolet Bel Air Convertible

1953

Chevrolet

Bel Air

Red

1:18

Cars

20.994

6.0

Ford Fairlane

1967

Ford

Fairlane

Dark Red

1:18

Cars

19.194

7.0

Buick T-Type

1968

Buick

T-Type

Gray

1:18

Cars

19.794

8.0

Pontiac Vibe

2003

Pontiac

Vibe

Yellow

1:18

Cars

1.0

19.99

11.994

9.0

Pontiac Fiero GT

2003

Pontiac

Fiero

Red

1:18

Cars

13.884

10.0

Chrysler Crossfire

2004

Chrysler

Crossfire

Gray

1:18

Cars

16.794

11.0

Ford Saleen Mustang

2000

Ford

Mustang

1:18

Cars

12.0

Chevrolet Camaro 35th Anniversary

2002

Chevrolet

Camero

1:24

Cars

13.0

Ford Coupe 2-Door

1932

Ford

Coupe

1:18

Cars

16.794

14.0

Ford Mustang

1964

Ford

Mustang

1:18

Cars

16.794

15.0

Ford Convertible

1937

Ford

Sedan

1:18

Cars

14.394

16.0

Volkswagen Beetle

2003

Volkswagen

Beetle

1:18

Cars

13.194

17.0

Ford Model A Pickup

1931

Ford

Model A

1:18

Trucks

17.994

18.0

Aston-Martin Mark II

1934

Aston-Martin

Mark II

1:18

Cars

26.994

19.0

Ford Crown Victoria

2000

Ford

Crown Victoria

1:18

Cars

14.994

20.0

Cord 812 Supercharged

1937

Cord

812

1:32

Cars

15.594

21.0

Lincoln Continental

1961

Lincoln

Continental

1:18

Cars

33.594

22.0

Chevrolet Bel Air

1955

Chevrolet

Bel Air

1:18

Cars

23.0

Ford Galaxy 500

1963

Ford

Galaxy 500

1:18

Cars

20.994

24.0

Chevrolet Bel Air

1950

Chevrolet

Bel Air

1:18

Cars

16.794

25.0

Chevrolet 150

1957

Chevrolet

1:18

Cars

25.194

26.0

Pontiac Bonneville

1958

Pontiac

Bonneville

1:18

Cars

19.194

27.0

Ford Pickup

1948

Ford

150

1:18

Trucks

16.794

28.0

Chevrolet Impala

1959

Chevrolet

Impala

1:18

Cars

16.194

29.0

Dodge Charger

1966

Dodge

Charger

1:18

Cars

17.394

30.0

Ford Boss 429 Mustang

1970

Ford

Mustang

1:18

Cars

16.794

31.0

Honda RC211V

2003

Honda

1:9

Motorcycle

29.994

32.0

Ducati Superbike

2002

Ducati

1:9

Motorcycle

29.994

33.0

Shelby Coupe

1965

Shelby

Coupe

1:18

Cars

23.994

34.0

Porsche 935

1955

Porsche

935

1:18

Special Interest

28.794

35.0

Honda F1 RA272

1965

Honda

1:12

Special Interest

89.994

36.0

Watson Roadster

1959

Watson

1:18

Special Interest

59.394

37.0

Kurtis Kraft #99 Art Cross

1955

SpecialInterest

1:18

Special Interest

59.394

38.0

Eagle #6 Bobby Unser

1967

SpecialInterest

1:18

Special Interest

71.994

39.0

AAR Eagle

1974

SpecialInterest

1:18

Special Interest

71.994

40.0

Chevrolet Z-28

1967

Chevrolet

Z-28

1:18

Cars

17.994

41.0

Cadillac Deville Limo

2001

Cadillac

Limo

1:24

Cars

29.994

42.0

Lincoln Continental Limo

1961

Lincoln

Limo

1:24

Cars

29.994

43.0

Mercedes-Benz Pullman

1966

Mercedes

1:24

Cars

32.994

44.0

Lincoln Presidental Limo

1950

Lincoln

Limo

1:24

Cars

35.994

45.0

Ford Woody

1948

Ford

1:18

Cars

35.994

46.0

Shelby Americana Series

1999

Shelby

1:18

Cars

14.994

47.0

Ford Crown Victoria

1955

Ford

1:18

Cars

17.994

48.0

Chevy Nomad

1957

Chevrolet

1:18

Cars

17.994

49.0

Pontiac Trans Am

1979

Pontiac

1:18

Cars

23.994

50.0

Cadillac Convertible

1949

Cadillac

1:18

Cars

17.994

51.0

Chevy Bel Air Hardtop

1957

Chevrolet

1:18

Cars

17.994

53.0

Mercury TP Cruiser Convertible

1957

Mercury

1:18

Cars

17.994

54.0

Volkswagen Microbus

1962

Volkswagen

1:18

Trucks

23.994

55.0

Buick Electra 225

1959

Buick

Electra

1:18

Cars

23.994

56.0

Datsun 240Z

1970

Datsun

240Z

1:18

Cars

17.994

57.0

Chevy Bel Air

1956

Chevrolet

1:18

Cars

17.994

58.0

Tucker Torpedo

1948

Tucker

Torpedo

1:18

Cars

23.994

59.0

GMC Pickup

1950

GMC

1:18

Trucks

14.994

60.0

Mack 75bx Pumper Fire Truck

1935

Mack

1:18

Trucks

32.994

61.0

Edsel Convertible

1958

Ford

Edsel

1:18

Cars

17.994

62.0

Jaguar E-Type

1971

Jaguar

Green

1:18

Cars

17.994

63.0

MG TC Midget

1947

MG

TC

1:18

Cars

17.994

64.0

Cadillac DeVille Convertible

1949

Cadillac

DeVille

1:18

Cars

23.994

65.0

Dodge Coronet R/T

1970

Dodge

Coronet

1:18

Cars

17.994

66.0

Lincoln Continental MKII

1956

Lincoln

Continental

1:18

Cars

0.0

69.99

41.994

67.0

Ford V8 Convertible

1937

Ford

1:18

Cars

17.994

68.0

Packard Caribbean Convertible

1955

Packard

1:18

Cars

17.994

69.0

Plymouth Barracuda

1969

Plymouth

Barracuda

1:18

Cars

17.994

70.0

Plymouth Satellite

1967

Plymouth

Satellite

1:18

Cars

0.0

19.99

11.994

71.0

Porsche 911

The Satellite was available with the newly optional ‘Street Hemi’ engine in 1966. This engine came compete with the two 4-barrel carburetors and 10.25:1 compression. This body style remained for the following year with only minor trim changes.

1999

Porsche

1:18

Cars

17.994

72.0

BMW Z4

2003

BMW

Z4

1:18

Cars

17.994

73.0

Mercedes Benz CLK

2002

Mercedes

CLK

1:18

Cars

0.0

19.99

11.994

74.0

Mercedes Benz SLK55 AMG

2005

Mercedes

SLK55

1:18

Cars

17.994

75.0

Lexus LS430

2002

Lexus

LS430

1:18

Cars

17.994

76.0

Alfa-Romeo GT Coupe

2004

Alfa-Romeo

GT

1:18

Cars

17.994

77.0

Ford GT40 Concept Car

2002

Ford

GT40

1:18

Special Interest

0.0

69.99

41.994

78.0

Dodge Viper RT/10

2003

Dodge

Viper

1:18

Cars

17.994

79.0

Chrysler ME Four-Twelve

2004

Chrysler

1:18

Special Interest

17.994

80.0

Ford F-100 Tow Truck

1956

Ford

F-100

1:18

Trucks

23.994

81.0

ALF 700 Pumper Truck

1954

ALF

Fire Truck

1:18

Trucks

17.994

82.0

Mack CF Pumper

1968

Mack

Fire Truck

1:18

Trucks

0.0

19.99

11.994

83.0

E-One Rescue Truck

1999

E-One

Fire Truck

1:18

Trucks

0.0

19.99

11.994

84.0

White Delivery Van

1920

White

Truck

1:18

Trucks

0.0

19.99

11.994

85.0

Chrysler Airflow

1936

Chrysler

Coupe

1:18

Cars

0.0

19.99

11.994

86.0

Hudson 3 Window

1930

Hudson

Coupe

1:18

Cars

0.0

19.99

11.994

87.0

Ford Model T Pickup

1932

Ford

Model T

1:18

Trucks

0.0

19.99

11.994

88.0

Volvo XC90

2004

Volvo

XC90

Blue

1:18

Cars

15.594

89.0

Pontiac GTO

1969

Pontiac

GTO

1:18

Cars

16.794

90.0

Hummer Soft Top

2002

Hummer

1:18

Trucks

0.0

19.99

11.994

91.0

Jaguar E-Type

1971

Jaguar

Red

1:18

Cars

17.994

92.0

Lincoln Model K

1937

Lincoln

1:18

Cars

29.994

93.0

Buick Skylark

1953

Buick

Skylark

Blue

1:18

Cars

17.994

94.0

Jeep Grand Cherokee

2001

Jeep

Grand Cherokee

Black

1:18

SUV

16.794

95.0

Duesenberg SSJ

1935

Duesenberg

1:32

Cars

0.0

19.99

11.994

96.0

Dodge Ram 1500

2002

Dodge

Ram

1:18

Trucks

16.794

97.0

Cadillac Biarritz

1958

Cadillac

1:18

Cars

17.994

98.0

Pierce Arrow B

1930

Pierce Arrow

1:18

Cars

17.994

99.0

Cadillac Town Car

1933

Cadillac

Town Car

1:32

Cars

0.0

19.99

11.994

100.0

Nash Healey

1953

Nash

1:18

Cars

0.0

19.99

11.994

101.0

Cord 812 Supercharged

1937

Cord

812

1:18

Cars

23.994

102.0

Packard Limousine

1941

Packard

Limo

1:18

Cars

26.994

103.0

Jaguar XK120

1949

Jaguar

1:18

Cars

17.994

104.0

Duesenburg Phaeton

1934

Duesenburg

1:18

Cars

29.994

105.0

Lincoln Zephyr Convertible

1939

Lincoln

Zephyr

1:18

Cars

29.994

106.0

Oldsmobile Super 88

1955

Oldsmobile

Super 88

1:32

Cars

17.994

107.0

Reo Touring

1917

Reo

1:18

Cars

17.994

108.0

Buick Roadmaster

1949

Buick

Roadmaster

1:32

Cars

0.0

19.99

11.994

109.0

Ducati 996

2001

Ducati

1:9

Motorcycle

29.994

110.0

Chrysler LeBaron

1932

Chrysler

LeBaron

1:18

Cars

0.0

19.99

11.994

111.0

Cleveland 40 Roadster

1920

Cleveland

Coupe

1:18

Cars

17.994

112.0

Chrysler Imperial

1955

Chrysler

Imperial

1:18

Cars

23.994

113.0

Cadillac Fleetwood

1938

Cadillac

Fleetwood

1:18

Cars

29.994

114.0

Studebaker Avanti

1963

Studebaker

Avanti

1:18

Cars

0.0

19.99

11.994

115.0

Ford Coupe

1940

Ford

Coupe

1:18

Cars

17.994

116.0

Chrysler Town and Country

1948

Chrysler

Station Wagon

1:18

Cars

0.0

19.99

11.994

117.0

Reo Touring

1917

Reo

1:18

Cars

17.994

118.0

Packard LeBaron

1930

Packard

1:18

Cars

23.994

119.0

Harley Davidson FLHRC Road King

2001

Harley Davidson

1:18

Motorcycle

0.0

19.99

11.994

120.0

Hummer Hard Top

2002

Hummer

1:18

Trucks

13.194

121.0

Ducati Monster

2001

Ducati

1:9

Motorcycle

29.994

InvoiceNumber

SaleDate

InvoiceDate

CustomerID

SalespersonID

InvoiceAmount

PaymentMethod

TaxRate

TaxAmount

Shipping

Check

Check

Check

Cash

Mastercard

Cash

Check

Visa

Visa

0.056

4610.48

160.0

Check

Cash

COD

Discover

Other

Cash

Check

0.04555

Mastercard

Visa

Check

COD

Amex

Check

0.04555

877.9762

275.0

Cash

Other

Check

0.04555

Mastercard

Check

0.029

Check

Check

Check

Check

Check

Check

Other

Check

Check

0.0725

Check

Check

Check

Check

Check

Other

Check

Check

Check

0.04555

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality