For this assignment, continue using your Momentum Legal Database $($version as of the end of the assignment for Module $8.$ Here are some tasks and skills that you might use in your job.

$1)$ Filter the following records

a$.$ Client list by City, Ottawa

i$.$ Save the filtered records as Filter Client List Ottawa$\_$ Your Name

ii$.$ Remove the filter

b$.$ Billings by date Aug. $20-24$

i$.$ Save the filtered records as Filter Billings August $20$ to $24\_$ Your Name

ii$.$ Remove the filter

c$.$ All billings by category $$ Divorce

i$.$ Save the filtered records as Filter Billings Divorce$\_$ Your Name

ii$.$ Remove the filter

$2)$ Create a query in Design View

a$.$ Add clients, and Staff tables to query

b$.$ Insert first name, last name, Lawyer ID from Client Table in first three fields

c$.$ Insert Lawyer Last name from the Staff Table to the last field

d$.$ Run query

e$.$ Save as a PDF Customer Lawyer List Query$\_$Your Name

$3)$ Create a query to determine all billings by category Week of August $13-17$

a$.$ Save as Query Billings August $13$ to $17\_\_$Your Name

$4)$ Filter all billings by Daniel Stuart

a$.$ Save as Filter Billings Daniel Stuart$\_$Your Name

$5)$ Create a query to determine all billings for Adoptions in August

a$.$ Save as Query Billings Adoptions August$\_$Your Name

$6)$ Compact your database

$7)$ Upload the following in a zipped folder:

a$.$ Database

b$.$ Filter Client List Ottawa$\_$ Your Name

c$.$ Filter Billings August $20$ to $24\_$ Your Name

d$.$ Filter Billings Divorce$\_$ Your Name

e$.$ Customer Lawyer List Query$\_$Your Name

f$.$ Filter Billings Daniel Stuart$\_\_$Your Name

g$.$ Query Billings Adoptions August$\_\_$Your Name

h$.$ Query Billings August $13$ to $17\_$Your Name