•Test your reports by manually finding and sorting the Marks records for a particular course. •Please put your name, student number and handin code in the footer of all your reports/layouts, so the tutors can easily identify your work. E.Write a script called “By Name” that sorts the data appropriately, puts FileMaker in Preview mode and displays the current found set using the By Name [Detailed]layout. •Write a similar script called “By IDN” that uses the By IDN [Detailed] layout. •Test these macros by running them manually from the Scriptmenu. F.Write a script called DoItthat: •“performs” your Do Findscript to find the Marksrecords for the course selected on the Chooselayout; •uses FileMaker’s If – Else – End Ifscript steps to “perform” either your By Nameor By IDN scripts, depending on the current value of the WhichOrderfield. •Attach the DoItscript to the DoItbutton on the Chooselayout. Clicking on the DoItbutton should now produce either Figure 1 or Figure 2, depending on the order last selected via the WhichOrderpopup menu. G.Duplicate the By Name [Detailed] and By IDN [Detailed] layouts to create layouts named “By Name” and “By IDN”. Modify both of these layouts by deleting the body part and all of the fields in that part, ultimately leaving only a sub-summary part, header and footer. Make any other changes needed to produce the layouts shown in Figures 3 and 4.H.Alter your By Nameand By IDNscripts so they display data using the By Nameand By IDN layouts instead of the By Name [Detailed] and By IDN [Detailed] layouts. At this point you should have duplicated the functionality of the Chooselayout in the password-protected demonstration solution I have placed on Learn.
CS200 Assignment 10 Page 5 of 92. [15%] This is an application of Regular Expressions. This question must be done individually. Design find and replacement regular expressions that insert commas into the numbers shown so as to group digits to the left of the decimal point in blocks of 3 (currency format, eg 71,243,425). Assume that all numbers will have 8 digits only. Put your answer in yHC_a10q2.doc. Use SomeNumbers.txton in the Assignment Files on Learn to test your find and replace patterns. You should use TextWrangler(freeware for Macintoshes). Make sure that “Use Grep” is selected. Put your find and replace patterns in a nicely formatted MS Word file namedyHC_a10q2.doc. 71243425 75424677 54781475 87886172 39123426 30193577 80139671 10733189 29675544 32544418 37756090 11584051 15989387 80791863 25912684 67493203 99766586 76660544 42229077 20790370
CS200 Assignment 10 Page 6 of 9Bonus Would your answer to question 2 be different if the numbers were intermixed with text as follows, and if so, how? Justify your answer. This text is not in a file and you are not required to type it out, however you may want to test your answer by entering a few lines into TextWrangler.