For this assignment, continue using your Momentum Legal Database $($version as of the end of the assignment for Module $7).$

$1.$ Export a table and query to Excel

a$.$ Use the Client table

i$.$ Export to Excel

ii$.$ Save as Export Excel$\_$ Client Table $\_$Your Name

b$.$ Use the Query created in Assignment #$2$Estate Planning for All Clients$$

i$.$ Export to Excel

ii$.$ Save as Excel Export$\_$Estate Planning for All Clients$\_$Your Name

$2.$ Export a report to Word

a$.$ Create a Word Document named Momentum Billings

b$.$ Use the Report created in Assignment $4,$Billing Report Modified$$

c$.$ Save as Word Export$\_$Momentum Billings$\_$Your Name

$3.$ Perform a query and merge with a Word document $$ See pages AC $8$ Pages $12$ to $13$ in textbook

a$.$ Create a query from the Clients table showing only clients living in Ottawa

b$.$ Save as Clients Ottawa

c$.$ Merge this Query with Word using the Word Merge button

d$.$ Create a Mail merge and insert the $$Address Block$$

e$.$ Follow the steps in the textbook to create a form letter that will go out to all clients living in Ottawa. Include date, correct word spacing and salutation $($Hint: use merge fields for the salutation e$.$g$.$ Dear

f$.$ Type in the following text in the body of the letter and then complete the merge and save the new document as Mail Merge$\_$Your Name.

$4.$ Upload the following in a zipped folder:

a$.$ Excel Export$\_$Estate Planning for All Clients$\_$Your Name

b$.$ Word Export$\_$Momentum Billings$\_$Your Name

c$.$ Mail Merge$\_$Your Name

d$.$ Export Excel$\_$ Client Table $\_$Your Name

e$.$ Revised Database