USA: +1(669)289-8683
USA: +1(669)289-8683

Exp19_Access_Ch08_Capstone – Registry 1.0

Papa_

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

EX19_AC_CH08_GRADER_CAP

_HW.zip

Exp19_Access_Ch08_Capstone – Registry 1.0

Exp19 Access Ch08 Capstone Registry 1.0

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Access Chapter 8 Capstone – Registry

EX19_AC_CH08_GRADER_CAP
  

Project Description:

You work as a database manager at Virtual Registry, Inc. This firm specializes in supplying china, crystal, silver, and collectible gifts online. You will add a hyperlink field that will store a URL for each manufacture’s website. The HR department manager wants to store a photo and the most recent performance review for each employee. You also export data from the database to three different formats. Finally, you import information from Excel, Access, and text files.

     

Start   Access. Open the downloaded Access file named Exp19_Access_Ch8_Cap_Registry. Grader has automatically added   your last name to the beginning of the filename. Save the file to the   location where you are storing your files.

 

You   will add a hyperlink field to the Manufacturer table to store each company’s   website address.
 

  Create a new field in the Manufacturer table after RlMfgCode named Website with the Hyperlink data type. Save the   table.

 

Switch   to Datasheet view, add the website https://www.spode.co.uk   to the Spode China record (11).

 

Add   https://www.wedgwood.com to the Wedgwood China record (15).   Click each link to make sure it launches a browser and locates the   appropriate website. Close the table.

 

You   will add an attachment field to the Employees table to store the employees’   performance reviews and photos.
 

  Create a new field in the Employees table after HireDate named EmployeeFiles with the Attachment data type. Save   the table.

 
Switch   to Datasheet view and locate the record for UserID 81094880. Add the downloaded Word document   named 81094880 x and the picture   file named 81094880 to the   EmployeeFiles field.Save the table.
 

Create   a basic form based on the Employees table; the form will open in Layout view.   For UserID 81094880, (record 1), click the Word icon and click the Forward   arrow on the Attachment toolbar to display the Word document and the   picture file. Save the form as Employees.   Close the form and the table.

 

You   want to determine current sales for a specific product line. You will filter   the Revenue Query to locate records and export the records to Excel and Word.   You will also export inventory records to create a report in PDF format.
 

  Open the Revenue Query. Use Filter by Selection to display records in the   Alias column where the value equals Waterford   Crystal. Export the filtered records to an Excel file. Save the file as a08c1Crystal_LastFirst. Do not save the export steps.

 

Hide   the ProdCategoryID, DESCR, and Alias fields from the results in the Revenue Query. Export the   same filtered records to a Word file. Open the destination file after the   export operation is complete. On the Layout tab, change the orientation of   the document to Landscape. Press ENTER   one time and add the title Waterford Crystal   Orders   to the Word file. Format the title as bold and center aligned. Save the file   as a Word document with the name a08c1Crystal_LastFirst.   Close the document and exit Word. Do not save the export steps. Save and   close the filtered Revenue Query.

 

Use   Filter by Selection to display records in the Inventory table where the   OnHandQty value equals 0 (five   records will display). Export the records to a PDF document. Save the file as   a08cInventory_LastFirst. Close the PDF reader program. Do not   save the export steps. Save and close the filtered Inventory table.

 

You   will import new customer records from Excel.
 

  Open the a08c1Customers.xlsx   workbook, examine the Customers1 worksheet, and then close the workbook.   Create a linked table in the database by importing the workbook named a08c1Customers.xlsx. Use the first row   of the Customers1 worksheet as column headings and accept all other default   options.

 

You   will also import additional customer records from an Access database.
 

  Open the a08c1Customers database,   examine the Customers2 table, and then close the database. Create a linked   table in the database by importing the Customers2 table from the database   named a08c1Customers.

 

You   will import additional customer records from a text file.
 

  Open the a08c1Textcust.csv text   file, examine the content, and then close the file. Create a table in the   database by importing the text file named a08c1Textcust.csv.   Use the first row of the file as field names, CustomerNum as the primary key,   and name the table Customers Text.   Accept all other default options.

 

Append   the linked customer records to the original Customer table in the database.   Append the 32 records from Customers1 and the 36 records from Customers2.   Open the Customer table to view the appended records. Close the Customer   table.

 

Close   all database objects. Close the database and then exit Access. Submit the   database as directed.

Papa_Exp19_Access_Ch8_Cap_Registry.accdb

CustomerNum
LastName
FirstName
BillingAddress
ShippingAddress
City
State
PostalCode
Phone
mSysRowId

0510050
Jeffries
Luke
4337 NANTUCKET DRIVE NW
2714 VON THURINGER CT
GREENSBORO
NC
27455-1509
3.362187311E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0510350
Strader
Cathy
1257 TULA LAMBERT RD
517 SOUTH 3RD AVENUE
WILMINGTON
NC
28403
9.103956053E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0510850
Ormsby
Hank
606 17TH AVENUE DR SE
403 THE CAPE BLVD.
FARMVILLE
NC
27828
2.527536988E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0510950
Blanchard
Walter
103 MEADOWGLADES LN
4126 BARRETT DR.
WILMINGTON
NC
28412
9.103929761E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0512950
Moyers
Jane
4451 SHIMPOCK ROAD
2867 TREESTEAD CIRCLE
GREENSBORO
NC
27410-8312
3.366681063E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0513350
Ritzema
Doris
710 DARWIN DRIVE
4632 LONG LEAF HILLS DR
CLEARWATER
FL
34624
8.135311845E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0514450
Moyers
Jane
4451 SHIMPOCK ROAD
2856 PARK PL
GREENSBORO
NC
27410-8312
3.366681063E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0515050
Lee
Kathy
2109 B HARKEY AVE.
1200 WOODACRE CIRCLE
RALEIGH
NC
27614
9.096766373E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0516650
Amdahl
Rammy
5001 BRENWOOD CT
3116 LANTERN WAY
GREENSBORO
NC
27409
3.366680262E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0519250
Oates
Helen
6840 THAMES DR
4414 DRIFTWOOD DR
CONCORD
NC
28027
7.04786861E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0521850
Ketner
Leonard
1236 TOMMIES DRIVE
5105 HUNTINGDON DR
WILMINGTON
NC
28403
9.103933441E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0521950
Gergens
Phyllis
3600 OPEN SIGHT COURT
212 DAVIS ST
KANNAPOLIS
NC
28083
7.049328212E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0542850
Lewis
Karen
PO BOX 123
8837 CAMPFIRE TR
BROWNS SUMMIT
NC
27214
3.366570115E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0546950
Sink
Dale
5201 FIELDBROOK DR
3400 STALLION COURT
GREENSBORO
NC
27406
3.366740627E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0553950
Wessell
Becky
635 ISLAND DRIVE
4215 BRINGLE FERRY ROAD
DALLAS
TX
75231-4016
2.143492669E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0571350
Wertz
Becky
7753 ALEXANDER RD #6
502 N FRANKLIN ST
CHARLOTTE
NC
28215
7.045363158E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0578850
Donohoe
S Suzanne
1018 WENTWORTH DR.
4101 PALMETTO PL
WILMINGTON
NC
28412-0976
9.103950765E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0579550
Peterson
George
9228 LIGON CT
5905 SUNCREEK CT
CANTON
GA
30114-4509
7.044362517E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0588050
Jackson
Lynn
1506 SCALES ST
5906 MARSHBANK LANE
SUMMERFIELD
NC
27358
3.366440157E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0598050
Wessenauer
Becky
6340 STAPLETON DRIVE
421 BLUE ROCK DR
DALLAS
TX
75231-4016
2.143492669E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0598150
Steffen
Chip
703 SOUTHERN CHARM DR
4524 VITEX STREET
CONCORD
NC
28025
7.047864701E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

0599950
Amerson
Paul
5001 KOREM DRIVE
312 BROOK STREET
GREENSBORO
NC
27409
3.366680262E9
fUtsK8C07senNwvObfzIkVq8wI1gXnjGprCDhoQZ2fw=-~DSP1R8rDZ/bFBeP4We8XGA==

TitleID
Description
mSysRowId

0610465
Showroom Assistant Trainee
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0610466
Showroom Assistant
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0614066
Supervisor, Sales
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

062366
Coordinator, Call Collects
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0626266
Sales Associate 1
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0628866
Showroom Sales Associate
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0629066
Supervisor, Showroom
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

063566
Customer Service Representative
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0648266
Internet Services Associate 1
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0648366
Call Center Administrator
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0649065
Online Auctions Trainee
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0649066
Online Auctions Specialist
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0652066
Inv Customer Service Rep 1
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0653366
Shelver
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0657666
Lead, Internet Services
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0660466
Mail Processing Technician
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0663766
Lead, Showroom Sales
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0664966
Customer Service Representative-Online Auctions
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0666566
Order/Report Care Specialist
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

06666
Administrative Assistant
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0666766
Manager, Call Center
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0667066
Telephone Sales Trainer
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0669066
VP, Customer Service Operations
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0671166
Chairman and CEO
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

0671466
Executive Assistant, Senior VP’s & CIO
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

067466
Manager, Showroom
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

068765
Purchasing Agent Trainee
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

068766
Purchasing Agent
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

069266
Returns Specialist
XVRo29HIc5sLVQbqeAob/dBu7OX0ZXb5ghn6rRhgXi4=-~7wAZnN1PWKQ7a5QiOwLapw==

UserID
TitleID
LastName
FirstName
Address
City
State
PostalCode
Phone
HireDate
TermDate
TermReason

81094880
0649066
Cox
Tim
1012 TRADERS TRAIL
SAN FRANCISCO
CA
94116-3039
9195671893
2009-01-31

81095180
0648266
Bowman
Jeanette
1018 WENTWORTH DR.
SALISBURY
NC
28146-8856
9198512318
2006-04-16

81105880
069266
Rhynes
Judy
100 CIRCLEVIEW DR
STEAMBOAT SPRING
CO
80488-1895
9103926711
2004-12-12

81112780
0626266
Bolick
Marion
1101 CENTENNARY DRIVE
RALEIGH
NC
27609-3625
9198472095
2011-02-09

81115580
0626266
Bailey
Ray
1102 KINDLEY CT
RALEIGH
NC
27609-2884
9198705744
2014-03-06

81117480
0626266
Lynn
Susan
11001 W DEKALB PL
RALEIGH
NC
27609-4422
9197820804
2011-07-13

81125580
06666
Waters
Susan
101 COLCHIS COURT
SOUTHPORT
NC
28461
9102536345
2008-02-28

81129580
0667066
Galloway
Judy
10008 WHITESTONE RD
SOUTHPORT
NC
28461
9104576031
2011-08-12

81131080
0626266
Chut Jr.
Carol
1100 GLENCASTLE WAY
RALEIGH
NC
27609-5578
9197826075
2013-07-23

81133680
0626266
Chesson
Edna
1100 GLENCASTLE WAY
RALEIGH
NC
27609-5578
9197826075
2011-05-07

81137380
0610466
Myers
Carol
1108 BANCROFT DR
RALEIGH
NC
27604-3363
9198727659
2015-06-21

81140980
0652066
Cowan
David
1012 TRADERS TRAIL
SAN FRANCISCO
CA
94116-3039
9198469158
2012-08-11

81148980
0626266
Williams
Janet
110 WEST A STREET
RALEIGH
NC
27612-6543
9197874242
2008-06-30

814780
063566
Alphin
Bonnie
103 MEADOWGLADES LN
RODANTHE
NC
27968
7037775229
2013-03-22

814980
0626266
Behrend
Dottie
11 ROBERT E LEE DR
RALEIGH
NC
27613-9652
9198467704
2013-03-22

817580
0626266
Pence
Lisa
109 DEER COVE RD
RALEIGH
NC
27614-9020
9198460562
2018-03-06

836880
0648266
Abdel-Hameed
Nancy
102 DEER SPRING LN
SALISBURY
NC
28146
7048552579
2013-08-11

8728480
0614066
Hartis
Keith
1105 CASTALIA DR
RALEIGH
NC
27606-2656
9197724131
2012-08-12

8772880
0614066
Hudspeth
Marianne
11029 SOUTHWALK LN
RALEIGH
NC
27607-6700
9198348710
2011-10-30

PatID
SKU
PieceName
RlPceCode
OnHandQty
Retail
ProdCategoryID
mSysRowId

031063830
2117195120
MAGNIFYING GLASS/STERLING HDL
MGS
59.0
19.995
3.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

032478530
213619420
CUP AND SAUCER SET (FLAT)
CSFL
670.0
4.995
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

032478530
213619620
PLATE-DINNER
DP
748.0
8.995
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

032478530
213620020
SAUCER ONLY
SAU
83.0
1.495
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

032478530
213624320
PLATTER-OVAL SERVING
PL14
60.0
19.995
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

032478530
213629320
VEGETABLE-ROUND
RV9
62.0
12.995
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

032551630
214373520
CHEESE & CRACKER SET
CCHC
58.0
32.975
2.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

032551630
214376520
PLATE-DINNER
DP
204.0
19.995
2.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

033079630
217509120
SPOON-SOUP/ROUND BOWL (C)
CSS
122.0
20.995
3.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

033079630
217511220
BUTTER SPREADER/FLAT HANDLE
BSF
204.0
13.495
3.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

033079630
217535520
KNIFE-NEW FRENCH/HOLLOW
K2NF
66.0
23.995
3.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

033116630
218135220
SPOON-TEASPOON
TS
96.0
7.995
3.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

033116630
218142120
TABLESPOON (SERVING SPOON)
TAS
67.0
39.975
3.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

031446130
2181758520
BOWL-SOUP/CEREAL
SOCE
206.0
2.995
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

031109830
2193049920
PLATE-LUNCHEON
LP
166.0
19.995
2.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

033301130
219719120
CUP AND SAUCER SET (FLAT)
CSFL
298.0
22.495
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

033301130
219719820
SAUCER ONLY
SAU
136.0
7.495
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

032478530
2243615220
VEGETABLE-OVAL DIVIDED 10″
ODV10
111.0
15.995
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

034640230
228500120
PLATTER-OVAL SERVING
PL11
190.0
28.495
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

033079630
2347373220
FORK-COCKTAIL/SEAFOOD
CF
113.0
10.995
3.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

033079630
2349395420
KNIFE-BLUNT/HOLLOW-BOLSTER
K1BB
65.0
14.995
3.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

039650530
2382241720
LEMON DISH
LD
58.0
59.98
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

031109630
2446403920
BUTTER-COVERED/QUARTER POUND
CBD4
60.0
54.975
2.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

033079630
2539314520
LADLE-MAYONNAISE
LAMA
0.0
44.975
3.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

031446130
2541350720
DEVILED EGG & COV BOWL-SCULPTD
EGGPB
0.0
7.495
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

039569030
2544208920
CANDLESTICK – 6″
CNSS6
58.0
20.0
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

038497930
2548636920
VASE-CHELSEA W/LID
VACH
60.0
39.975
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

032551630
2553736620
CHAMPAGNE/TALL SHERBET
SM2
0.0
4.995
2.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

033116630
2574819020
SPOON-INFANT FEEDING HC
INSR
0.0
13.495
3.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

038497930
261862920
SUGAR BOWL LID ONLY
SUL
59.0
17.995
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

039650530
268651220
PLATTER-OVAL SERVING
PL12
60.0
199.98
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

039650530
268651920
TUREEN-UNDERPLATE ONLY
TUP
0.0
249.98
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

039803030
269388020
SUGAR BOWL AND LID
SU
80.0
19.995
1.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

031109630
276454220
CLARET WINE
CLA
1062.0
19.995
2.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

031109630
276457220
SALT & PEPPER SET
CSAP
71.0
54.975
2.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

031109630
276457620
SHOT GLASS
CSH
74.0
22.495
2.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

031109630
276459820
DECANTER-WINE WITH/STOPPER
CDECWI
78.0
109.975
2.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

033079630
295646620
SPOON-BON BON
BONS
61.0
19.995
3.0
xq12ldKCyqqWhBqvdGIKWSrqO36Lhs2vAeqNEZVKbK4=-~3KTKK6s6TPthovTE4UTFhQ==

MfgID
Alias
RlMfgCode

800338.0
DANSK CHINA
DAN

800460.0
FRANCISCAN CHINA
FN

800470.0
FOSTORIA
FOS

800546.0
GORHAM SILVER
GS

800552.0
HAVILAND
H

800661.0
JOHNSON BROTHERS
JB

800712.0
LENOX CHINA
L

800890.0
ONEIDA/HEIRLOOM SLVR
OHS

800917.0
PFALTZGRAFF CHINA
PFA

801049.0
ROYAL ALBERT CHINA
ROA

801190.0
SPODE CHINA
SP

801210.0
STAFFORDSHIRE
STF

801305.0
TOWLE
TWS

801352.0
WATERFORD CRYSTAL
WAT

801403.0
WEDGWOOD CHINA
WW

ID
mSysRowId

1
NgPC4C+47lXv7XQNWp1sBxkR6B62EM+t64tlpsKJF+s=-~sbGWfI9SCcSfTS2aSnrYDA==

OrderID
CustomerNum
OrderDate
UserID
mSysRowId

44745937840
0588050
2019-05-30
81129580
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44745939840
0510850
2019-05-30
81137380
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44745940840
0579550
2019-05-30
814980
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44745951140
0598050
2019-05-30
81117480
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44745954740
0553950
2019-05-30
814780
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44745971040
0510350
2019-05-30
81095180
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44745985940
0510850
2019-05-30
836880
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44748453740
0542850
2019-06-18
81112780
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44748480440
0571350
2019-06-18
81137380
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44748493240
0515050
2019-06-18
81125580
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44748496240
0510050
2019-06-19
81105880
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44748498640
0516650
2019-06-19
817580
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44748505740
0599950
2019-06-19
81125580
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44748508640
0514450
2019-06-19
81133680
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44748528340
0512950
2019-06-19
81125580
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44748532640
0546950
2019-06-19
81115580
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44750449840
0598150
2019-07-04
81133680
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44750466240
0519250
2019-07-04
81125580
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44751104940
0521950
2019-07-08
81148980
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44751181140
0578850
2019-07-09
81131080
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44751182040
0510850
2019-07-09
81105880
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44753104040
0510850
2019-07-24
8728480
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44753105640
0510950
2019-07-24
8772880
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44753129140
0510950
2019-07-24
81125580
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44753140840
0510350
2019-07-24
81125580
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44753146140
0510950
2019-07-24
81117480
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44753162640
0510950
2019-07-24
81125580
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44753177640
0513350
2019-07-25
81140980
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

44753203540
0521850
2019-07-25
81094880
rOqt2b2BvjqkxF/u7pfEeqPEkzSb4Zn1ohVMaT/yaDc=-~74YZmY1zDd9jlHkWnA4UhQ==

OrderID
LineNum
Qty
Price
SKU
ProdCategoryID
mSysRowId

44745940840
1.0
1.0
19.995
269388020
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44745954740
1.0
2.0
8.995
213619620
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44748496240
1.0
1.0
7.495
2541350720
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44748498640
1.0
1.0
249.975
268651920
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44748498640
2.0
1.0
59.975
2382241720
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44748498640
3.0
1.0
161.98
268651220
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44748505740
1.0
1.0
2.995
2181758520
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44748528340
1.0
1.0
25.645
228500120
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44751182040
1.0
1.0
7.495
219719820
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44753104040
1.0
2.0
5.995
2347373220
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44753104040
2.0
2.0
4.495
2349395420
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44753104040
3.0
1.0
15.995
2243615220
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44753104040
4.0
1.0
12.995
213629320
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44753104040
5.0
1.0
19.995
213624320
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44753129140
1.0
2.0
4.995
213619420
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44753146140
1.0
1.0
17.995
261862920
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44753177640
1.0
2.0
21.37
219719120
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44753203540
1.0
1.0
21.115
2349395420
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44753203540
2.0
2.0
1.495
213620020
1.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44745939840
1.0
8.0
22.495
276457620
2.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44745971040
1.0
1.0
19.995
276454220
2.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44748453740
1.0
1.0
109.975
276459820
2.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44748480440
1.0
1.0
32.975
214373520
2.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44748532640
1.0
1.0
54.975
276457220
2.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44750449840
2.0
2.0
18.995
2193049920
2.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44751181140
3.0
1.0
54.975
276457220
2.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44751181140
4.0
1.0
54.975
2446403920
2.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44753105640
1.0
28.0
4.995
2553736620
2.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44753162640
1.0
1.0
19.995
214376520
2.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44745937840
1.0
1.0
16.995
295646620
3.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44745937840
2.0
1.0
44.975
2539314520
3.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44745951140
1.0
1.0
23.995
217535520
3.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44745985940
1.0
1.0
19.995
2117195120
3.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44748493240
1.0
1.0
39.975
218142120
3.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44748508640
1.0
2.0
20.995
217509120
3.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44750466240
1.0
1.0
13.495
2574819020
3.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44750466240
2.0
1.0
4.995
2544208920
3.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44750466240
3.0
1.0
7.995
2548636920
3.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44750466240
4.0
1.0
7.495
2548636920
3.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44750466240
5.0
1.0
7.495
2548636920
3.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44751104940
1.0
4.0
13.495
217511220
3.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

44753140840
1.0
8.0
7.995
218135220
3.0
YWo2qIEp5ZTGJbUoVvBMbHJTCgWNeWmgeF66l2tbefw=-~cF31dlNYha+5XdRSa+v5YA==

PatID
LongPatName
DESCR
RlPatCode
ProdCategoryID
MfgID
mSysRowId

031063830
FRENCH PROVINCIAL(STERLING,1948,NO MONO)
STERLING, 1948, NO MONOGRAMS
TWSFRP
3.0
801305.0

031109630
LISMORE
VERTICAL CUT ON BOWL MULTISIDED STEM
WATLIS
2.0
801352.0

031109830
MILLENNIUM SERIES
DIFFERENT DESIGN CUTS
WATMIL
2.0
801352.0

031144030
STRAWBERRY & VINE (BONE)
ALL WHITE, RAISED BERRIES/LEAVES
WW STV
1.0
801403.0

031446130
SUMMER BREEZE
BLUE FLOWERS, YELLOW PLAID & TRELLIS
PFASUB
1.0
800917.0

031901730
BISSERUP WHITE
PORTUGAL, BISTRO, SOLID WHITE
DANBIW
1.0
800338.0

032103330
BING
RED CHERRIES, RED BANDS
DANBIN
1.0
800338.0

032478530
DESERT ROSE (USA BACKSTAMP)
USA BACKSTAMP, PINK ROSES
FN DERO
1.0
800460.0

032551630
AMERICAN-CLEAR (STEM #2056)
STEM #2056, CLEAR, ALSO “EARLYAMERICAN”
FOSAME
2.0
800470.0

033079630
CHANTILLY [F1](STR,1895,LION/ANC/G,NOMO)
STRL,1895-1950,LION/ANCHOR/G,NO MONOS
GS CHA
3.0
800546.0

033116630
SUMMER BREEZE
BLUE FLOWERS
PFASUB
1.0
800917.0

033301130
ROSALINDE (NEW YORK)
PINK,LAVENDER&WHITE FLOWERS,SCALLOPED
H ROSN
1.0
800552.0

034640230
VICTORIAN CHRISTMAS
CHRISTMAS TREE HOLLY & RIBBONS
JB VICH
1.0
800661.0

034984230
AMERICAN-CLEAR (STEM #2056)
STEM #2056, CLEAR, ALSO “EARLYAMERICAN”
FOSAME
2.0
800470.0

037255330
DAMASK ROSE (STERLING,1946,NO MONOGRAMS)
STERLING, 1946, NO MONOGRAMS
OHSDAR
3.0
800890.0

037345730
VENETIA (STNLS, GLOSSY BOWL)
STAINLESS,COMMUNITY,BURNISHED,GLOSSYBOWL
OHSVEN
3.0
800890.0

038497930
OLD COUNTRY ROSES
MONTROSE SHAPE, RED & YELLOW ROSES
ROAOLCR
1.0
801049.0

039569030
CHRISTMAS TREE-GREEN TRIM
NEWER BACKSTAMP,GREEN TRIM,TREE,TOYS
SP CHT
1.0
801190.0

039650530
STAFFORD FLOWERS (BONE)
BONE,VARIOUS FLOWERS,GOLD SCROLLS
SP STF
1.0
801190.0

039803030
LIBERTY BLUE
BLUE&WHITE FLORAL RIM,SCENE IN CENTER
STFLIB
1.0
801210.0

SELECT Employees.LastName, Employees.FirstName, [Order Item].Qty, [Order Item].Price, Pattern.LongPatName, [Order Item].ProdCategoryID, [Employee Titles].Description, Pattern.DESCR, Customer.State, [Order Data].OrderDate, Manufacturer.Alias, [Price]*[Qty] AS Revenue
FROM (Manufacturer INNER JOIN Pattern ON Manufacturer.MfgID = Pattern.MfgID) INNER JOIN ((([Employee Titles] INNER JOIN Employees ON [Employee Titles].TitleID = Employees.TitleID) INNER JOIN (Customer INNER JOIN [Order Data] ON Customer.CustomerNum = [Order Data].CustomerNum) ON Employees.UserID = [Order Data].UserID) INNER JOIN (Inventory INNER JOIN [Order Item] ON Inventory.SKU = [Order Item].SKU) ON [Order Data].OrderID = [Order Item].OrderID) ON Pattern.PatID = Inventory.PatID;

EX19_AC_CH08_GRADER_CAP_HW_Instructions x
Grader – Instructions Access 2019 Project

Exp19_Access_Ch08_Capstone – Registry 1.0

Project Description:

You work as a database manager at Virtual Registry, Inc. This firm specializes in supplying china, crystal, silver, and collectible gifts online. You will add a hyperlink field that will store a URL for each manufacture’s website. The HR department manager wants to store a photo and the most recent performance review for each employee. You also export data from the database to three different formats. Finally, you import information from Excel, Access, and text files.

Steps to Perform:

Step

Instructions

Points Possible

1

Start Access. Open the downloaded Access file named
Exp19_Access_Ch8_Cap_Registry. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.

0

2

You will add a hyperlink field to the Manufacturer table to store each company’s website address.
Create a new field in the Manufacturer table after RlMfgCode named
Website with the Hyperlink data type. Save the table.

12

3

Switch to Datasheet view, add the website
https://www.spode.co.uk to the Spode China record (11).

6

4

Add
https://www.wedgwood.com to the Wedgwood China record (15). Click each link to make sure it launches a browser and locates the appropriate website. Close the table.

6

5

You will add an attachment field to the Employees table to store the employees’ performance reviews and photos.
Create a new field in the Employees table after HireDate named
EmployeeFiles with the Attachment data type. Save the table.

12

6

Switch to Datasheet view and locate the record for UserID
81094880. Add the downloaded Word document named
81094880 x and the picture file named
81094880 to the EmployeeFiles field.Save the table.

12

7

Create a basic form based on the Employees table; the form will open in Layout view. For UserID 81094880, (record 1), click the
Word icon and click the
Forward arrow on the Attachment toolbar to display the Word document and the picture file. Save the form as
Employees. Close the form and the table.

9

8

You want to determine current sales for a specific product line. You will filter the Revenue Query to locate records and export the records to Excel and Word. You will also export inventory records to create a report in PDF format.
Open the Revenue Query. Use Filter by Selection to display records in the Alias column where the value equals
Waterford Crystal. Export the filtered records to an Excel file. Save the file as
a08c1Crystal_LastFirst. Do not save the export steps.

4

9

Hide the
ProdCategoryID,
DESCR, and
Alias fields from the results in the Revenue Query. Export the same filtered records to a Word file. Open the destination file after the export operation is complete. On the Layout tab, change the orientation of the document to Landscape. Press
ENTER one time and add the title
Waterford Crystal Orders to the Word file. Format the title as bold and center aligned. Save the file as a Word document with the name
a08c1Crystal_LastFirst. Close the document and exit Word. Do not save the export steps. Save and close the filtered Revenue Query.

3

10

Use Filter by Selection to display records in the Inventory table where the OnHandQty value equals
0 (five records will display). Export the records to a PDF document. Save the file as
a08cInventory_LastFirst. Close the PDF reader program. Do not save the export steps. Save and close the filtered Inventory table.

4

11

You will import new customer records from Excel.
Open the
a08c1Customers.xlsx workbook, examine the Customers1 worksheet, and then close the workbook. Create a linked table in the database by importing the workbook named
a08c1Customers.xlsx. Use the first row of the Customers1 worksheet as column headings and accept all other default options.

10

12

You will also import additional customer records from an Access database.
Open the
a08c1Customers database, examine the Customers2 table, and then close the database. Create a linked table in the database by importing the Customers2 table from the database named
a08c1Customers.

10

13

You will import additional customer records from a text file.
Open the
a08c1Textcust.csv text file, examine the content, and then close the file. Create a table in the database by importing the text file named
a08c1Textcust.csv. Use the first row of the file as field names, CustomerNum as the primary key, and name the table
Customers Text. Accept all other default options.

10

14

Append the linked customer records to the original Customer table in the database. Append the 32 records from Customers1 and the 36 records from Customers2. Open the Customer table to view the appended records. Close the Customer table.

2

15

Close all database objects. Close the database and then exit Access. Submit the database as directed.

0

Total Points

100

Created On: 07/11/2019 1 Exp19_Access_Ch08_Capstone – Registry 1.0

81094880

a08c1Customers.accdb

CustomerNum
LastName
FirstName
BillingAddress
ShippingAddress
City
State
PostalCode
Phone

514655
Guidry
Pat
PO BOX 2698
9009 NEW OAK LANE
BOLIVIA
NC
28422
9.103926711E9

515050
Nemoseck
Jack
814 PEBBLEBROOK DR
513 SIERRA DRIVE
CHARLOTTE
NC
28210
7.045197828E9

515051
Priser
Esther
4512 SOMERSWORTH DR
2909 LEGARE CT
GREENSBORO
NC
27410-4986
3.368559102E9

515154
Hardie
Nat
12 NORTH 6TH ST
4906 QUAIL HOLLOW DRIVE
WILMINGTON
NC
28406
9.103951401E9

515855
Koceja
Kris
4337 NANTUCKET DRIVE NW
2715 ODDIE ROAD
GREENSBORO
NC
27438-8072
3.365460082E9

516151
Keyes
Leo
4317 GALLATREE LN
2710 LA DUELA LANE
GREENVILLE
NC
21858
2.527563119E9

516152
Ross
Don
361 E. PALOMINO CT.
2128 SOUTH NC 61
KANNAPOLIS
NC
28083
7.049332957E9

516153
Sloop
Craig
141 CHEYENNE TR
5608 WESLO WILLOW CIR – #318
VASS
NC
28394
9.102454718E9

516355
Blackwelder
Wanda
7821 BRECKON WAY
504 FENMARK PL
CHARLOTTE
NC
28213
7.045971311E9

516356
Haskins
Nancy
3601 BROOKHAVEN CT
212 JEB STUART DR
KANNAPOLIS
NC
28083
7.049388285E9

516654
Wines
Anne
302 VAN BUREN ST
1700 G-1 N ELM ST
OAK RIDGE
NC
27310
3.366432189E9

516952
Brandon
Tom
3271 POND RD
201 GAIL RIDGE LN
LENOIR
NC
28645-4431
9.103926711E9

517252
Noel
Hope
3312 EAST ANNALEY DRIVE
2018 TOWNVIEW DRIVE
LEESBURG
FL
34748
3.523143596E9

518056
Lapsley
Kathy
5665 STEVENS DR.
3700 WEDGEDALE PL
FREEHOLD
NJ
07728
7.312940226E9

518155
Hofstedder
Mary
309 WYOMING DR
1808 WOOD HENGE DR
MOUNT HOLLY
NC
28120-1682
7.048275593E9

518253
Houser
Mark
6800 PLEASANT DRIVE
440 DOGWOOD RD
CONCORD
NC
28027
7.04721521E9

518255
Collins
Stan
412 EAST FOX ROAD
2513 NEWINGTON CT
HIGH POINT
NC
27260-2519
3.366334724E9

518951
Phelps
Gary
5794 HWY 150 EAST
3806 BON-REA DRIVE
FLEETWOOD
NC
28626
3.368778968E9

519051
Schmidt
Deborah
3906 RED CHIEF ST
229 N LINCOLN ST
JOHNSTON
IA
50131-2959
3.362826056E9

519052
Holbrook
Mary
101 COLCHIS COURT
404 MODENA DR
WINSTON-SALEM
NC
27106
3.367681159E9

519653
Walls
Bill
8134 NEW TOWN RD
513 DEBRA CIRCLE
CHARLOTTE
NC
28211
7.043641311E9

519851
Bohlken
Virginia
9421 OWLS NEST DR
6017 CALEDONIA ST
BURLINGTON
NC
27215
3.362270804E9

519852
Linz
Julien
477 WOODBURY COURT
302 W. GREENWAY DR
GREENSBORO
NC
27455
3.365458213E9

519853
Browder
Tim
3 FERN BLUFF CT
1610 HARPER SPRING DR
PLEASANT GARDEN
NC
27313
3.366761356E9

519854
Galvin
Randy
414 EDGEWOOD CIRCLE
2519 WESTMORELAND DR.
HICKORY
NC
28601
7.042565866E9

519951
Hartsell
Nancy
501 Albertson Rd. Trailer #27
314 WILLIAM STREET
GREENSBORO
NC
27408
3.362824483E9

519952
Peterson
Gayle
4320 OMNI PL
2710 LA DUELA LANE
GREENSBORO
NC
27455-2434
3.365455926E9

520454
Kinlaw
Larry
12410 MADELEY LN
5113 NORTH OAKS DRIVE
WILMINGTON
NC
28403
9.103926171E9

520754
Messer
Jerry
4550 S. HWY 62
2948 FOREST CIR
GREENSBORO
NC
27408-2828
3.362822177E9

520855
Brett
Tim
4312 PRINCETON AVE
2708 MOORSFIELD CT
GREENVILLE
NC
27858
2.527563905E9

520955
Hartsell
Nancy
501 PEELE ST
3140 EDSEL PLACE
GREENSBORO
NC
27408
3.362824483E9

520956
Moore
Janet
608 COBURN ST
403 THE CAPE BLVD.
FARIBAULT
MN
55021-9237
5.073344894E9

520958
Lingle
K.A.
5712 CRUTHFIELD RD
3721 DUXFORD DRIVE
FORT DODGE
IA
50501-8473
5.155766947E9

520959
Crouse
Sheila
613 SPARTANBURG AVE.
4101 PALMETTO PL
ELFRIDA
AZ
85610
5.206421421E9

520962
Peacock
Giles
3522 BETHEL RD
2105 N. U. ROAD
KERNERSVILLE
NC
27284
3.369938934E9

520963
Southern
Cindy
3522 BETHEL RD
2109 B HARKEY AVE.
KERNERSVILLE
NC
27284
3.369960804E9

a08c1Customers.xlsx

Customers1

CustomerNum
LastName
FirstName
BillingAddress
ShippingAddress
City
State
PostalCode
Phone

611004
SCHULL
Debbie
401 1/2 CENTER ST
2309 BRACYRIDGE RD
INDIAN TRAIL
NC
28079
7048827566

611005
McDaniel
Jo Ann
PO BOX 19430
89 WOODLAND ROAD
BREVARD
NC
28712
7048838817

615051
Rose
Don
4943 WOODS EDGE ROAD
3105 BARDWELL ROAD
GREENSBORO
NC
27410
3366640617

620965
Collins
Stella
3312 EAST ANNALEY DRIVE
202 GLENTOWER DR
LEESBURG
VA
20176
7037714824

620966
Hart
Nancy
15812 HAMPTON FALLS RD
101 CORBEL PLACE
SMYRNA
TN
37167
6154595515

621450
Brady
Tom
609 DOVE CT
404 PINECROFT DR
ELON
NC
27244
3365849684

621650
Schoenberg
Debbie
3540 BARRON WAY
2110 ROBINHOOD RD
KANNAPOLIS
NC
28081-9071
7049325039

621850
JACOBSEN
Lynda
1708 HILLANDALE RD
105 PINE CONE DR
ROCKLEDGE
FL
32955
4076367540

628350
Hunter
Marcia
940 JONES WYND
5916 PINE TREE CT
BURLINGTON
NC
27217
3362272804

628850
Rehbein
Ed
7213 BEAVERWOOD DR
4805 SWEETBRIAR RD.
CHARLOTTE
NC
28277-2211
7045418503

646750
Misenheimer
Jean
11307 BALDY HILL ROAD
4703 FREYS HILL CT
WILMINGTON
NC
28409
9103950745

646755
Arthofer
LARRY
3317 TRENTON RD
202 KIRKLAND DR
LEAGUE CITY
TX
77573
7133343990

646950
Occhetti
Helen
4914 COTTONWOOD
309 WYOMING DR NW
GREENSBORO
NC
27410
3362994691

647950
Stowell
Cathy
500 BLUE ROCK DR
3106 KESWICK DRIVE
GREENSBORO
NC
27410
3362924971

650351
Kettle
Leon
414 BLACKBEARD ROAD
2519 TIMBER LANE
HICKORY
NC
28602-8325
3365654776

658350
Christ
Susan
508 COLE ST.
3220 HUNTLEIGH DR
GREENSBORO
NC
27407
3362996036

678150
LeBaube
Kathy
491 WOODPECKER PARKWAY
308 LARRY DRIVE
GREENSBORO
NC
27410
3368521700

678850
Rudisill
Dick
3614 KIRBY SMITH DR
215 CALHOUN DR
KANNAPOLIS
NC
28083
7049329145

679550
Boynton
Tom
6335 ANDERLAND RD
4209 OMNI PLACE
DALLAS
TX
75234-2237
2142434235

680050
Soderston
Clarence
PO BOX 206
8800 WEATHERSFIELD CT
BURLINGTON
NC
27215
3362294649

680054
Sink
Dan
721 WELDON LANE
477 WOODBURY COURT
CHOCOWINITY
NC
27817
2529741736

680350
Northrup
Herbert
512 MEADOWOOD DRIVE
3300 CHISTOW RD
GREENSBORO
NC
27407
3363171829

681250
Dunston
Rosie
14 GREENHAVEN BAY
5425 DANA DR APT B
WALESKA
GA
30183
7044797126

690450
Tucker
Boyd
7002 KEY POINT DR
4451 SHIMPOCK ROAD
CONCORD
NC
28027
7047845616

691050
Stallings
Chris
6313 BEACON HILL DR
4201 N. MAIN ST APT #206
DAVIDSON
NC
28036
7048954568

694850
McKinnon
Jim
P. O. BOX 472
8600 HARBOR DR
BURLINGTON
NC
27215
3362262788

695050
Harvey
Nancy
3601 MOSSBOROUGH DR
2123 CHILDERS DR.
KANNAPOLIS
NC
28083
7049388285

698250
Hayes
Minerva
6521 RED MAPLE DR
4304 FORWALT PLACE
CORNELIUS
NC
28031
7048920583

698251
de Leon
Say
9426 FAIRMEAD DR
814 PEBBLEBROOK DR
BURLINGTON
NC
27215
3362991750

699150
Taipale
Carol
813 BERWYN WAY
512 SILVER ASPEN CIRCLE
CHARLOTTE
NC
28211
7043664902

699550
Oliphant
Hazel
525 EAST JONES STREET
3408 MORNINGSIDE DR
GREENSBORO
NC
27405
3362757291

699650
Shumpert
Danny
805 KATHERINE AVE
509 MILL CREEK CT. APT. C
CHARLOTTE
NC
28213
7045377391

Sheet2

Sheet3

a08c1NewEmployees.xlsx

New Employees

UserID
TitleID
LastName
FirstName
Address
City
State
PostalCode
Phone
HireDate

8965985
0626266
Thomasson
Aaron
5437 PRINCE CHARLES DRIVE
GIBSONVILLE
NC
27215
3365551364
9/3/19

8965990
063566
DePaul
Mason
376C GATE DR.
BURLINGTON
NC
27217
3365555307
11/9/19

8965995
0648266
Scott
Angie
101 BOSTON ST.
SALISBURY
NC
28146-8856
7045559158
9/10/19

a08c1Textcust.csv

CustomerNum
LastName
FirstName
BillingAddress
ShippingAddress
City
State
PostalCode

514253
Hott
Marlene
7344 MAITLAND LN
491 WOODPECKER PARKWAY
CHARLOTTE
NC
28269

514451
Ekas
Ron
1509 BARLEY PL
5914 SHADY GROVE CIRCLE
STORM LAKE
IA
50588

514651
Lomax
Judy
8309 PENNY RD.
5205 HUNTERS TRAIL
CHAPEL HILL
NC
27517-5663

514655
Guidry
Pat
PO BOX 2698
9009 NEW OAK LANE
BOLIVIA
NC
28422

515050
Nemoseck
Jack
814 PEBBLEBROOK DR
513 SIERRA DRIVE
CHARLOTTE
NC
28210

515051
Priser
Esther
4512 SOMERSWORTH DR
2909 LEGARE CT
GREENSBORO
NC
27410-4986

515154
Hardie
Nat
12 NORTH 6TH ST
4906 QUAIL HOLLOW DRIVE
WILMINGTON
NC
28406

515855
Koceja
Kris
4337 NANTUCKET DRIVE NW
2715 ODDIE ROAD
GREENSBORO
NC
27438-8072

516151
Keyes
Leo
4317 GALLATREE LN
2710 LA DUELA LANE
GREENVILLE
NC
21858

516152
Ross
Don
361 E. PALOMINO CT.
2128 SOUTH NC 61
KANNAPOLIS
NC
28083

516153
Sloop
Craig
141 CHEYENNE TR
5608 WESLO WILLOW CIR – #318
VASS
NC
28394

516355
Blackwelder
Wanda
7821 BRECKON WAY
504 FENMARK PL
CHARLOTTE
NC
28213

516356
Haskins
Nancy
3601 BROOKHAVEN CT
212 JEB STUART DR
KANNAPOLIS
NC
28083

516654
Wines
Anne
302 VAN BUREN ST
1700 G-1 N ELM ST
OAK RIDGE
NC
27310

516952
Brandon
Tom
3271 POND RD
201 GAIL RIDGE LN
LENOIR
NC
28645-4431

517252
Noel
Hope
3312 EAST ANNALEY DRIVE
2018 TOWNVIEW DRIVE
LEESBURG
FL
34748

518056
Lapsley
Kathy
5665 STEVENS DR.
3700 WEDGEDALE PL
FREEHOLD
NJ
7728

81094880 x

3

PERFORMANCE ASSESSMENT FORM

Employee: Tim Cox
Department: Online Auctions Specialist

Introduction: This assessment instrument is intended to provide the employee with feedback concerning both general and specific professional skills and competencies. You are asked to be objective and candid in your assessment and to discuss it with the intern. Assessment ratings range from 1 to 5 as follows:

1 Unsatisfactory (Never demonstrates this ability/does not meet expectations)

2 Uncomplimentary (Seldom demonstrates this ability/rarely meets expectations)

3 Fair (Sometimes demonstrates this ability/meets expectations)

4 Commendable (Usually demonstrates this ability/sometimes exceeds expectations)

5 Exceptional (Always demonstrates this ability/consistently exceeds expectations)

If any criteria are not applicable to this performance evaluation, please leave the response blank.

Please do not feel compelled to write comments in each section.

A. Ability to Learn

1. Observes and/or pays attention to others 1 2 3 X 5

2. Asks pertinent and purposeful questions 1 2 3 X 5

3. Seeks out and utilizes appropriate resources 1 2 X 4 5

4. Accepts responsibility for mistakes and learns from experiences 1 2 3 X 5

5. Open to new experiences; takes appropriate risks 1 2 3 X 5

Comments:

You could improve by asking for assistance a little more quickly. It is OK to admit you do not know how to do something

B. Reading/Writing/Computation Skills

1. Reads/comprehends/follows written materials 1 2 3 X 5

2. Communicates ideas and concepts clearly in writing 1 2 3 4 X

3. Works with mathematical procedures appropriate to the job 1 2 3 X 5

Comments:

Please keep up the good work!

C. Listening & Oral Communication Skills

1. Listens to others in an active and attentive manner 1 2 3 X 5

2. Comprehends and follows verbal instructions 1 2 3 X 5

3. Effectively participates in meetings or group settings 1 2 3 4 X

4. Demonstrates effective verbal communication skills 1 2 3 4 X

Comments:

Great!

D. Creative Thinking & Problem Solving Skills

1. Seeks to comprehend and understand the “big picture” 1 2 3 4 5

2. Breaks down complex tasks/problems into manageable pieces 1 2 3 4 5

3. Brainstorms/develops options and ideas 1 2 3 4 5

4. Respects input and ideas from other sources and people 1 2 3 4 5

5. Demonstrates an analytical capacity 1 2 3 4 5

Comments:

NA

E. Professional & Career Development Skills

1. Seeks to understand personal strengths and weaknesses 1 2 3 4 5

2. Exhibits self-motivated approach to work 1 2 3 4 5

3. Demonstrates ability to set appropriate priorities/goals 1 2 3 4 5

4. Exhibits professional behavior and attitude 1 2 3 4 5

5. Manages personal expectations consistent with work role 1 2 3 4 5

6. Shows interest in determining career direction 1 2 3 4 5

Comments:

NA

F. Interpersonal & Teamwork Skills

1. Relates to co-workers effectively 1 2 3 X 5

2. Manages and resolves conflict in an effective manner 1 2 3 X 5

3. Supports and contributes to a team atmosphere 1 2 3 X 5

4. Controls emotions in a manner appropriate for work 1 2 3 4 X

5. Demonstrates assertive but appropriate behavior 1 2 3 4 X

Comments:

Sales associates often ask that you be scheduled to work their shifts.

G. Organizational Effectiveness Skills

1. Seeks to understand and support the organization’s mission/goals 1 2 X 4 5

2. Fits in with the norms and expectations of the organization 1 2 X 4 5

3. Works within appropriate authority and decision-making channels 1 2 3 X 5

4. Demonstrates a sense of responsibility and confidentiality 1 X 3 4 5

5. Interacts effectively and appropriately with supervisor 1 2 X 4 5

Comments:

You need to improve the confidentiality of our customers. If someone tells you that they are in a difficult situation, you should not disclose what was said in the break room.

H. Basic Work Habits

1. Reports to work as scheduled 1 2 3 X 5

2. Is prompt in showing up to work and meetings 1 2 3 4 X

3. Exhibits a positive and constructive attitude 1 2 3 X 5

4. Dress and appearance are appropriate for this organization 1 2 3 X 5

Comments:

I. Character Attributes

1. Brings a sense of values and integrity to the job 1 2 3 4 X

2. Seeks to serve others even at the risk of personal inconvenience 1 2 3 X 5

3. Refrains from gossip/respects the privacy of others 1 2 3 X 5

4. Behaves in an ethical manner 1 2 3 4 X

5. Respects the diversity (religious/cultural/ethnic) of co-workers 1 2 3 4 X

Comments:

J. Open Category: Industry-Specific Skills

Are there any skills or competencies that you feel are important to the profession or career-field (represented by your organization) that have not been previously listed in this evaluation? If so, please list these skills below and assess the intern accordingly.

NA

1. 1 2 3 4 5

2. 1 2 3 4 5

3. 1 2 3 4 5

K. Overall Performance

Unsatisfactory Poor Average Good Outstanding

_X__ I have ___ I have not discussed this assessment with the employee.

Evaluator’s Signature: ___________________________________________Date: _________________

Title/Position: _______________________________________Telephone:_____________________

Are you stuck with your online class?
Get help from our team of writers!
Order Today

Order your essay today and save 20% with the discount code RAPID

Order Now