The post 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 is a property of College Pal
College Pal writes Plagiarism Free Papers. Visit us at College Pal – Connecting to a pal for your paper
Exp19_Access_Ch08_Capstone – Registry 1.0
Exp19 Access Ch08 Capstone Registry 1.0
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.docx and the picture file named 81094880.jpg 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
P
The post 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 appeared first on College Pal. Visit us at College Pal – Connecting to a pal for your paper
