Answered step by step
Verified Expert Solution
Link Copied!

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 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Systems In Organizations People, Technology, And Processes

Authors: Patricia Wallace

1st Edition

0136115624, 9780136115625

More Books

Students also viewed these General Management questions