I have two access documents and their is instructions for both of them ..
First complete the guided project.
Second complete the Independent project .
Each one has Instructions … Please follow them.
Access 2016 Chapter 3 Creating and Using Queries Last Updated: 5/3/18 Page 1
USING MICROSOFT ACCESS 2016
Guided Project 3-2
San Diego Sailing Club wants to create three queries. To ensure consistency, the starting file is provided for you.
Use Design view to create, edit, add aggregate functions, and add criteria to a query to find the total dollar value
of the rentals for each boat in its fleet. After saving and testing the query, create a second query that uses
aggregate functions and a parameter. Finally, create a query to find which boat types have been rented. This
project has been modified for use in SIMnet®.
Skills Covered in This Project
• Create a query using Design view.
• Add fields to a query.
• Add criteria to a query.
• Execute a query.
• Save and test a query.
• Save a copy of a query.
• Add a parameter.
• Use aggregate functions.
• Use the Unique Values property.
1. Open the SailingDatabase-03.accdb database start file.
2. The file will be renamed automatically to include your name. Change the project file name if
directed to do so by your instructor.
3. Enable content in the security warning.
4. Create a new summary query in Design view. The Sailing Club wants to find out the total dollar
value of the full day rentals, by boat, from the boats that have been rented. If a boat has been
rented, there is a record in the SDRentals table.
a. Click the Query Design button [Create tab, Queries group] to open the Show Table dialog box.
b. Select the SailboatFleet table and click the Add button.
c. Select the SDRentals table and click the Add button.
d. Click the Close button in the Show Table dialog box.
e. Increase the size of the table objects to display all of the fields.
f. Click the drop-down arrow in the first Field row cell of the query design grid and select
SDRentals.FKBoatID.
g. Click the second cell in the Field row, click
the drop-down arrow, and select
SailboatFleet.BoatType.
h. Click the third cell in the Field row, click the
drop-down arrow, and select SailboatFleet.
FullDayRentalRate.
i. Click the fourth cell in the Field row, click the
drop-down arrow, and select SDRentals.
FourHourRental?.
j. Click the Totals button [Query Tools Design
tab, Show/Hide group].
k. Click the Run button [Query Tools Design tab,
Results group] to execute the query. The
query should open in Datasheet view and
display 16 records (Figure 3-86). This query
only shows boats that have been rented. At
This image appears when a project instruction has changed to accommodate an
update to Microsoft Office 365. If the instruction does not match your version of Office, try using the
alternate instruction instead.
Step 1:
Download
start file
Access 2016 Chapter 3 Creating and Using Queries Last Updated: 5/3/18 Page 2
USING MICROSOFT ACCESS 2016 Guided Project 3-2
most a Boat ID appears in two rows; one row if the Four Hour Rental? box is checked and
another row if the Four Hour Rental? box is not checked.
5. Edit the query to add aggregate functions. Because you are looking only for rentals that were for a
full day, use the “No” value on the FourHourRental? field.
a. Click the View button [Home tab, Views group] and select the Design View option to switch
back to Design view of the query.
b. Click the Total row cell for the FullDayRentalRate field.
c. Click the drop-down arrow and select Sum.
d. Click the Total row cell for the FourHourRental? field.
e. Click the drop-down arrow and select Where. This causes the Show row check box for the
FourHourRental? field to be deselected.
f. Click the Criteria row cell for the FourHourRental? field and enter No. The IntelliSense feature in
Access may suggest the value of “Now” while you are typing. Press the Esc key to hide the list
and then tab out of the field. The query window should look similar to Figure 3-87.
g. Click the Run button. The query should
open in Datasheet view and display
eight records (Figure 3-88). The Boat ID
now displays only once since the criteria
limits the results only to the full day
rentals.
6. Click the Save button and save the query as
FullDayRentalsByBoatSummary.
7. Verify that that query works correctly.
a. Open the SDRentals table in Datasheet
view.
b. Click the drop-down arrow in the Boat ID
field name cell.
c. Select the Sort A to Z option.
d. Click the drop-down arrow in the Four Hour Rental? field name cell.
e. Select the Sort Cleared to Selected option. You can see that Boat ID 1010 has five full day
rentals. From Figure 3-86 you know that the full day rate for that boat is $179.00 and 5 x $179 =
$895.00. This matches the results of your query.
f. Click the Remove Sort button [Home tab, Sort & Filter group].
g. Close the SDRentals table. If prompted, do not save the changes to the table.
8.
Save a copy of the query.
a. Click the Save As button [File Tab].
b. Select the Save Object As button and then click the Save As button.
Access 2016 Chapter 3 Creating and Using Queries Last Updated: 5/3/18 Page 3
USING MICROSOFT ACCESS 2016 Guided Project 3-2
c. Replace the suggested name with FullDayRentalsByBoatSummaryWithParameter. You edit
this copy of the query in step 9 to allow the Sailing Club to enter the date range for the
summary query and also to count the number of rentals.
9. Edit the query to add additional fields and an aggregate function and parameters.
a. Click the View button [Home tab, Views group] and select Design View.
b. Drag the FullDayRentalRate field from the SailboatFleet table to the fifth column in the query
design grid. (Yes, this field is in the query twice.)
c. Click the Total row cell for this field, click the drop-down arrow, and select Count.
d. Drag the RentalDate field from the SDRentals table to the sixth column in the query design grid.
e. Click the Total row cell for this field, click the drop-down arrow, and select Where. This causes
the Show row check box for the RentalDate field to be deselected.
f. Click the Criteria row cell of the RentalDate field.
g. Right-click and select Zoom.
h. Type Between [Enter the Start Date] And [Enter the End Date] in the Zoom box to add the
two parameters.
i. Click OK. The query window should look similar to Figure 3-89.
j. Click the Save button and save the changes to the query.
10. Test the query.
a. Click the Run button.
b. Enter 2/1/2017 in the Enter the Start Date box of the Enter Parameter Value dialog box.
c. Click OK.
Save a copy of the query.
a. Close the FullDayRentalsByBoatSummaryWithParameter query if still visible in Datasheet View.
Right-click the query in the Navigation pane, and click Copy
b. Right-click in the Navigation pane and click Paste. The Paste As dialog box opens. Type
FullDayRentalsByBoatSummaryWithParameter in the Paste As dialog box and click OK.
c. Double-click the FullDayRentalsByBoatSummaryWithParameter query in the Navigation
Pane to open the query in Datasheet view. You edit this copy of the query in step 9 to allow
the Sailing Club to enter the date range for the summary query and also to count the
number of rentals.
Access 2016 Chapter 3 Creating and Using Queries Last Updated: 5/3/18 Page 4
USING MICROSOFT ACCESS 2016 Guided Project 3-2
d. Enter 2/28/2017 in the Enter the End
Date box of the Enter Parameter Value
dialog box.
e. Click OK. The query should open in
Datasheet view and display the records
shown in Figure 3-90.
f. Click the Save button to save the
changes made to the query.
g. Close the query.
11. Review the query.
a. Reopen the query in Design view. Notice that Access has
reordered the position of the fields. The two fields that
use the Where option on the Total row have been
moved to the right side of the query design grid. This
does not affect the way the query runs.
b. Close the query.
12. Create a new query in Design view. The Sailing Club wants
to find out what boat types have been rented so it can
decide whether to adjust pricing or marketing on some of
its boat types. If a boat has been rented, a record of that
rental exists in the SDRentals table.
a. Click the Query Design button [Create tab, Queries
group] to open the Show Table dialog box.
b. Select the SDRentals table, press and hold the Shift key,
select the SailboatFleet table and click the Add button.
c. Click the Close button in the Show Table dialog box.
d. Click the drop-down arrow in the first Field row cell in the
query design grid and select SDRentals.FKBoatID.
e. Click the Sort row, click the drop-down arrow, and
select Ascending.
f. Click the second cell in the Field row, click the drop-
down arrow, and select SailboatFleet.BoatType.
g. Click the Run button [Query Tools Design tab, Results
group] to execute the query. The query should open in
Datasheet view and display 28 records (Figure 3-91).
Notice that in a number of instances the same Boat ID
displays multiple times, once for each time that boat
was rented.
13. Edit the query to display Unique Values.
a. Click the View button [Home tab, Views group] and select the Design View option to switch
back to Design view of the query.
b. Click the Property Sheet button [Query Tools Design tab, Show/Hide group] to open the
Property Sheet.
c. Click anywhere in the Query Window so that the Selection type in the Property Sheet displays
Query Properties.
d. Click the Unique Values property box and select Yes. The query window should look similar to
Figure 3-92.
Access 2016 Chapter 3 Creating and Using Queries Last Updated: 5/3/18 Page 5
USING MICROSOFT ACCESS 2016 Guided Project 3-2
e. Close the Property Sheet.
f. Click the Run button. The query should open in Datasheet view
and display 12 records (Figure 3-93). Each Boat ID now displays
only once, but the Boat Types are still repeated.
14. Edit the query so the Boat Type displays only once. The Boat Type is
displaying more than once because the FKBoatID field is different for
each boat.
a. Click the View button [Home tab, Views group] and select the
Design View option to switch back to Design view.
b. Click the Sort row of the FKBoatID field, click the drop-down arrow,
and select (not sorted).
c. Deselect the Show row check box for the
FKBoatID field.
d. Click the Run button. The query should
display the five boat types that have been
rented at least once (Figure 3-94.)
e. Click the Save button and save the query as
BoatTypesRented.
f. Close the query.
15. Close the database.
16. Upload and save your project file.
17. Submit project for grading.
Step 2
Upload &
Save
Step 3
Grade my
Project
- Guided Project 3-2
Skills Covered in This Project
| BoatID | BoatType | Length | Seats | Sleeps | FourHourRentalRate | FullDayRentalRate | GalleyWithStove | ModelYear | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10 | Catalina 270 | 2 | 8 | 4 | 6 | ¤ 139.00 | ¤ 179.00 | true | 1997 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1015 | 28’4″ | 1998 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1146 | Hunter 33 | 33’6″ | ¤ 299.00 | ¤ 349.00 | 2003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1150 | Capri 22 Mk II | 24’8″ | ¤ 65.00 | ¤ 89.00 | false | 2004 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1152 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1164 | 2006 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1168 | 2007 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1175 | Beneteau 40 | 39’10” | 12 | ¤ 489.00 | ¤ 529.00 | 2008 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1180 | Beneteau 373 | 36’11” | ¤ 369.00 | ¤ 409.00 | 2009 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1185 | Hunter 36 | 35’6″ | ¤ 389.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1190 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1200 | 2010 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1205 | 2011 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1225 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1254 | 2012 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1310 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1401 | 2014 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1410 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1419 |
| RentalID | FKBoatID | RentalDate | FourHourRental? | MemberID | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| 08032 | 1/15/17 | 1122 | |||||||||
| 08033 | 1386 | ||||||||||
| 08035 | 1010 | 1/18/17 | 1212 | ||||||||
| 08036 | 1/23/17 | 1197 | |||||||||
| 08037 | 1/27/17 | 1075 | |||||||||
| 08040 | 2/2/17 | ||||||||||
| 08045 | 2/9/17 | ||||||||||
| 08046 | 1427 | ||||||||||
| 08048 | 2/12/17 | 1592 | |||||||||
| 08049 | 2/14/17 | 1283 | |||||||||
| 08050 | 2/15/17 | ||||||||||
| 08051 | |||||||||||
| 08053 | 2/17/17 | 1003 | |||||||||
| 08054 | 2/18/17 | ||||||||||
| 08055 | 2/19/17 | 1341 | |||||||||
| 08056 | 2/20/17 | ||||||||||
| 08060 | 2/28/17 | ||||||||||
| 08061 | |||||||||||
| 08063 | 3/3/17 | ||||||||||
| 08064 | 3/6/17 | ||||||||||
| 08075 | 3/22/17 | ||||||||||
| 08076 | 3/23/17 | 1059 | |||||||||
| 08077 | 3/24/17 | ||||||||||
| 08079 | |||||||||||
| 08080 | 1494 | ||||||||||
| 08081 | |||||||||||
| 08082 | 3/25/17 | ||||||||||
| 08083 | 3/26/17 |
Access 2016 Chapter 3 Creating and Using Queries Last Updated: 10/9/18 Page 1
USING MICROSOFT ACCESS 2016 Independent Project 3-5
Independent Project 3-5
The State of New York Department of Motor Vehicles wants to create three queries. The first query provides summary
data on the number of tickets by city and violation. The second query summarizes the total tickets by violation. The third
query provides summary data for the total fines assessed against each driver who has had a ticket. To ensure consistency,
the starting file is provided for you. Use Design view to create the summary queries. Edit the queries to add fields,
aggregate functions, and sorting. Finally, save and run the queries. This project has been modified for use in SIMnet®.
Skills Covered in This Project
• Create a summary query in Design view.
• Edit a query in Design view.
• Add fields to a query.
• Execute a query.
• Save a query.
• Sort query results.
• Add aggregate functions.
1. Open the NewYorkDMV-03.accdb database start file.
2. The file will be renamed automatically to include your name. Change the project file name if
directed to do so by your instructor.
3. Enable content in the security warning.
4. Create a new summary query in Design view. The query counts the number of tickets issued by
city and violation.
a. Add the Tickets table into the
Query Design
window.
b. Increase the size of the table
object to display all of the
fields.
c. Add the following fields into the
query: City, PrimaryFactor, and
TicketNumber.
d. Add the Total row to the query.
e. Group By the City and
PrimaryFactor fields and Count
the TicketNumber field.
5. Save the query as
TicketCountByCityAndFactor.
6. Run the query. The datasheet
should display 22 records.
7. Widen the field column widths
using AutoFit or Best Fit. The
datasheet should be similar to
Figure 3-103.
8. Save the changes to the query.
9. Save a copy of the query as
TicketCountByFactor.
10. Edit the TicketCountByFactor query
in Design view. The query should
show the total tickets issued for each violation factor, sorted in descending order by count.
a. Delete the City field.
b. Sort the TicketNumber field in descending order.
Step 1:
Download
start file
Access 2016 Chapter 3 Creating and Using Queries Last Updated: 10/9/18 Page 2
USING MICROSOFT ACCESS 2016 Independent Project 3-5
11. Save and run the query. The datasheet
should match Figure 3-104.
12. Close the query.
13. Create a new summary query in Design
view. The query provides summary data on
the total fines assessed against each driver.
a. Add both tables into the Query Design
window.
b. Increase the size of the table objects to
display all of the fields.
c. Add the following fields into the query:
LicenseNumber, FirstName, LastName,
Fine, and TicketNumber.
d. Add the Total row to the query.
e. Group By the LicenseNumber, FirstName,
and LastName fields, Sum the Fine field
and Count the TicketNumber field.
f. Sort the Fine field in descending order.
14. Save the query as TicketsByDriver.
15. Run the query. The datasheet should display 24 drivers who have received tickets, sorted in
descending order by the total dollar amount of their fines (Figure 3-105).
16. Close the query.
17. Close the database.
18. Upload and save your
project file.
19. Submit project for grading.
Step 2
Upload &
Save
Step 3
Grade my
Project
| LicenseNumber | BirthDate | LastName | F | Address | City | State | ZIP | Gender | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10000501 | 3/12/47 | Smith | Timothy | 274 W 145th Street | New York | NY | 10039 | M | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 10001786 | 11/11/47 | Johns | Sanda | 321 Deforest Road | Syracuse | 13214 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 10003086 | 1/12/62 | Williams | Mark | 345 E 73rd Street | 10021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 10004372 | 1/21/64 | Brown | Kathy | 448 E. 88th Street #5B | 10128 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 10004387 | 2/7/68 | Jon | Miranda | 433 E. 80th Street | 10075 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 10004672 | 9/4/69 | Miller | Steve | 609 Church Street | 13212 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12344537 | 10/23/72 | Davis | Austin | 903 Champlin Avenue | Utica | 13502 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12345678 | 7/11/73 | Garcia | Emily | 288 Kimball Avenue | Yonkers | 10704 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12345823 | 11/10/73 | Rodriguez | Franco | 131 Ridgewood Circle | Buffalo | 14218 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12345838 | 4/14/73 | Wilson | Eric | 24 Alwin Place | 14211 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12346123 | 11/25/73 | Schooler | Claudia | 748 South Street #2 | 13501 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12346251 | 12/13/73 | Pelayo | Randy | 74 Morris Street | Albany | 12208 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12346377 | 2/1/74 | Greg | 72 Wylie Street | Schenectady | 12307 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12346978 | 2/7/74 | Juarez | 118 Boyden Street | 13202 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12348264 | 5/12/74 | Carter | Kevin | 38 Cliff Street | 10701 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12348279 | 5/15/74 | Altier | Sharon | 180 Wyoming Avenue | 14215 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12348564 | 7/21/74 | Gates | Kristin | 1122 Lexington Avenue | 12309 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12348692 | 8/20/74 | Finch | Michael | 28 Besch Avenue | 12209 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12388495 | 7/15/76 | Krentler | Amanda | 1022 WeStreet Street | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12388510 | 7/19/76 | Rios | Carlos | 1815 Bleecker Street | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12388795 | 3/7/79 | Doiron | Caroline | 418 Spratt Place | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12388923 | 3/22/79 | Singh | Mehdi | 118 Manning Boulevard | 12203 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12389049 | 4/17/79 | Hirshman | Bonnie | 299 Clinton Avenue | 12210 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12390334 | 4/15/79 | Kerr | 603 Ravine Drive | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12394037 | 9/30/79 | Plice | Haley | 428 Whitehall Road | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12394163 | 10/30/79 | Harvey | Jake | 705 Renaissance Drive | 14221 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12395448 | 11/1/79 | Tyler | Jackie | 98 Manhart Street | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12396748 | 11/6/79 | Bertram | James | 720 Albany Street | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12398034 | 8/23/80 | Peters | Richard | 152 Edna Place | 14209 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 15500501 | 10/10/80 | Addo | 446 Herkimer Street | 14213 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 15500786 | 10/24/80 | Shin | Brian | 50 Main Street | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 15500914 | 3/19/81 | Taylor | Michelle | 111 Morris Street #1 | 10705 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 15501040 | 8/9/82 | Fishberg | 526 Altamont Avenue | 12303 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 15502325 | 8/24/82 | Stokes | Ron | 359 Warburton Avenue | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 15503625 | 3/26/85 | Norman | Corey | 503 Joanne Drive | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 18955678 | 5/7/85 | Rizzo | 39 Moultie Avenue | 10710 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 18955806 | 8/11/85 | Nancy | 2906 Grant Boulevard | 13208 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 18955932 | 9/5/85 | Moyers | Molly | 80 Westgate Road | 14217 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 18957217 | 10/22/86 | Healy | Jessica | 1025 Warren Street | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 18958517 | 7/4/88 | Valenzuela | Kaitlin | 6298 Stage Road | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 39988495 | 7/6/88 | Lucy | 238 Marshall Avenue | 12304 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 39989780 | 5/20/89 | Nguyen | 358 Breckenridge Street | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 39991080 | 11/28/89 | Kirby | Kayla | 27 Lawrence Street | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 39992366 | 9/25/93 | Watson | 213 Garfield Street | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 39992381 | 10/2/97 | Larson | Annie | 89 Robinson Street | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 39992387 | 10/1/97 | Caton | Kiana | 2567 Woodman Street |
| TicketNumber | DLNumber | TicketDate | PrimaryFactor | OfficerBadgeNumber | Fine | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4235879527 | 1/4/16 | Unsafe Speed | A00032567 | ¤ 360.00 | |||||||||||||||||||||||
| 4235879530 | 1/7/16 | Passing/Lane Violations | A00061444 | ¤ 150.00 | |||||||||||||||||||||||
| 4235879534 | 1/10/16 | A00045729 | ¤ 130.00 | ||||||||||||||||||||||||
| 4235879759 | 1/15/16 | Alcohol | A00057706 | ¤ 400.00 | |||||||||||||||||||||||
| 4235879760 | 1/16/16 | ||||||||||||||||||||||||||
| 4235879761 | 1/18/16 | ¤ 90.00 | |||||||||||||||||||||||||
| 4235889527 | 1/26/16 | ||||||||||||||||||||||||||
| 4235893852 | 2/1/16 | ¤ 45.00 | |||||||||||||||||||||||||
| 4235893950 | 2/2/16 | Traffic Control Disregarded | |||||||||||||||||||||||||
| 4235893968 | 2/6/16 | Backing Unsafely | ¤ 60.00 | ||||||||||||||||||||||||
| 4235894281 | 2/11/16 | A00092385 | |||||||||||||||||||||||||
| 4235894283 | 2/12/16 | ||||||||||||||||||||||||||
| 4235894307 | |||||||||||||||||||||||||||
| 4235894327 | 2/13/16 | ||||||||||||||||||||||||||
| 4235894352 | 2/14/16 | ¤ 120.00 | |||||||||||||||||||||||||
| 4235894379 | 2/15/16 | ||||||||||||||||||||||||||
| 4235894386 | 2/16/16 | ||||||||||||||||||||||||||
| 4235894388 | |||||||||||||||||||||||||||
| 4235894390 | A00056591 | ||||||||||||||||||||||||||
| 4235894394 | ¤ 180.00 | ||||||||||||||||||||||||||
| 4235894399 | 2/19/16 | ||||||||||||||||||||||||||
| 4235894427 | 3/20/16 | Turning Improperly | A00061403 | ||||||||||||||||||||||||
| 4235894473 | 3/11/16 | Driver Distraction | |||||||||||||||||||||||||
| 4235894496 | 3/25/16 | A00021411 | |||||||||||||||||||||||||
| 4235894590 | 3/29/16 | ||||||||||||||||||||||||||
| 4235894823 | 4/6/16 | Failure to Keep Right | |||||||||||||||||||||||||
| 4235894914 | 4/8/16 | ||||||||||||||||||||||||||
| 4235895001 | 4/10/16 | ||||||||||||||||||||||||||
| 4235895049 | 4/13/16 | ||||||||||||||||||||||||||
| 4235895082 | 4/14/16 | ||||||||||||||||||||||||||
| 4235895110 | 4/15/16 | ||||||||||||||||||||||||||
| 4235895121 | |||||||||||||||||||||||||||
| 4235895197 | 4/20/16 | ||||||||||||||||||||||||||
| 4235895280 | 4/24/16 | ||||||||||||||||||||||||||
| 4235895648 | 5/11/16 | ||||||||||||||||||||||||||
| 4235895673 | 5/13/16 | ||||||||||||||||||||||||||
| 4235896886 | 5/14/16 | ||||||||||||||||||||||||||
| 4235896888 | |||||||||||||||||||||||||||
| 4235896903 | 5/15/16 | ||||||||||||||||||||||||||
| 4235896915 |
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
