Microsoft Access Projects

I need help with 3 projects in Access. I need to know the cost of each and when they can be completed. Please see attachments below. Thank you.

On Your Own

19-1

1. Open the data file

located in the Chapter 19\On Your

Own folder. Save the database as

7. Use the Form Wizard to create a form

containing a main form based on the

Donor table and a subform based on

Donations19

DonationsList19.

2. Use the Form Wizard to create a form

based on the Donation table. Select

all the fields for the form and the

Columnar layout. Specify an

appropriate title for

the form.

3. Apply a different theme to the form

4. Edit the form title as needed so that

spaces separate each word. Change

the font color of the form title to a

color that is easy to read with the

theme you applied to the form.

5. Use the appropriate buttons in the

Font group on the Form Layout

Tools Format tab to bold and

underline the form title. Resize the

title, as necessary, so that all of the

title text appears on the same line.

6. Use the form to update the Donation

table. Search for records that contain

the word ere in the

Description field. Find the record

with the field value

(and the Donation ID 2126) and then

change the Donation Value for this

record to

form.

the Donation table. Select appropriate

fields from each table for the main

form and the subform. Use the

Datasheet layout. Specify appropriate

titles for the main form and the

subform.

8. Apply the same theme you applied in

Step 3 to this form

9. Edit the form title so that each word is

separated by a space and uses correct

capitalization. Resize the form title as

needed so that the text fits on one

line. Change the font color of the title

to the

same color you used in Step 4.

10. Use the appropriate button in the

Font group on the Form Layout

Tools Format tab to apply a

background color of your choice to

all the field value boxes in the main

form. ( ld value

boxes before making this change.)

11. Use the appropriate button in the

Control Formatting group on the

Form Layout Tools Format tab to

change the outline of all the main

form field value boxes to a different

line thickness.

only.

small anywh

Small appliances

120.00. Save and close the

only.

Hint: Select all the fie

On Your Own

12. Resize the subform so that the entire

subform is visible, and then resize

each column in the subform to its

best fit. Navigate through each record

in the main form to make sure all the

15. Apply the same theme you applied in

Step 3 to this report

16. Edit the report title appropriately,

resize the report title so that the text

is fully visible, and then change the

only.

field values in the subform are

completely displayed, resizing

subform columns as necessary. Save

the form.

13. Use the appropriate wildcard

character to find all records with a

Phone field value that begins with the

area code 208. Change the record

with the Phone field value of 208-

555-9033 (Donor ID 36032) to

14. Use the Report Wizard to create a

report based on the primary Agency

table and the related Donation table.

Select the Agency and Phone fields

from the Agency table, and select all

fields except AgencyID and Pickup

from the Donation table. In the third

Report Wizard dialog box, add

DonorID as an additional grouping

level. Sort the detail records in

descending order by DonationValue.

Choose the Outline layout and

Portrait orientation. Specify the name

font color of the report title to the

same color you used in Step 4.

17. Resize field labels and field value

boxes as needed to fully display their

values, being sure that all the boxes

remain within the page boundaries.

18. Insert the data file

located in the Chapter 19\On Your

Own folder in the report. Place the

picture appropriately in the report.

Resize it larger to fill the space.

19. Apply conditional formatting to the

Donation Value field using an

appropriate condition and

formatting.

20. Preview the report to confirm that it

is formatted correctly and all field

labels and field values are fully

visible. Save the report, print one

page that shows the conditional

formatting you applied, and then

close the report.

21. Compact and repair the

DonationsList19 database, and then

close it.

CharityLogo

970-

555-9033. Close the form.

AgencyDonations for the report.

On Your Own

On Your Own 19-1

On Your Own

17-1

1. Open the data file DonationTable17

located in the Chapter 17\On Your

Own folder. Save the database as

DonationTable17Edited.

2. Open the Donation table, and then

switch to Design view.

3. Rename the ID field as AgencyID.

4. Set the DonationID field as the

primary key.

5. Use the Field Properties pane to set

appropriate values for the

DonationID field’s Description, Field

Size, and Caption properties. (Hint:

To determine the field size of the

DonationID field, look at the records

in the datasheet.)

6. Change the Field Size and Caption

properties for each of the remaining

fields, as appropriate (use the

Medium Date format for the

DonationDate field, leave the

Description field size at 255, and set

the default value for Pickup to No).

Save the table.

7. In Datasheet view, resize the columns

as needed so that all of the field

values are displayed. Save the table,

and then

close it.

8. In the Navigation Pane, select the

Donation table. Copy the Donation

table to the Clipboard.

9. Open the data file Donations17

located in the Chapter 17\On Your
Own folder. Save the database as

DonationsList17.

10. In DonationsList17, paste the

contents of the Clipboard. In the

Paste Table As dialog box that opens,

make sure the table name is Donation

and the Structure and Data option

button is selected, and then click OK.

11. Open the Donor table, and then edit

the first record to use your title, first

name, and last name in the

corresponding fields. Close the table.

12. Open the Agency table, and then

delete the Fax and Notes fields from

the table. Save and close the table.

13. Use the Simple Query Wizard to

create a query that includes all the

fields in the Donor table except the

Title field. (Hint: Use the and

buttons to select the necessary

fields.) Save the query as

DonorPhoneList.

14. Sort the query results by the Last

Name column. (Hint: Make the Last

Name column the current field, and

then click the appropriate button on

the Home tab in the Sort & Filter

group.)

On Your Own

15. Rearrange the fields in the query

design so the Last Name field is to the

left of the First Name field in the

datasheet.

16. Widen columns widths as needed in

the datasheet, and then save and close

the query.

17. Create a form based on the Donor

table. 18. In the new form, navigate

to record 8, and then print the form

for the current record only. (Hint:

Use the Print button in Backstage view

instead of the Quick Print button.)

Save the form as DonorInfo, and then

close it.

19. Create a report based on the Donor

table.

20. In Layout view, resize each field so it

is slightly wider than the longest entry

(either the field name itself or an

entry in the field).

21. Delete the summary field at the

bottom of the report.

22. Move the page number at the bottom

of the report so it appears completely

on the page. (Hint: Select the field,

and then drag it to the left.)

23. Save the report as DonorList.

24. Display the report in Print Preview

and verify that the fields and page

number fit within the page area. Print

the report,

and

then close it.

25. Compact and repair the database,

and then close it.

26. Open the DonationTable17Edited

database, compact and repair it, and

then close it.
On Your Own

On Your Own

18-1

1. Open the data file Donations18

located in the Chapter 18\On Your

Own folder. Save the database as

DonationsList18.

2. In the Donor table, for Donor ID

36001, change the Title field to an

appropriate title, change the First

Name field value to your first name,

and change the Last Name field value

to your last name.

3. Create one-to-many relationships

between the primary Agency table

and the related Donation table, and

between the primary Donor table and

the related Donation table. For each

relationship, enforce referential

integrity and cascade updates to

related fields. Save and close the

Relationships window.

4. In the Donor table, delete the record

for Donor ID 36028. (Be sure to

delete the related record first.)

5. Create a query based on the Agency

table that includes the Agency,

FirstName, LastName, and City

fields. Save the query as

AgenciesByCity, and then run it.

6. Modify the AgenciesByCity query

design so that it sorts records in

ascending order first by City and then

in ascending order by Agency. Save

and run the

query.

7. In the AgenciesByCity query datasheet,

change the contact for the Carpenter

After-School Center to Valerie

Jackson. Close the query.

8. Create a query in Design view that

displays the DonorID, FirstName,

and LastName fields from the Donor

table, and the Description and

DonationValue fields from the

Donation table for all donations over

$100. Sort the query in descending

order by DonationValue. Save the

query as BigDonors, and then run the

query.

9. Save the BigDonors query as

BigCashDonors. Modify the

BigCashDonors query to display only

records with cash donations of more

than $100. Do not include the

Description field values in the query

results. In the query datasheet,

calculate the sum of the cash

donations. Save and close the query.

On Your Own

10. Create a query in Design view that

displays the Agency from the Agency

table, and the DonationID,

DonationDate, and Description fields

from the Donation table. Save the

query as TrailsDonations, and then

run the query.

11. Use the Selection button in the Sort

& Filter group on the Home tab to

filter the TrailsDonations query

datasheet to display only the records

for donations to Eastern Wyoming

Trails.

12. Format the TrailsDonations query

datasheet to use an alternate row

color of the Purple, Accent 4, Lighter

80% theme color. (Hint: Use the

Alternate Row Color button in the

Text Formatting group on the Home

tab to select the row color.) Resize the

columns to best fit the complete field

names and values. Save the

TrailsDonations query.

13. Save the TrailsDonations query as

FurnitureOrHousewares. Modify the

FurnitureOrHousewares query to

display donations of furniture or

housewares and to list the Agency ID

instead of the Agency name. Sort the

records in ascending order first by

Description and then in ascending

order by AgencyID. Run the query,

adjust the column widths, save the

query, and then close it.

14. Create a query in Design view that

displays the DonorID, Agency,

Description, and DonationValue

fields for all donations that require a

pickup. Do not display the Pickup

field in the query results. Save the

query as PickupCharge. Create a

calculated field named Net Donation

that displays the results of subtracting

$9.25 from the Donation-Value field

values. Display the results in

ascending order by DonationValue.

Format the calculated field with the

Currency format. Run the query,

resize the columns in the query

datasheet to their best fit, save the

query, and then close it.

15. Create a query in Design view based

on the Donation table that displays

the sum, average, and count of the

DonationValue field for all

donations. (Hint: Use the Count

function to count the number of

rows.) Enter appropriate column

names for each field. Format the sum

and average values using the Standard

On Your Own

format and two decimal places. Save

the query as DonationStats, and then

run the query. In the query datasheet,

resize the columns to their best fit,

save the query, and then close it.

16. Create a copy of the DonationStats

query named

DonationStatsByAgency. Modify the

DonationStatsByAgency query to

display the sum, average, and count

of the DonationValue field for all

donations grouped by Agency, with

Agency appearing as the first field.

Sort the records in descending order

by the donation total. Save the query,

run the query, and then close it.

17. Compact and repair the

DonationsList18 database, and then

close it. (Do not save the contents of

the Clipboard.)

On Your Own

Chapter 17/Chapter/Solar17.accdb

ContractID
CustomerID
ContractValue
DateSigned

1301-KS
1
¤ 500.00
2013-02-09

1302-KS
1
¤ 14,000.00
2013-03-03

1303-MP
16
¤ 1,150.00
2013-03-16

1304-MP
22
¤ 1,200.00
2013-04-10

1305-KF
3
¤ 800.00
2013-04-22

1306-MP
23
¤ 1,100.00
2013-04-29

1307-RR
5
¤ 620.00
2013-07-07

1308-RR
25
¤ 800.00
2013-08-09

1309-KF
11
¤ 450.00
2013-08-16

1310-MP
16
¤ 89,000.00
2013-08-26

1311-KS
26
¤ 25,500.00
2013-09-03

1312-KF
24
¤ 25,000.00
2013-09-04

1313-RR
17
¤ 550.00
2013-09-11

1314-RR
5
¤ 16,500.00
2013-09-17

1315-MP
2
¤ 690.00
2013-09-30

1316-RR
25
¤ 32,500.00
2013-10-15

1317-KF
11
¤ 15,500.00
2013-10-15

1318-KF
3
¤ 18,000.00
2013-10-20

1319-RR
25
¤ 39,000.00
2013-11-07

1401-MP
2
¤ 20,000.00
2014-01-26

1402-RR
25
¤ 138,000.00
2014-02-18

1403-RR
17
¤ 14,500.00
2014-02-22

1404-KF
21
¤ 15,750.00
2014-03-11

1405-KS
20
¤ 1,000.00
2014-04-08

1406-MP
9
¤ 16,500.00
2014-04-23

1407-RR
10
¤ 22,800.00
2014-04-29

1408-AD
19
¤ 700.00
2014-05-04

1409-KS
20
¤ 23,750.00
2014-05-10

1410-AD
15
¤ 205,000.00
2014-05-20

1411-RR
12
¤ 1,150.00
2014-06-01

1412-RR
13
¤ 575.00
2014-06-12

1413-AD
19
¤ 18,500.00
2014-06-12

1414-KS
6
¤ 25,500.00
2014-06-29

1415-MP
14
¤ 14,500.00
2014-07-14

1416-MP
18
¤ 35,000.00
2014-07-30

1417-KS
4
¤ 6,500.00
2014-08-09

1418-RR
8
¤ 15,000.00
2014-08-10

1419-AD
13
¤ 38,500.00
2014-08-11

1420-AD
25
¤ 50,000.00
2014-08-17

1421-MP
7
¤ 875.00
2014-08-23

1422-AD
25
¤ 41,000.00
2014-09-02

CustomerID
LastName
FirstName
Company
Street
City
State
Zip
Phone
Email

1
Tam
Dennis

2930 Duck Creek Road
Palo Alto
CA
94306
650-555-3132
dtam@onecalweb.com

2
Derrick
Barbara

2071 Clifford Street
Oakland
CA
94612
510-555-5217
bderrick@interoaklandweb.com

3
Sharma
Sumiko

53 Wolf Pen Road
Redwood City
CA
94063
650-555-6578
ssharma@redwoodplanet.net

4
Stanwood
Misti
Brisbane Engineering Dept.
4118 Straite Road
Brisbane
CA
94005
650-555-6869
mstanwood@brisbaneeng.net

5
Faries
Leopold

438 Boring Lane
Dublin
CA
94568
415-555-7870
lfaries@onecalweb.com

6
Schumer
Bradley

2547 Hillview Drive
San Francisco
CA
94103
707-555-0613
bschumer@onecalweb.com

7
Grady
Yvette
San Rafael Medical Partners
4287 Roosevelt Street
San Rafael
CA
94903
415-555-2591
ygrady@sanrafmed.net

8
Colberg
Chung

1626 Fairway Drive
Oakland
CA
94612
707-555-3001
ccolberg@onecalweb.com

9
Selin
Xenia
Jack’s Café
1675 Meadow Lane
Oakland
CA
94612
707-555-2064
xselin@onecalweb.com

10
Kennison
Pamela
Pleasanton Waldorf School
2646 Park Street
Pleasanton
CA
94588
925-555-1913
pkennison@pleasantonwaldorf.net

11
Christofferson
Khali

3348 Delaware Avenue
San Francisco
CA
94124
415-555-7074
kchristofferson@onecalweb.com

12
Tedeschi
Anthony
M. Doufay Financial
981 Fairway Drive
Concord
CA
94520
707-555-4193
itedeschi@doufayfinancial.com

13
Miga
Manda
Oak Roots Development
1505 Thunder Road
Oakland
CA
94612
650-555-0084
mmiga@oakrootsdev.com

14
Walker
Frank

3722 Davis Avenue
Fremont
CA
94539
707-555-5274
dwelker@onecalweb.com

15
Stille
Tamara
Prentice College
2793 Wayside Lane
Oakland
CA
94612
510-555-7478
tstille@prentice.edu

16
Ferebee
Julianne
Oakland Neighborhood Development
3033 Beech Street
Oakland
CA
94612
925-555-6240
jferebee@interoaklandweb.com

17
Lemaire
Alexa

2916 Friendship Lane
Oakland
CA
94612
408-555-0092
alemaire@interoaklandweb.com

18
Borgmeyer
Emerita

4430 Marietta Street
Rohnert Park
CA
94928
707-555-4074
eborgmeyer@onecalweb.com

19
Doten
Al

4591 Haverford Road
San Carlos
CA
94070
650-555-6517
adoten@onecalweb.com

20
Hartt
Cecille
Sauerbrook & Mars Fashions
3144 Ringland Lane
San Francisco
CA
94110
415-555-2691
chartt@sauerbrookmars.com

21
Arter
Kathleen
Prancing Pony Grill
3118 Roosevelt Street
San Francisco
CA
94108
415-555-4887
karter@prancingponygrill.com

22
Wilcox
Jennifer
Swan Senior Living Center
494 Friendship Lane
Oakland
CA
94607
408-555-9912
jwilcox@swanseniorcenter.com

23
Fry
Juanita
Bay Area Communities United
535 Locust View Drive
San Francisco
CA
94105
415-555-8025
jfry@onecalweb.com

24
Hearns
Raymond

2565 Beech Street
Oakland
CA
94607
925-555-6543
rhearns@interoaklandweb.com

25
Frevert
Krystle
LKW Construction
4457 Water Street
Palo Alto
CA
94301
650-555-3470
kfrevert@lkwdconstruction.com

26
Puig
Jacob
Liehe Contracting
4169 Clifford Street
Oakland
CA
94612
510-555-6733
jpuig@liehecontracting.biz

InvNum
InvDate
Amount
Paid
ContractID

1302-001
2013-02-18
¤ 500.00
true
1301-KS

1304-002
2013-04-01
¤ 1,150.00
true
1303-MP

1304-003
2013-04-29
¤ 1,200.00
true
1304-MP

1305-004
2013-05-10
¤ 12,500.00
true
1302-KS

1305-005
2013-05-15
¤ 1,100.00
true
1306-MP

1305-006
2013-05-30
¤ 800.00
true
1305-KF

1306-007
2013-06-09
¤ 1,500.00
true
1302-KS

1307-008
2013-07-15
¤ 620.00
true
1307-RR

1308-009
2013-08-28
¤ 450.00
true
1309-KF

1308-010
2013-08-29
¤ 800.00
true
1308-RR

1309-011
2013-09-15
¤ 5,100.00
true
1311-KS

1309-012
2013-09-15
¤ 2,500.00
true
1312-KF

1309-013
2013-09-29
¤ 17,800.00
true
1310-MP

1309-014
2013-09-29
¤ 550.00
true
1313-RR

1310-015
2013-10-15
¤ 690.00
true
1315-MP

1310-016
2013-10-15
¤ 3,500.00
true
1314-RR

1311-017
2013-11-12
¤ 8,500.00
true
1317-KF

1311-018
2013-11-12
¤ 4,100.00
true
1315-MP

1311-019
2013-11-15
¤ 6,500.00
true
1316-RR

1311-020
2013-11-15
¤ 7,800.00
true
1319-RR

1311-021
2013-11-15
¤ 20,400.00
true
1311-KS

1311-022
2013-11-15
¤ 22,500.00
true
1312-KF

1311-023
2013-11-29
¤ 45,600.00
true
1310-MP

1312-024
2013-12-15
¤ 12,480.00
true
1319-RR

1312-025
2013-12-21
¤ 15,000.00
false
1318-KF

1312-026
2013-12-23
¤ 8,000.00
true
1314-RR

1312-027
2013-12-29
¤ 13,000.00
true
1316-RR

1401-001
2014-01-12
¤ 7,000.00
true
1317-KF

1401-002
2014-01-15
¤ 18,720.00
true
1319-RR

1401-003
2014-01-29
¤ 25,600.00
true
1310-MP

1401-004
2014-01-29
¤ 8,500.00
true
1316-RR

1401-005
2014-01-31
¤ 3,000.00
false
1318-KF

1402-006
2014-02-12
¤ 5,000.00
true
1314-RR

1402-007
2014-02-14
¤ 4,500.00
true
1316-RR

1402-008
2014-02-28
¤ 18,000.00
true
1402-RR

1403-009
2014-03-15
¤ 13,000.00
true
1401-MP

1403-010
2014-03-29
¤ 4,725.00
true
1404-KF

1403-011
2014-03-29
¤ 6,500.00
true
1403-RR

1404-012
2014-04-15
¤ 1,000.00
true
1405-KS

1404-013
2014-04-28
¤ 120,000.00
true
1402-RR

1405-014
2014-05-01
¤ 7,000.00
true
1401-MP

1405-015
2014-05-15
¤ 700.00
true
1408-AD

1405-016
2014-05-15
¤ 8,000.00
true
1403-RR

1405-017
2014-05-29
¤ 9,025.00
true
1404-KF

1405-018
2014-05-29
¤ 10,000.00
true
1409-KS

1405-019
2014-05-29
¤ 12,400.00
true
1407-RR

1406-020
2014-06-12
¤ 41,000.00
true
1410-AD

1406-021
2014-06-12
¤ 1,150.00
false
1411-RR

1406-022
2014-06-29
¤ 2,000.00
true
1404-KF

1406-023
2014-06-29
¤ 137,500.00
true
1409-KS

1406-024
2014-06-29
¤ 8,000.00
true
1413-AD

1406-025
2014-06-29
¤ 575.00
true
1412-RR

1407-026
2014-07-12
¤ 4,500.00
true
1407-RR

1407-027
2014-07-12
¤ 10,000.00
true
1410-AD

1407-028
2014-07-23
¤ 16,500.00
true
1406-MP

1408-029
2014-08-12
¤ 4,500.00
true
1414-KS

1408-030
2014-08-12
¤ 8,500.00
true
1410-AD

1408-031
2014-08-12
¤ 7,000.00
true
1416-MP

1408-032
2014-08-12
¤ 3,000.00
true
1407-RR

1408-033
2014-08-15
¤ 10,500.00
true
1413-AD

1408-034
2014-08-29
¤ 15,000.00
true
1420-AD

1409-035
2014-09-01
¤ 2,900.00
false
1415-MP

1409-036
2014-09-12
¤ 9,000.00
true
1418-RR

1409-037
2014-09-12
¤ 875.00
false
1421-MP

1409-038
2014-09-12
¤ 3,000.00
true
1414-KS

1409-039
2014-09-12
¤ 14,200.00
true
1410-AD

1409-040
2014-09-29
¤ 2,900.00
true
1407-RR

1409-041
2014-09-29
¤ 8,200.00
true
1422-AD

1409-042
2014-09-29
¤ 8,500.00
true
1416-MP

1410-043
2014-10-10
¤ 6,500.00
false
1417-KS

1410-044
2014-10-12
¤ 12,000.00
true
1414-KS

1410-045
2014-10-12
¤ 7,500.00
false
1415-MP

1410-046
2014-10-12
¤ 4,000.00
true
1418-RR

1410-047
2014-10-12
¤ 43,600.00
true
1410-AD

1410-048
2014-10-29
¤ 10,000.00
true
1416-MP

1410-049
2014-10-29
¤ 17,500.00
true
1420-AD

1411-050
2014-11-12
¤ 29,500.00
false
1410-AD

1411-051
2014-11-12
¤ 2,000.00
false
1418-RR

1411-052
2014-11-29
¤ 32,800.00
false
1422-AD

1411-053
2014-11-29
¤ 17,500.00
false
1420-AD

1411-054
2014-11-29
¤ 9,500.00
false
1416-MP

1412-055
2014-12-12
¤ 37,500.00
false
1410-AD

Chapter 17/On Your Own/Contacts17.accdb

RoomID
RoomName
BuildingName
Campus
DailyRate
SeatingCapacity
DiningCapacity
RoomType
Description

3002
Adams 100
Adams Hall
Main
¤ 800.00
150
70
Meeting
Large windows, tall ceilings, can be combined with Adams 101

3003
Adams 101
Adams Hall
Main
¤ 800.00
150
70
Meeting
Large windows, tall ceilings, can be combined with Adams 100

3007
Adams 200
Adams Hall
Main
¤ 1,200.00
200
90
Meeting
Large windows, tall ceilings, can be combined with Adams 201

3010
Adams 201
Adams Hall
Main
¤ 1,200.00
200
90
Meeting
Large windows, tall ceilings, can be combined with Adams 200

3050
Siegelman 100
Siegelman Hall
West Valley City
¤ 650.00
125
60
Meeting
Dedicated kitchen and restrooms, can be combined with Siegelman 150

3107
Siegelman 150
Siegelman Hall
West Valley City
¤ 650.00
125
60
Meeting
Dedicated kitchen and restrooms, can be combined with Siegelman 100

3142
Jones Room
Jackson Hall
Main
¤ 350.00
75
35
Social
Carpeted, private area of building

3179
Smith Room
Jackson Hall
Main
¤ 350.00
75
35
Social
Carpeted, private area of building

3190
Johnson Room
Jackson Hall
Main
¤ 650.00
125
60
Social
Carpeted, large windows

3204
Little Theater
Pike Student Center
Main
¤ 900.00
150
70
Lecture
Wedged shape, well suited for presentations

3222
Grand Theater
Pike Student Center
Main
¤ 1,500.00
420
205
Lecture
Wedged shape, well suited for presentations

3395
Wang 100
Wang Hall
Downtown
¤ 900.00
150
70
Social
Carpeted, large windows, tall ceilings, can be combined with Wang 200

3423
Wang 200
Wang Hall
Downtown
¤ 900.00
150
70
Social
Carpeted, large windows, tall ceilings, can be combined with Wang 100

3488
Ballroom
Tenuta Hall
Main
¤ 2,000.00
360
175
Social
Ornate neoclassical theater, with tapestries and carpet

3515
Phillips 100
Phillips Hall
West Valley City
¤ 1,600.00
350
160
Meeting
Dedicated kitchen and restrooms, can be combined with Phillips 150

3529
Phillips 150
Phillips Hall
West Valley City
¤ 1,600.00
350
160
Meeting
Dedicated kitchen and restrooms, can be combined with Phillips 100

3611
Chavez 110
Chavez Hall
Main
¤ 700.00
150
70
Meeting
Large windows, can be combined with Chavez 120 and 130

3628
Chavez 120
Chavez Hall
Main
¤ 700.00
150
70
Meeting
Large windows, can be combined with Chavez 110 and 130

3670
Chavez 130
Chavez Hall
Main
¤ 700.00
150
70
Meeting
Large windows, can be combined with Chavez 110 and 120

3675
Chavez 140
Chavez Hall
Main
¤ 1,250.00
240
105
Meeting
Large windows, dedicated restrooms

Chapter 17/On Your Own/ContactsTable17.accdb

ID
ContactFirst
ContactLast
Address
City
State
Zip
Phone
BirthDate

201
Lori
Sinclair
2315 Philadelphia Avenue
Murray
UT
84107
801-966-0454
1965-05-29

202
Leo
Wessel
2195 Scattershot Way
Salt Lake City
UT
84111
801-869-3378
1976-12-12

203
Leonard
Black
784 Philadelphia Avenue
Salt Lake City
UT
84104
801-474-8135
1982-01-08

205
Thomas
Friedel
4880 Tori Lane
Salt Lake City
UT
84116
801-573-3401
1940-03-07

206
William
Tsan
2204 Buck Drive
Salt Lake City
UT
84111
801-490-1641
1949-11-15

209
Robert
Pharr
595 Pignole Drive
West Valley City
UT
84119
801-483-3559
1980-09-05

210
Tina
Allen
1950 Kemper Lane
Salt Lake City
UT
84116
801-981-0593
1943-08-05

211
Alice
Cox
4879 Tori Lane
Salt Lake City
UT
84113
801-733-7017
1982-10-16

212
Arthur
Miller
3613 Hickory Street
Salt Lake City
UT
84104
801-450-9220
1983-05-09

215
Sarah
Robinson
4411 Walton Street
Salt Lake City
UT
84104
801-274-0595
1983-04-08

216
Thomas
Mathis
2299 White River Way
Salt Lake City
UT
84111
801-570-0381
1970-03-25

217
Lois
Augustine
1979 Thrice Way
Salt Lake City
UT
84106
801-488-3255
1966-08-01

220
Kevin
Smith
3291 Kemper Lane
Murray
UT
84107
801-449-9225
1980-06-15

221
Tracy
Kemp
3651 Plympton Lane
Kearns
UT
84118
801-440-5209
1965-01-31

222
Cora
Velez
510 Walton Street
Salt Lake City
UT
84104
801-534-1420
1972-09-15

225
Angel
Pinto
2983 Stringfeld Way
Salt Lake City
UT
84111
435-728-5245
1971-08-28

228
John
Pittman
4132 Hickory Street
Salt Lake City
UT
84104
435-538-4925
1989-07-22

229
Michelle
Frey
242 Sweetwater Drive
Salt Lake City
UT
84111
801-584-3146
1971-10-31

230
Dan
Eason
1439 Tempest Avenue
Salt Lake City
UT
84116
801-795-7666
1965-02-22

Chapter 17/On Your Own/Donations17.accdb

AgencyID
Agency
FirstName
LastName
Street
City
State
Zip
Phone
Fax
Notes

K64
Wyoming Homeless Services
Bradley
Feeney
4263 Archwood Avenue
Mountain View
WY
82939
307-555-7539
307-555-7540

K82
SeniorCare
Edward
Hyslop
3482 Thorn Street
Cheyenne
WY
82001
307-555-4663
307-555-4661

N33
Family Crisis Center
Jerry
Caldwell
4673 Naito Avenue
Lingle
WY
82223
307-555-9416
307-555-9411

N57
Wheelchair Soccer League
Marie
Llanos
4418 Arbor Court
Cheyenne
WY
82001
307-555-9592
307-555-9598

R15
Self Defense for Youth
Mark
Ellis
1011 38th Street
Mountain View
WY
82939
307-555-1800
307-555-1814

R31
Cheyenne Food Pantry
Kenneth
Mead
2987 Oak Street
Cheyenne
WY
82001
307-555-3158
307-555-3159

R86
Carpenter After-School Center
Verlie
Chacko
4999 Lake Avenue
Carpenter
WY
82054
307-555-7030
307-555-7031

W22
Wildlands Restoration of Wyoming
Curtis
Shannon
1338 Woodward Court
Green River
WY
82935
307-555-1395
307-555-1402

W43
Kids Write!
Madeline
Holler
4939 Main Street
Albin
WY
82050
307-555-8687
307-555-8693

Y68
Eastern Wyoming Trails
Otis
Lopez
628 Pleasant Boulevard
Cheyenne
WY
82003
307-555-3900
307-555-3901

DonorID
Title
FirstName
LastName
Phone

36001
Mr.
John
Stevens
307-555-6464

36012
Ms.
Janice
Busch
307-555-7006

36016
Mrs.
Lucille
Martinez
970-555-2605

36019
Mrs.
Wanda
Dubay
307-555-8183

36020
Mr.
John
Schuller
307-555-9857

36025
Ms.
Tina
Moore
307-555-0146

36028
Mrs.
Ella
Phillips
307-555-8762

36032
Mr.
Melvin
Brown
208-555-9033

36033
Mr.
Edward
Fleming
970-555-4733

36037
Mr.
Stuart
Wynn
307-555-9075

36041
Mrs.
Lindsey
Christopher
307-555-0769

36042
Mr.
Terrell
Ulrey
307-555-6002

36049
Mr.
Jermaine
Green
307-555-8377

36051
Mr.
Antonio
Meehan
970-555-9954

36055
Ms.
Lyda
Davis
307-555-0692

36056
Ms.
Rene
Olesen
307-555-7129

36058
Mrs.
Alma
Mears
307-555-7251

36060
Mrs.
Maria
Cave
307-555-9588

36062
Mr.
Randy
Rivera
307-555-5160

36064
Mr.
David
Brogan
307-555-6556

36070
Mrs.
Brenda
Lawson
307-555-9224

36073
Mr.
Jamie
Stapleton
307-555-8855

36074
Mr.
Roberto
Horvath
307-555-7550

36077
Mr.
Michael
Brazelton
307-555-3370

Chapter 17/On Your Own/DonationTable17.accdb

DonationDate
Description
DonationValue
DonationID
DonorID
ID
Pickup

2013-01-12
Books
31.0
2100
36001
K82
false

2013-06-02
Housewares
14.0
2103
36033
N57
false

2013-03-10
Electronics
20.0
2105
36001
K64
false

2013-05-17
Small rugs
145.0
2108
36062
W22
true

2013-09-07
Furniture
35.0
2110
36041
R31
false

2013-03-05
Tools
140.0
2112
36060
Y68
false

2013-03-19
Books
34.0
2115
36056
N57
false

2013-06-01
Clothing
153.0
2116
36001
K82
true

2013-02-20
Books
62.0
2117
36012
K82
false

2013-04-23
Furniture
80.0
2119
36051
W22
true

2013-02-24
Toys
99.0
2121
36058
K64
false

2013-03-22
Furniture
44.0
2122
36016
N33
false

2013-10-02
Electronics
361.0
2124
36055
Y68
true

2013-09-03
Clothing
128.0
2125
36077
R31
false

2013-10-04
Small appliances
20.0
2126
36019
N57
false

2013-02-28
Garden tools
24.0
2129
36012
R86
false

2013-07-03
Electronics
93.0
2131
36049
N33
true

2013-12-25
Cookware
49.0
2133
36042
W22
false

2013-07-31
Linens
17.0
2136
36037
W43
false

2013-05-01
Books
106.0
2137
36062
R31
false

2013-02-26
Furniture
188.0
2142
36064
N33
true

2013-05-12
Clothes
476.0
2144
36058
N57
true

2013-11-10
CDs
37.0
2145
36020
R15
false

2013-10-17
Shoes and boots
287.0
2147
36032
R15
true

2013-09-10
Costume jewelry
37.0
2148
36037
W22
false

2013-11-06
Plates and bowls
30.0
2151
36037
N33
false

2013-08-02
Books
24.0
2153
36070
N57
false

2013-12-12
Clothing
49.0
2154
36025
R31
false

2013-01-01
Silverware
360.0
2155
36077
R31
true

2013-01-18
Furniture
50.0
2157
36028
W22
false

2013-03-07
DVDs
319.0
2159
36041
K64
true

2013-02-21
Bicycle
28.0
2160
36032
W43
false

2013-11-29
Power tools
26.0
2163
36055
R86
false

2013-05-27
Bicycle
654.0
2167
36037
W22
true

2013-12-02
Vases
214.0
2168
36033
Y68
false

2013-09-10
Office equipment
269.0
2170
36074
R31
true

2013-11-03
Furniture
22.0
2171
36056
W43
false

2013-03-24
Books
32.0
2172
36033
Y68
false

2013-06-12
CDs
103.0
2175
36041
R15
false

2013-03-07
Toys
44.0
2177
36019
W43
false

2013-10-11
Garden equipment
278.0
2179
36016
K64
true

2013-06-03
Tea set
37.0
2180
36037
K64
false

2013-03-07
Cutlery
31.0
2181
36055
N33
false

2013-05-12
Small appliances
48.0
2182
36012
N57
false

2013-02-28
Guitar
173.0
2184
36020
Y68
true

2013-12-11
Stuffed animals
96.0
2185
36074
K82
false

2013-10-19
Cookware
28.0
2187
36070
W43
false

2013-04-30
Books
125.0
2188
36073
R31
false

2013-04-14
Clothing
72.0
2190
36074
N57
false

2013-01-01
Cookware
18.0
2191
36077
W43
false

2013-05-02
Bicycle
19.0
2192
36073
W22
false

2013-06-01
Furniture
25.0
2193
36042
N33
false

2013-04-15
Small appliances
284.0
2195
36064
K64
false

2013-12-04
DVDs
34.0
2196
36051
N33
true

2013-06-05
Electronics
262.0
2197
36033
Y68
false

2013-06-04
Small rugs
33.0
2200
36032
K82
false

2013-06-20
Power tools
256.0
2202
36051
W22
true

2013-03-07
Office equipment
368.0
2205
36056
N33
true

2013-03-01
Clothing
191.0
2210
36060
Y68
false

2013-06-20
Books
252.0
2212
36077
R86
true

2013-06-13
Toys
337.0
2213
36055
W43
false

2013-05-12
Small appliances
238.0
2215
36070
N33
false

2013-06-21
Shoes and boots
17.0
2219
36077
W22
false

Chapter 17/On Your Own/Reservations17.accdb

ReservationID
ContactID
RoomID
StartDate
EndDate
Guests
Deposit

503
209
3488
2013-06-12
2013-06-12
150
¤ 2,000.00

504
203
3529
2013-03-11
2013-03-11
300
¤ 1,600.00

507
225
3002
2013-05-12
2013-05-22
120
¤ 1,000.00

510
220
3107
2013-05-01
2013-05-02
60
¤ 1,300.00

511
201
3142
2013-08-20
2013-08-21
50
¤ 700.00

512
211
3222
2013-04-04
2013-04-04
400
¤ 1,500.00

513
216
3007
2013-07-20
2013-07-22
80
¤ 3,600.00

515
202
3050
2013-09-08
2013-09-09
100
¤ 1,300.00

520
215
3002
2013-08-10
2013-08-10
60
¤ 800.00

521
206
3395
2013-06-03
2013-06-03
150
¤ 900.00

522
230
3190
2013-06-22
2013-06-26
125
¤ 3,250.00

525
212
3010
2013-07-11
2013-07-14
90
¤ 4,800.00

530
229
3204
2013-08-05
2013-08-07
150
¤ 2,700.00

531
205
3515
2013-11-16
2013-11-16
150
¤ 1,600.00

535
221
3003
2013-09-10
2013-09-10
80
¤ 800.00

536
222
3675
2013-02-20
2013-02-21
200
¤ 2,500.00

537
210
3611
2013-08-04
2013-08-06
70
¤ 2,100.00

540
211
3222
2014-04-10
2014-04-10
350
¤ 1,500.00

541
228
3628
2013-05-20
2013-05-20
150
¤ 700.00

545
203
3529
2014-03-15
2014-03-15
300
¤ 1,600.00

548
212
3395
2013-10-02
2013-10-02
60
¤ 900.00

550
229
3670
2013-11-05
2013-11-06
50
¤ 1,400.00

Chapter 17/Practice It/Art17.accdb

ClassID
ClassName
Juniors
Cost
Length
Level

CL-293
Clay Discovery
false
¤ 100.00
45
Beginning

CL-294
Clay Handbuilding and Sculpture
false
¤ 150.00
60
Advanced

CL-295
Clay Wheel Throwing I
false
¤ 125.00
60
Beginning

CL-296
Clay Wheel Throwing II
false
¤ 300.00
90
Intermediate

DR-104
Drawing Basics
false
¤ 125.00
45
Beginning

DR-105
Drawing Portraits
false
¤ 175.00
60
Beginning

DR-106
Cartooning I
false
¤ 75.00
60
Beginning

DR-107
Cartooning II
false
¤ 125.00
90
Intermediate

PA-024
Watercolor Basics
false
¤ 90.00
45
Beginning

PA-025
Watercolor II
false
¤ 150.00
90
Advanced

PA-026
Acrylics I
false
¤ 150.00
45
Beginning

PA-027
Acrylics II
false
¤ 250.00
90
Intermediate

PH-311
Photography I
false
¤ 100.00
45
Beginning

PH-312
Photography II
false
¤ 200.00
90
Intermediate

PH-313
Darkroom I
false
¤ 175.00
90
Beginning

PH-314
Darkroom II
false
¤ 350.00
120
Intermediate

StudentID
ClassID
FirstName
LastName
Street
City
State
Zip
Phone
AltPhone
BirthDate
Gender

AES7562
CL-293
Alfred
Stanley
874 Jessie Street
Columbus
OH
43215
740-555-1293
740-555-3388
1987-04-14
M

AOF7548
CL-295
Alba
Fischer
4972 Andell Road
Dublin
OH
43017
614-555-7408
614-555-1275
1996-04-24
F

BEA7502
PH-312
Brenda
Acker
2122 Collins Avenue
Westerville
OH
43081
614-555-0774
614-555-9117
1983-03-13
F

BLK7509
CL-293
Betty
Kingsley
2954 Bates Brothers Road
Columbus
OH
43215
614-555-9182
614-555-0091
1996-04-10
F

CAS7530
DR-106
Christopher
Soderlund
2943 Quilly Lane
Upper Arlington
OH
43221
614-555-5818
614-555-6876
1995-10-23
M

CCH7542
CL-296
Christa
Harris
4794 Viking Drive
Worthington
OH
43085
740-555-1599
740-555-8337
1993-09-27
F

CEH7584
DR-104
Chris
Hernandez
3554 Olive Street
Bowling Green
OH
43402
419-555-5926
419-555-8882
1982-04-13
M

DAH7527
PH-314
Deanna
Hugo
1735 Davis Place
Hamler
OH
43524
419-555-8581
419-555-1972
1956-03-18
F

DIR7511
PH-311
Delmar
Rector
2043 Palmer Road
Worthington
OH
43085
614-555-3375
614-555-0443
1967-11-22
M

EAW7518
PH-311
Eddie
White
403 Bates Brothers Road
Westerville
OH
43081
614-555-0112
614-555-1956
1967-10-04
M

GTB7545
CL-293
Gail
Broussard
129 Quilly Lane
Westerville
OH
43081
614-555-8448
614-555-4932
1975-02-20
F

HAR7524
PH-314
Henry
Rose
1676 Jessie Street
Lancaster
OH
43130
740-555-7456
740-555-2790
1976-12-16
M

HOC7545
CL-295
Horace
Chatman
1508 Sole Lane
Columbus
OH
43201
740-555-8715
740-555-7984
1997-09-23
M

JAR7553
PH-311
James
Davis
4152 Olive Street
Bowling Green
OH
43402
419-555-2956
419-555-5951
1995-08-04
M

JER7551
PA-027
James
Robinson
2201 Stonecoal Road
Maumee
OH
43537
419-555-6182
419-555-6303
1974-05-13
M

JMN7538
PH-313
John
Navarro
1765 Old Brickstone Drive
London
OH
43140
740-555-1485
740-555-0202
1970-04-19
M

JOW7531
DR-104
James
Woodruff
3711 Old House Drive
Worthington
OH
43085
740-555-4326
740-555-7712
1959-01-26
M

LAB7533
DR-105
Larry
Britt
976 Old House Drive
Westerville
OH
43081
740-555-5202
740-555-1045
1996-12-12
M

LIA7534
CL-293
Lisa
Anderson
562 James Martin Circle
Pataskala
OH
43062
614-555-7895
614-555-2410
1982-04-05
F

LRT7544
CL-293
Leslie
Trevino
1460 Palmer Road
Columbus
OH
43215
614-555-0515
614-555-2277
1996-05-28
F

MAE7556
PH-312
Marcus
Elam
1914 Andell Road
Westerville
OH
43081
614-555-6116
614-555-9511
1993-01-27
M

MAP7549
DR-105
Marian
Pettit
2972 Upland Avenue
Holland
OH
43528
419-555-3288
419-555-7819
1968-12-06
F

MIL7521
CL-295
Mercedes
Longino
4900 Jessie Street
Centerburg
OH
43011
740-555-5206
740-555-5573
1969-12-14
F

PHF7522
PA-025
Paul
Frank
2589 Cedarstone Drive
Maumee
OH
43537
419-555-0216
419-555-7299
1970-02-22
M

RAM7537
PA-027
Ruben
Moore
3713 Viking Drive
Worthington
OH
43085
740-555-2756
740-555-8002
1979-07-31
M

REC7541
CL-294
Richard
Collins
840 Birdhouse Drive
Alexandria
OH
43001
740-555-5921
740-555-8902
1979-10-18
M

Chapter 17/Practice It/Health17.accdb

MemberID
ProgramID
First
Last
Street
City
State
Zip
Status
DateJoined
Expiration

1103
201
Joseph
Eckler
29 Prospect Street
Ashland
VA
23005
Active
2013-01-16
2014-01-16

1105
204
Barry
Hassan
9 Harrington Avenue
Richmond
VA
23220
Active
2013-03-02
2015-03-02

1106
202
Debbie
Ward
18 Barton Street
Richmond
VA
23219
Active
2013-04-22
2013-10-22

1110
201
Ashish
Mittal
103 Hubbard Way
Glen Allen
VA
23058
On Hold
2013-04-03
2014-04-03

1111
203
Liz
Sorrento
134 Lincoln Road
Chester
VA
23831
Active
2013-02-10
2013-08-20

1115
203
Michelle
Kim
290 Brook Mill Road
Bon Air
VA
23235
Active
2013-05-17
2015-05-17

1116
207
Robert
DeCosta
35 Washington Street
Richmond
VA
23220
Inactive
2013-08-04
2014-08-04

1117
203
Paul
Novick
302 Great Road
Ashland
VA
23005
Active
2013-09-20
2015-09-20

1120
202
Carmen
Sanchez
1294 Monument Avenue
Richmond
VA
23219
On Hold
2013-10-18
2014-09-25

1121
209
Kelly
Smith
7 Lakeview Road
Chester
VA
23831
Active
2013-07-18
2014-07-18

1125
203
Jessica
Picard
17 Briarwood Lane
Mechanicsville
VA
23111
Active
2013-06-22
2013-12-22

1126
204
Sam
Bethel
258 Elm Street
Mechanicsville
VA
23111
Active
2013-05-19
2014-05-19

1131
207
Olivia
Alexander
29 Newtown Circle
Richmond
VA
23220
Active
2013-03-11
2015-03-11

1135
201
Tina
Sun
682 Hickory Way
Chester
VA
23831
Active
2013-06-03
2014-06-03

1136
212
Mary
Grant
913 Main Street
Chester
VA
23831
Active
2013-05-01
2015-05-01

1137
210
Alan
Fraser
41 Carver Hill Road
Mechanicsville
VA
23111
Active
2013-03-20
2014-03-20

1139
210
Peter
Grigas
3 Pleasant Street
Glen Allen
VA
23058
Inactive
2013-06-09
2015-06-09

1140
206
Ronald
Cunningham
52 Putnam Road
Ashland
VA
23005
Active
2013-02-04
2013-08-04

1142
207
Kye
Nguyen
456 Harringont Avenue
Richmond
VA
23220
On Hold
2013-02-20
2015-02-20

1143
206
Barry
Feinberg
73 Endicott Avenue
Chester
VA
23831
Active
2013-10-05
2014-10-05

1144
208
Colleen
Murphy
47 Winter Street
Mechanicsville
VA
23111
Active
2013-06-09
2014-06-09

1146
209
Marlene
Halpin
75 Elm Boulevard
Bon Air
VA
23235
On Hold
2013-07-17
2015-07-17

1147
210
Elijah
Slomich
108 Roosevelt Avenue
Mechanicsville
VA
23111
On Hold
2013-08-02
2015-08-02

1148
212
Todd
Wolfe
18 Parker Avenue
Richmond
VA
23219
Active
2013-09-20
2014-09-20

1150
203
Zach
Adgate
92 Apple Blossom Lane
Ashland
VA
23005
Active
2013-10-15
2014-10-15

1151
202
Isabella
Cimino
429 South Street
Ashland
VA
23005
Active
2013-08-02
2014-08-02

1153
212
Vinnie
Tumbiolo
358 East Street
Richmond
VA
23219
Inactive
2013-05-19
2015-05-29

1154
204
Jamal
Asmal
9872 Turnpike Road
Richmond
VA
23220
Active
2013-06-07
2014-06-07

1155
210
Juliette
Beaumont
35 Walnut Street
Glen Allen
VA
23058
Active
2013-08-01
2014-08-01

1156
208
Kurt
Eisler
5 Bradford Circle
Richmond
VA
23220
On Hold
2013-04-17
2015-04-17

1158
201
Pedro
Fuente
9 Mockingbird Lane
Chester
VA
23831
Active
2013-09-05
2014-09-05

1159
211
Maggie
Hadley
6 Rose Court
Ashland
VA
23005
Active
2013-03-19
2014-03-19

1160
212
Mark
Reynolds
11 Pond Lane
Mechanicsville
VA
23111
Active
2013-06-20
2015-06-20

1165
207
Shea
McKiernan
780 Flint Street
Ashland
VA
23005
Active
2013-07-13
2014-07-13

1166
203
Abigail
Turner
99 Maple Road
Richmond
VA
23219
On Hold
2013-09-01
2015-09-01

1167
204
George
Krukonis
14 Collins Drive
Richmond
VA
23219
Active
2013-05-05
2014-05-05

1169
211
Maria
Gonzalez
100 Tower Drive
Richmond
VA
23220
Active
2013-05-19
2014-05-19

1170
203
Student First
Student Last
40 Green Boulevard
Bon Air
VA
23235
Active
2013-06-03
2013-12-03

1172
211
Ed
Curran
25 Fairway Drive
Richmond
VA
23220
Active
2013-11-16
2014-11-16

ProgramID
ProgramType
MonthlyFee
StartDate
PhysicalRequired

201
Youth Full (ages 13-17)
¤ 50.00

true

202
Youth Limited (ages 13-17)
¤ 30.00

true

203
College Full
¤ 50.00

true

204
Young Adult Full (ages 18-35)
¤ 65.00

false

206
Young Adult Limited (ages 18-35)
¤ 35.00

false

207
Adult Full (ages 36-50)
¤ 60.00

false

208
Adult Limited (ages 36-50)
¤ 45.00

false

209
Starter Senior Full (ages 51-65)
¤ 50.00

true

210
Starter Senior Limited (ages 51-65)
¤ 35.00

true

211
Senior Full (ages 66 and over)
¤ 50.00

true

212
Senior Limited (ages 66 and over)
¤ 30.00

true

Chapter 17/Practice It/Snow17.accdb

ClientID
Company
FirstName
LastName
Phone
Street
City
State
Zip

Erick
Lewis
207-555-3132
193 Brimmer Street
Bangor
ME
04401

Jonah
West
207-555-5217
2938 Parker Street
Glenburn
ME
04401

Mica
Harris
207-555-6578
29 Highland Avenue
Bangor
ME
04401

4
Bangor Lighting
Scott
Woodman
207-555-6869
398 Eastern Avenue
Bangor
ME
04401

Jessica
Fay
207-555-7870
973 Lincoln Street
Glenburn
ME
04401

Harris
Bradley
207-555-0613
2398 Maple Street
Bangor
ME
04401

Pat
Midford
207-555-2591
38 Winter Street
Bangor
ME
04401

Connie
Essex
207-555-3001
392 Rodney Street
Bangor
ME
04401

9
Xander’s Café
Xander
Parker
207-555-2064
44 Larkin Street
Glenburn
ME
04401

10
Park Condo Association
Kenny
Thompson
207-555-1913
2646 Park Street
Bangor
ME
04402

Jo
Norris
207-555-7074
9 Railroad Street
Bangor
ME
04401

12
Mendez Accounting
Jose
Mendez
207-555-4193
778 Union Street
Bangor
ME
04401

13
Long Dry Goods
Miranda
Long
207-555-0084
24 Brook Street
Bangor
ME
04402

Lisa
Alfanador
207-555-5274
89 Fawn Court
Bangor
ME
04401

15
The Soup Wagon
Tamara
Smith
207-555-7478
65 Silk Street
Bangor
ME
04401

16
The Doughnut Spot
Jose
Jiminez
207-555-6240
927 Parkway North
Glenburn
ME
04401

Alex
Borgen
207-555-0092
456 Clover Lane
Bangor
ME
04402

Stephen
Mayers
207-555-4074
4640 Willow Way
Bangor
ME
04402

Aurelia
Doren
207-555-6517
1293 Longmeadow Drive
Bangor
ME
04401

Lester
Flynn
207-555-2691
15 Floyd Street
Glenburn
ME
04401

21
Pony Grill
Kari
Michelon
207-555-4887
3118 Cresecent Street
Veazie
ME
04401

22
Bangor Senior Living Center
Will
Coatil
207-555-9912
494 Oak Grove Drive
Glenburn
ME
04401

23
High Estate Realtors
Sandy
Frankel
207-555-8025
535 Penobscot Street
Glenburn
ME
04401

Paul
Raymond
207-555-6543
2565 State Street
Bangor
ME
04401

George
Rooney
207-555-3470
4457 North Main Street
Veazie
ME
94301

26
King Groceries
Doreen
Howard
207-555-6733
4169 Capri Street
Bangor
ME
94612

AgreementNum
ClientID
InvDate
InvAmt
Paid
InvNo

1301
1
2013-01-09
¤ 30.00
true
1301-001

1418
19
2014-11-26
¤ 25.00
true
1411-026

1301
1
2013-01-29
¤ 120.00
true
1301-009

1306
12
2013-01-16
¤ 700.00
true
1301-005

1408
7
2014-10-22
¤ 20.00
true
1410-016

1316
22
2013-12-17
¤ 335.00
true
1312-023

1313
13
2013-12-28
¤ 700.00
true
1312-029

1401
13
2014-11-30
¤ 1,400.00
true
1411-027

1415
21
2014-12-29
¤ 1,100.00
false
1412-034

1402
26
2014-01-16
¤ 120.00
true
1401-001

1302
19
2013-01-10
¤ 20.00
true
1301-004

1302
19
2013-01-29
¤ 80.00
true
1301-012

1307
3
2013-01-29
¤ 120.00
true
1301-008

1409
14
2014-10-23
¤ 20.00
true
1410-017

1309
5
2013-11-20
¤ 35.00
true
1311-015

1312
15
2014-01-30
¤ 2,200.00
true
1401-007

1317
20
2013-12-28
¤ 80.00
true
1312-028

1404
4
2014-02-28
¤ 1,160.00
true
1402-012

1319
18
2013-12-28
¤ 350.00
true
1312-027

1412
6
2014-11-10
¤ 19.00
true
1411-020

1418
19
2014-12-29
¤ 75.00
false
1412-037

1421
11
2014-12-09
¤ 25.00
true
1412-030

1411
3
2014-12-29
¤ 66.00
false
1412-044

1408
7
2014-12-29
¤ 80.00
false
1412-038

1309
5
2013-12-28
¤ 140.00
true
1312-030

1416
1
2014-11-25
¤ 30.00
true
1411-023

1310
14
2013-11-30
¤ 20.00
true
1311-016

1402
26
2014-01-30
¤ 480.00
true
1401-009

1318
24
2013-12-28
¤ 80.00
true
1312-026

1413
16
2014-11-20
¤ 1,110.00
true
1411-021

1422
25
2014-12-11
¤ 100.00
true
1412-031

1412
6
2014-12-29
¤ 76.00
false
1412-040

1405
8
2014-02-28
¤ 50.00
false
1402-011

1405
8
2014-01-22
¤ 25.00
true
1401-004

1413
16
2014-12-29
¤ 1,220.00
false
1412-041

1403
12
2014-01-16
¤ 250.00
true
1401-002

1303
4
2013-01-29
¤ 1,200.00
false
1301-011

1316
22
2013-12-28
¤ 1,340.00
true
1312-025

1311
11
2013-12-06
¤ 25.00
true
1312-017

1406
5
2014-01-25
¤ 50.00
true
1401-005

1414
17
2014-11-25
¤ 25.00
true
1411-024

1401
13
2014-10-12
¤ 350.00
true
1410-014

1407
2
2014-12-29
¤ 68.00
false
1412-042

1404
4
2014-01-22
¤ 290.00
true
1401-003

1312
15
2013-12-08
¤ 1,100.00
true
1312-018

1304
16
2013-02-28
¤ 2,800.00
true
1302-014

1314
9
2013-12-28
¤ 1,120.00
true
1312-024

1313
13
2014-01-30
¤ 1,050.00
true
1401-008

1304
16
2013-01-16
¤ 700.00
true
1301-007

1317
20
2013-12-17
¤ 20.00
true
1312-022

1403
12
2014-01-30
¤ 1,000.00
true
1401-010

1414
17
2014-12-29
¤ 50.00
false
1412-043

1308
25
2013-01-29
¤ 450.00
true
1301-013

1314
9
2013-12-08
¤ 280.00
true
1312-019

1410
24
2014-11-04
¤ 25.00
true
1411-019

1311
11
2013-12-28
¤ 100.00
true
1312-033

1423
15
2014-12-17
¤ 1,000.00
false
1412-032

1303
4
2013-01-10
¤ 300.00
true
1301-003

1417
10
2014-11-25
¤ 110.00
true
1411-025

1419
23
2014-12-02
¤ 315.00
true
1412-028

1319
18
2014-01-30
¤ 400.00
false
1401-006

1410
24
2014-12-29
¤ 100.00
false
1412-039

1310
14
2013-12-28
¤ 80.00
true
1312-034

1312
15
2013-12-28
¤ 1,200.00
true
1312-032

1416
1
2014-12-29
¤ 60.00
false
1412-036

1407
2
2014-10-19
¤ 17.00
false
1410-015

1315
17
2013-12-28
¤ 76.00
true
1312-031

1420
9
2014-12-09
¤ 290.00
true
1412-029

1318
24
2013-12-17
¤ 20.00
true
1312-021

1409
14
2014-12-29
¤ 80.00
false
1412-035

1306
12
2013-01-29
¤ 1,000.00
true
1301-010

1315
17
2013-12-11
¤ 19.00
true
1312-020

1415
21
2014-11-25
¤ 550.00
true
1411-022

1406
5
2014-02-28
¤ 200.00
true
1402-013

1417
10
2014-12-29
¤ 220.00
false
1412-033

1307
3
2013-01-10
¤ 20.00
true
1301-002

1411
3
2014-11-04
¤ 33.00
true
1411-018

1305
7
2013-01-16
¤ 100.00
true
1301-006

Client ID
Amount
Date Signed
AgreementNum

1
¤ 150.00
2013-01-09
1301

19
¤ 100.00
2013-01-10
1302

4
¤ 1,500.00
2013-01-10
1303

16
¤ 3,500.00
2013-01-16
1304

7
¤ 100.00
2013-01-16
1305

12
¤ 1,250.00
2013-01-19
1306

3
¤ 120.00
2013-01-22
1307

25
¤ 450.00
2013-01-29
1308

5
¤ 175.00
2013-11-20
1309

14
¤ 100.00
2013-11-30
1310

11
¤ 125.00
2013-12-06
1311

13
¤ 1,750.00
2013-12-08
1312

9
¤ 1,400.00
2013-12-08
1313

15
¤ 4,500.00
2013-12-08
1314

17
¤ 95.00
2013-12-11
1315

22
¤ 1,675.00
2013-12-17
1316

20
¤ 100.00
2013-12-17
1317

24
¤ 100.00
2013-12-17
1318

18
¤ 750.00
2013-12-29
1319

26
¤ 600.00
2014-01-16
1401

12
¤ 1,250.00
2014-01-16
1402

4
¤ 1,450.00
2014-01-22
1403

8
¤ 75.00
2014-01-22
1404

5
¤ 250.00
2014-01-25
1405

13
¤ 1,750.00
2014-10-12
1406

2
¤ 85.00
2014-10-19
1407

7
¤ 100.00
2014-10-22
1408

14
¤ 100.00
2014-10-23
1409

24
¤ 125.00
2014-11-04
1410

3
¤ 165.00
2014-11-04
1411

6
¤ 95.00
2014-11-10
1412

16
¤ 3,555.00
2014-11-20
1413

21
¤ 2,750.00
2014-11-25
1414

1
¤ 150.00
2014-11-25
1415

10
¤ 550.00
2014-11-25
1416

17
¤ 125.00
2014-11-25
1417

19
¤ 125.00
2014-11-26
1418

23
¤ 1,575.00
2014-12-02
1419

9
¤ 1,450.00
2014-12-09
1420

11
¤ 125.00
2014-12-09
1421

25
¤ 500.00
2014-12-11
1422

15
¤ 5,000.00
2014-12-17
1423

Chapter 18/Chapter/Solar18.accdb

ContractID
CustomerID
ContractValue
DateSigned

1301-KS
1
¤ 500.00
2013-02-09

1302-KS
1
¤ 14,000.00
2013-03-03

1303-MP
16
¤ 1,150.00
2013-03-16

1304-MP
22
¤ 1,200.00
2013-04-10

1305-KF
3
¤ 805.00
2013-04-22

1306-MP
23
¤ 1,100.00
2013-04-29

1307-MP
34
¤ 68,000.00
2013-07-07

1308-RR
5
¤ 620.00
2013-07-07

1309-KF
32
¤ 650.00
2013-07-23

1310-KS
32
¤ 14,000.00
2013-07-30

1311-RR
25
¤ 800.00
2013-08-09

1312-KF
11
¤ 450.00
2013-08-16

1313-MP
16
¤ 89,000.00
2013-08-26

1314-KS
26
¤ 25,500.00
2013-09-03

1315-KF
24
¤ 25,000.00
2013-09-04

1316-RR
17
¤ 550.00
2013-09-11

1317-RR
5
¤ 16,500.00
2013-09-17

1318-MP
2
¤ 690.00
2013-09-30

1319-RR
30
¤ 1,200.00
2013-10-08

1320-RR
25
¤ 32,500.00
2013-10-15

1321-KF
11
¤ 15,500.00
2013-10-15

1322-KF
3
¤ 18,000.00
2013-10-20

1323-RR
25
¤ 39,000.00
2013-11-07

1401-KF
28
¤ 30,800.00
2014-01-12

1402-KS
34
¤ 34,000.00
2014-01-16

1403-MP
2
¤ 20,000.00
2014-01-26

1404-RR
25
¤ 138,000.00
2014-02-18

1405-RR
17
¤ 14,500.00
2014-02-22

1406-KF
21
¤ 15,750.00
2014-03-11

1407-KF
31
¤ 550.00
2014-03-26

1408-MP
28
¤ 165,000.00
2014-03-26

1409-KS
20
¤ 1,000.00
2014-04-08

1410-RR
29
¤ 900.00
2014-04-23

1411-MP
9
¤ 16,500.00
2014-04-23

1412-AD
31
¤ 37,000.00
2014-04-29

1413-RR
10
¤ 22,800.00
2014-04-29

1414-AD
19
¤ 700.00
2014-05-04

1415-KS
20
¤ 23,750.00
2014-05-10

1416-AD
15
¤ 205,000.00
2014-05-20

1417-MP
12
¤ 1,150.00
2014-06-01

1418-RR
31
¤ 46,000.00
2014-06-04

1419-KS
13
¤ 575.00
2014-06-12

1420-AD
19
¤ 18,500.00
2014-06-12

1421-KS
6
¤ 25,500.00
2014-06-29

1422-MP
14
¤ 14,500.00
2014-07-14

1423-RR
27
¤ 37,250.00
2014-07-26

1424-MP
18
¤ 35,000.00
2014-07-30

1425-KS
4
¤ 6,500.00
2014-08-09

1426-RR
8
¤ 15,000.00
2014-08-10

1427-AD
13
¤ 38,500.00
2014-08-11

1428-AD
25
¤ 50,000.00
2014-08-17

1429-MP
7
¤ 875.00
2014-08-23

1430-AD
25
¤ 41,000.00
2014-09-02

1431-AD
33
¤ 132,000.00
2014-09-09

CustomerID
LastName
FirstName
Company
Street
City
State
Zip
Phone
Email

1
Tam
Dennis

2930 Duck Creek Road
Palo Alto
CA
94306
650-555-3132
dtam@onecalweb.com

2
Derrick
Barbara

2071 Clifford Street
Oakland
CA
94612
510-555-5217
bderrick@interoaklandweb.com

3
Sharma
Sumiko

53 Wolf Pen Road
Redwood City
CA
94063
650-555-6578
ssharma@redwoodplanet.net

4
Stanwood
Misti
Brisbane Engineering Dept.
4118 Straite Road
Brisbane
CA
94005
650-555-6869
mstanwood@brisbaneeng.net

5
Faries
Leopold

438 Boring Lane
Dublin
CA
94568
415-555-7870
lfaries@onecalweb.com

6
Schumer
Bradley

2547 Hillview Drive
San Francisco
CA
94103
707-555-0613
bschumer@onecalweb.com

7
Grady
Yvette
San Rafael Medical Partners
4287 Roosevelt Street
San Rafael
CA
94903
415-555-2591
ygrady@sanrafmed.net

8
Colberg
Chung

1626 Fairway Drive
Oakland
CA
94612
707-555-3001
ccolberg@onecalweb.com

9
Selin
Xenia
Jack’s Café
1675 Meadow Lane
Oakland
CA
94612
707-555-2064
xselin@onecalweb.com

10
Kennison
Pamela
Pleasanton Waldorf School
2646 Park Street
Pleasanton
CA
94588
925-555-1913
pkennison@pleasantonwaldorf.net

11
Christofferson
Khali

3348 Delaware Avenue
San Francisco
CA
94124
415-555-7074
kchristofferson@onecalweb.com

12
Tedeschi
Anthony
M. Doufay Financial
981 Fairway Drive
Concord
CA
94520
707-555-4193
itedeschi@doufayfinancial.com

13
Miga
Manda
Oak Roots Development
1505 Thunder Road
Oakland
CA
94612
650-555-0084
mmiga@oakrootsdev.com

14
Walker
Frank

3722 Davis Avenue
Fremont
CA
94539
707-555-5274
dwelker@onecalweb.com

15
Stille
Tamara
Prentice College
2793 Wayside Lane
Oakland
CA
94612
510-555-7478
tstille@prentice.edu

16
Ferebee
Julianne
Oakland Neighborhood Development
3033 Beech Street
Oakland
CA
94612
925-555-6240
jferebee@interoaklandweb.com

17
Lemaire
Alexa

2916 Friendship Lane
Oakland
CA
94612
408-555-0092
alemaire@interoaklandweb.com

18
Borgmeyer
Emerita

4430 Marietta Street
Rohnert Park
CA
94928
707-555-4074
eborgmeyer@onecalweb.com

19
Doten
Al

4591 Haverford Road
San Carlos
CA
94070
650-555-6517
adoten@onecalweb.com

20
Hartt
Cecille
Sauerbrook & Mars Fashions
3144 Ringland Lane
San Francisco
CA
94110
415-555-2691
chartt@sauerbrookmars.com

21
Arter
Kathleen
Prancing Pony Grill
3118 Roosevelt Street
San Francisco
CA
94108
415-555-4887
karter@prancingponygrill.com

22
Wilcox
Jennifer
Swan Senior Living Center
494 Friendship Lane
Oakland
CA
94607
408-555-9912
jwilcox@swanseniorcenter.com

23
Fry
Juanita
Bay Area Communities United
535 Locust View Drive
San Francisco
CA
94105
415-555-8025
jfry@onecalweb.com

24
Hearns
Raymond

2565 Beech Street
Oakland
CA
94607
925-555-6543
rhearns@interoaklandweb.com

25
Frevert
Krystle
LKW Construction
4457 Water Street
Palo Alto
CA
94301
650-555-3470
kfrevert@lkwdconstruction.com

26
Puig
Jacob
Liehe Contracting
4169 Clifford Street
Oakland
CA
94612
510-555-6733
jpuig@liehecontracting.biz

27
Gallivan
Melanie
Happy Skies Day Care
4997 Park Street
Pleasanton
CA
94566
925-555-8069
mgallivan@onecalweb.com

28
Marcell
Angela
Greenleaf Builders
464 Wolf Pen Road
Concord
CA
94520
650-555-9985
amarcell@onecalweb.com

29
Neyhart
Maryann
Duschesne Investment Corp.
3641 Black Oak Hollow Road
Sunnyvale
CA
94089
408-555-1707
mneyhart@duschesneinvestments.com

30
Ansari
Janelle
Watering Hole Mini Golf
791 Brown Street
Walnut Creek
CA
94596
925-555-9101
jansari@onecalweb.com

31
Bruneau
Latasha
Sierra Nevada Contracting
3768 Delaware Avenue
San Francisco
CA
94115
415-555-4969
lbruneau@sierranevadacontracting.com

32
Klinkhammer
Annalisa

4575 Wounterman Road
Dublin
CA
94568
650-555-3803
aklinkhammer@calocal123.com

33
Yamada
Sachiko
Yamada Architects, Inc.
1185 Park Avenue
Sacramento
CA
94260
916-555-3776
syamada@onecalweb.com

34
Chen
Ralph
Chen Builders
18 Market Street
Oakland
CA
94612
415-555-9370
rchen@interoaklandweb.com

42
Chappelle
Maggie

1370 Leavenworth Avenue
San Francisco
CA
94106
415-555-7420
mchappelle@onecalweb.com

InvNum
ContractID
InvDate
Amount
Paid

1302-001
1301-KS
2013-02-18
¤ 500.00
true

1304-002
1303-MP
2013-04-01
¤ 1,150.00
true

1304-003
1304-MP
2013-04-29
¤ 1,200.00
true

1305-004
1302-KS
2013-05-10
¤ 12,500.00
true

1305-005
1306-MP
2013-05-15
¤ 1,100.00
true

1305-006
1305-KF
2013-05-30
¤ 800.00
true

1306-007
1302-KS
2013-06-09
¤ 1,500.00
true

1307-008
1307-MP
2013-07-07
¤ 13,600.00
true

1307-009
1308-RR
2013-07-15
¤ 620.00
true

1307-010
1309-KF
2013-07-23
¤ 650.00
true

1308-011
1310-KS
2013-08-15
¤ 2,800.00
true

1308-012
1312-KF
2013-08-28
¤ 450.00
true

1308-013
1311-RR
2013-08-29
¤ 800.00
true

1309-014
1314-KS
2013-09-15
¤ 5,100.00
true

1309-015
1315-KF
2013-09-15
¤ 2,500.00
true

1309-016
1313-MP
2013-09-29
¤ 17,800.00
true

1309-017
1316-RR
2013-09-29
¤ 550.00
true

1310-018
1318-MP
2013-10-15
¤ 690.00
true

1310-019
1317-RR
2013-10-15
¤ 3,500.00
true

1310-020
1319-RR
2013-10-15
¤ 1,200.00
true

1311-021
1321-KF
2013-11-12
¤ 8,500.00
true

1311-022
1320-RR
2013-11-15
¤ 6,500.00
true

1311-023
1323-RR
2013-11-15
¤ 7,800.00
true

1311-024
1314-KS
2013-11-15
¤ 20,400.00
true

1311-025
1315-KF
2013-11-15
¤ 22,500.00
true

1311-026
1313-MP
2013-11-29
¤ 45,600.00
true

1312-027
1323-RR
2013-12-15
¤ 12,480.00
true

1312-028
1322-KF
2013-12-21
¤ 15,000.00
false

1312-029
1317-RR
2013-12-23
¤ 8,000.00
true

1312-030
1320-RR
2013-12-29
¤ 13,000.00
true

1401-001
1321-KF
2014-01-12
¤ 7,000.00
true

1401-002
1323-RR
2014-01-15
¤ 18,720.00
true

1401-003
1313-MP
2014-01-29
¤ 25,600.00
true

1401-004
1320-RR
2014-01-29
¤ 8,500.00
true

1401-005
1401-KF
2014-01-29
¤ 6,160.00
true

1401-006
1322-KF
2014-01-31
¤ 3,000.00
false

1402-007
1317-RR
2014-02-12
¤ 5,000.00
true

1402-008
1320-RR
2014-02-14
¤ 4,500.00
true

1402-009
1401-KF
2014-02-14
¤ 24,640.00
true

1402-010
1404-RR
2014-02-28
¤ 18,000.00
true

1403-011
1403-MP
2014-03-15
¤ 13,000.00
true

1403-012
1406-KF
2014-03-29
¤ 4,725.00
true

1403-013
1405-RR
2014-03-29
¤ 6,500.00
true

1404-014
1407-KF
2014-04-14
¤ 550.00
true

1404-015
1408-MP
2014-04-14
¤ 33,000.00
true

1404-016
1409-KS
2014-04-15
¤ 1,000.00
true

1404-017
1404-RR
2014-04-28
¤ 120,000.00
true

1405-018
1403-MP
2014-05-01
¤ 7,000.00
true

1405-019
1408-MP
2014-05-14
¤ 26,400.00
true

1405-020
1412-AD
2014-05-15
¤ 7,400.00
true

1405-021
1410-RR
2014-05-15
¤ 900.00
true

1405-022
1414-AD
2014-05-15
¤ 700.00
true

1405-023
1405-RR
2014-05-15
¤ 8,000.00
true

1405-024
1406-KF
2014-05-29
¤ 9,025.00
true

1405-025
1415-KS
2014-05-29
¤ 10,000.00
true

1405-026
1413-RR
2014-05-29
¤ 12,400.00
true

1406-027
1418-RR
2014-06-04
¤ 9,200.00
true

1406-028
1416-AD
2014-06-12
¤ 41,000.00
true

1406-029
1417-MP
2014-06-12
¤ 1,150.00
false

1406-030
1408-MP
2014-06-14
¤ 26,400.00
true

1406-031
1412-AD
2014-06-15
¤ 20,000.00
true

1406-032
1406-KF
2014-06-29
¤ 2,000.00
true

1406-033
1415-KS
2014-06-29
¤ 137,500.00
true

1406-034
1420-AD
2014-06-29
¤ 8,000.00
true

1406-035
1419-KS
2014-06-29
¤ 575.00
true

1407-036
1413-RR
2014-07-12
¤ 4,500.00
true

1407-037
1416-AD
2014-07-12
¤ 10,000.00
true

1407-038
1408-MP
2014-07-14
¤ 50,000.00
true

1407-039
1422-MP
2014-07-14
¤ 4,100.00
true

1407-040
1412-AD
2014-07-15
¤ 9,600.00
true

1407-041
1418-RR
2014-07-15
¤ 6,500.00
true

1407-042
1411-MP
2014-07-23
¤ 16,500.00
true

1408-043
1421-KS
2014-08-12
¤ 4,500.00
true

1408-044
1416-AD
2014-08-12
¤ 8,500.00
true

1408-045
1424-MP
2014-08-12
¤ 7,000.00
true

1408-046
1413-RR
2014-08-12
¤ 3,000.00
true

1408-047
1408-MP
2014-08-14
¤ 29,200.00
true

1408-048
1418-RR
2014-08-15
¤ 6,000.00
true

1408-049
1420-AD
2014-08-15
¤ 10,500.00
true

1408-050
1423-RR
2014-08-15
¤ 18,625.00
true

1408-051
1307-MP
2014-08-15
¤ 25,750.00
true

1408-052
1428-AD
2014-08-29
¤ 15,000.00
true

1409-053
1422-MP
2014-09-01
¤ 2,900.00
true

1409-054
1431-AD
2014-09-09
¤ 60,000.00
true

1409-055
1426-RR
2014-09-12
¤ 9,000.00
true

1409-056
1429-MP
2014-09-12
¤ 875.00
false

1409-057
1421-KS
2014-09-12
¤ 3,000.00
true

1409-058
1416-AD
2014-09-12
¤ 14,200.00
true

1409-059
1423-RR
2014-09-15
¤ 9,000.00
true

1409-060
1307-MP
2014-09-15
¤ 14,325.00
true

1409-061
1310-KS
2014-09-15
¤ 6,200.00
true

1409-062
1413-RR
2014-09-29
¤ 2,900.00
true

1409-063
1430-AD
2014-09-29
¤ 8,200.00
true

1409-064
1424-MP
2014-09-29
¤ 8,500.00
true

1410-065
1425-KS
2014-10-10
¤ 6,500.00
false

1410-066
1421-KS
2014-10-12
¤ 12,000.00
true

1410-067
1422-MP
2014-10-12
¤ 7,500.00
false

1410-068
1426-RR
2014-10-12
¤ 4,000.00
true

1410-069
1416-AD
2014-10-12
¤ 43,600.00
true

1410-070
1423-RR
2014-10-14
¤ 9,625.00
true

1410-071
1418-RR
2014-10-14
¤ 21,000.00
true

1410-072
1431-AD
2014-10-14
¤ 68,000.00
true

1410-073
1310-KS
2014-10-15
¤ 5,000.00
true

1410-074
1424-MP
2014-10-29
¤ 10,000.00
true

1410-075
1428-AD
2014-10-29
¤ 17,500.00
true

1411-076
1416-AD
2014-11-12
¤ 29,500.00
false

1411-077
1426-RR
2014-11-12
¤ 2,000.00
false

1411-078
1418-RR
2014-11-14
¤ 9,800.00
false

1411-079
1431-AD
2014-11-14
¤ 4,000.00
false

1411-080
1307-MP
2014-11-29
¤ 14,325.00
false

1411-081
1430-AD
2014-11-29
¤ 32,800.00
false

1411-082
1428-AD
2014-11-29
¤ 17,500.00
false

1411-083
1424-MP
2014-11-29
¤ 9,500.00
false

1412-084
1416-AD
2014-12-12
¤ 37,500.00
false

1412-085
1421-KS
2014-12-12
¤ 6,000.00
true

Chapter 18/On Your Own/Contacts18.accdb

ContactID
ContactFirst
ContactLast
Address
City
State
Zip
Phone

201
Ginger
Bell
2315 Philadelphia Avenue
Murray
UT
84107
801-966-0454

202
Leo
Wessel
2195 Scattershot Way
Salt Lake City
UT
84111
801-869-3378

203
Leonard
Black
784 Philadelphia Avenue
Salt Lake City
UT
84104
801-474-8135

205
Thomas
Friedel
4880 Tori Lane
Salt Lake City
UT
84116
801-573-3401

206
William
Tsan
2204 Buck Drive
Salt Lake City
UT
84111
801-490-1641

209
Robert
Pharr
595 Pignole Drive
West Valley City
UT
84119
801-483-3559

210
Tina
Allen
1950 Kemper Lane
Salt Lake City
UT
84116
801-981-0593

211
Alice
Cox
4879 Tori Lane
Salt Lake City
UT
84113
801-733-7017

212
Arthur
Miller
3613 Hickory Street
Salt Lake City
UT
84104
801-450-9220

215
Sarah
Robinson
4411 Walton Street
Salt Lake City
UT
84104
801-274-0595

216
Thomas
Mathis
2299 White River Way
Salt Lake City
UT
84111
801-570-0381

217
Lois
Augustine
1979 Thrice Way
Salt Lake City
UT
84106
801-488-3255

220
Kevin
Smith
3291 Kemper Lane
Murray
UT
84107
801-449-9225

221
Tracy
Kemp
3651 Plympton Lane
Kearns
UT
84118
801-440-5209

222
Cora
Velez
510 Walton Street
Salt Lake City
UT
84104
801-534-1420

225
Angel
Pinto
2983 Stringfeld Way
Salt Lake City
UT
84111
435-728-5245

228
John
Pittman
4132 Hickory Street
Salt Lake City
UT
84104
435-538-4925

229
Michelle
Frey
242 Sweetwater Drive
Salt Lake City
UT
84111
801-584-3146

230
Dan
Eason
1439 Tempest Avenue
Salt Lake City
UT
84116
801-795-7666