Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For this assignment, continue using your Momentum Legal Database ( version as of the end of the assignment for Module 8 . Here are some
For this assignment, continue using your Momentum Legal Database version as of the end of the assignment for Module Here are some tasks and skills that you might use in your job.
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.
i Save the filtered records as Filter Billings August to 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
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 QueryYour Name
Create a query to determine all billings by category Week of August
a Save as Query Billings August to Your Name
Filter all billings by Daniel Stuart
a Save as Filter Billings Daniel StuartYour Name
Create a query to determine all billings for Adoptions in August
a Save as Query Billings Adoptions AugustYour Name
Compact your database
Upload the following in a zipped folder:
a Database
b Filter Client List Ottawa Your Name
c Filter Billings August to Your Name
d Filter Billings Divorce Your Name
e Customer Lawyer List QueryYour Name
f Filter Billings Daniel StuartYour Name
g Query Billings Adoptions AugustYour Name
h Query Billings August to Your Name
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started