- P 2994 01 Mod Assign Intro Access 20module 202 20assignment 20with 20revisions Pdf Module 2 Assignment With Revisions Pd 1 (99.96 KiB) Viewed 19 times
assignment.
p/2994/01/mod assign/intro/Access%20Module%202%20Assignment%20with%20revisions.pdf Module 2 Assignment with revisions.pdf 1 / 1 100% + Value Your Mark 1 2 4 Task 1 Download the Support_AC_Financial Services Mod 2 Start File from Moodle. Rename this file as Your Name ID Number Module 2 Assignment. Once it is renamed, open the database and enable the content. Note: the file name should be similar to Sandy Olsen 123456 Module 2 Assignment (but with your name and ID number) 2 Import the Accounting table from the Support_AC Financial Services - Extra Tables database 3 Create a query for the Accounting table and add the CLM, Client Name, Amount Paid, and Au#fields to the design grid. Sort the records in descending order by Amount Paid. Add a criterion for the Auw field that allows the user to enter a different advisor each time the query is run. Run the query and enter 110 as the advisor number to test the query. Save the query as Apply 2 Step 2 Query. 4 Create a query for the Accounting table and add the CLA Client Name, and Current Due fields to the design grid. Add a criterion to find all clients whose current due amount is less than $500. Run the query, enlarge any fields so all text is shown and then save it as Apply 2 Step 3 Query 5 Create a query that joins the Advisor and Client tables. Add the Advisor Number, Last Name, and First Name fields from the Advisor table and the Client Number and Client Name fields from the Client table to the design grid. Sort the records in ascending order by Advisor Number and Client Number. Run the query and save it as Advisor Client Query 6 Create the report shown in Figure 2. The report uses the Advisor-Client Query. There are no grouping levels and it is already sorted. Use the Tabular layout and Portrait orientation Name the report as LastName- Client Report where LastName is your last name, 7 Submit your file into Moodle 3 4 3 Ictivate Windows cess Module 2 pdf Show Type here to search O RI 9 A 12°C AOC - ENG 13:43 17-05-2022 X C D + FI Para OD 2 $ 4 % 5 3 8 7 6 8 9 Backpaco Lock W E R т T Y U 1 O P 7 22 t 3 S D F G G H J к L. SE Enlar 4 i 1 X с V B N. M ? Shit 3 4 Poup Alt Ctrl Home Poon End