Complete the Independent Challenge 3 exercise on page Access 160 in Module 6: Improving Queries. Do not perform the Print in step g, and m. The Friedrichsen Access 2016 data files can be found in the Resources section of the class. You must download and use the LakeHomes-6.accdb file provided with this course – look in the Resource section, Access Module 6 in the Friedrichsen Access 2016 Data Files folder. Name the completed Access database Last Name_LakeHomes-6.accdb (i.e. Smith_ LakeHomes-6.accdb).(-40) – additional submission allowed to compete this work a. Open LakeHomes-6.accdb 2% (the deduction may be materially higher if correct file not used)b. Create query with fields (in order) - AgencyName (Agencies table), RFirst and RLast (Realtors table), SqFt and Asking (Listings table) 5%c. Sort in Descending order by SqFt field - removed for second query 0%d. Save Query as BySqFt 2%d. Enter Student last name in place of Schwartz 3%e. Modify Query - add calculated field PerSqFt [Asking]/[SqFt] 6%f. Remove former Sorts - sort PerSqFt in Descending order, save and close query 4%g. Use Property sheet to set PerSqFt to currency, no Print needed 3%h. Create CostSummary query - by copying BySqFt as base 2%i. Delete RFirst, RLast and SqFt fields 2%j. Change Big Cedar Realtors agency name to student last name Realtors 3%k. Add Total row, then sum the Asking field and use Average aggregate function for the PerSqFt calculated field 5%l. In Datasheet View - add the Total row and display the sum of the SumOfAsking field, widen all fields as needed, (see figure 6-22) 3%m. If requested - print the CostSummary query - not requested 0%n. Close and exit - change filename to include Student Last name 0%

Please create a security layer which keeps a backup copy of a file in case it is written incorrectly. This is a common technique for things like firmware images where a system may not be able to recover if the file is written incorrectly. For this assignment, a valid file must start with the character 'S' and end with the character 'E'. If any other characters (including lowercase 's', 'e', etc.) are the first or last characters, then the file is considered invalid.Applications use ABopenfile() to create or open a file. Files are created by setting create=True when calling ABopenfile(), the reference monitor will create a valid backup file called filename.a and an empty file we will write to called filename.b. When close() is called on the file, if both filename.a and filename.b are valid, the original file's data is replaced with the data of filename.b. If filename.b is not valid, no changes are made.Write test applications to ensure your reference monitor behaves properly in different cases and to test attacks against your monitor.The Reference Monitor Must:Not modify or disable any functionality of any RepyV2 API calls, such as:Creating new filesOpening an existing fileReading valid backup using readat()Writing to file using writeat(). This includes invalid writes, because 'S' and 'E' may later be written to the begining and end of the file respectively.Check if file contents starts with 'S' and ends with 'E', only when close() is called.Update the original file with the new data IF the new data is valid on close().Not produce any errorsNormal operations should not be blocked or produce any outputInvalid operations should not produce any output to the userThe Reference Monitor Should:Create two copies of the same file (filename.a and filename.b)One is a valid backup to read from, and the other is written toWhen an app calls ABopenfile(), the method opens the A/B files, which you should name filename.a and filename.b.When the app calls readat(), all reads must be performed on the valid backup.When the app calls writeat(), all writes must be performed on the written to file.Three design paradigms are at work in this assignment: accuracy, efficiency, and security.Accuracy: The security layer should only stop certain actions from being blocked. All other actions should be allowed. For example, if an app tries to read data from the backup file, this must succeed as per normal and must not be blocked. All situations that are not described above must match that of the underlying API.Efficiency: The security layer should use a minimum number of resources, so performance is not compromised. For example, keeping a complete copy of every file on disk in memory would be forbidden.Security: The attacker should not be able to circumvent the security layer. For example, if the attacker can cause an invalid file to be saved, read the "write to" file, or can write to the backup file we read from, then the security is compromised.Getting Python and RepyV2Please refer to the Build Instructions for details.Once you have built RepyV2 into a directory of your choice, change into that directory. Use the command below in order to run your RepyV2 applications:python3 repy.py encasementlib.r2py [security_layer].r2py [application].r2py(Replace '[security_layer].r2py' and '[application].r2py' by the names of the security layers and application that you want to run.)In order to test whether or not these steps worked, please copy and paste the code found below for the sample security layer and sample attack.

1.  Pick one of the items below for your Original Post in this week's discussion forum: ·  When creating a security policy framework, it’s important to align business objectives with the correct framework. Discuss what can happen if the framework you choose as a foundation does not fit your organization’s business objectives. Why is it important to understand business objectives when creating and establishing IT policies? ·  Identify and explain three business considerations relating to security policy frameworks. Why is it important to take into account the cost and impact of implementing the policy framework? ·  Explain the differences between policies, standards, procedures, and guidelines? Provide at least one example of each. ·  Describe the roles and responsibilities of people involved in security policy framework creation. Why is it important to have the different roles defined and have people assigned to those roles? What can happen when you don't? ·  Describe how and where external and internal factors contribute to an effective policy framework. How do these factors affect organizations? ·  Discuss the importance of separation of duties for personnel. Include examples of roles you would separate and why. Note: Need 2-3 pages’ answer and APA Format with citations Please no plagiarism. 2.  See the attached assignment sheet and complete both exercises.  In it, you'll be creating a policy framework for a sample organization. You will also be summarizing industry policy frameworks. Note: Need 12-14 pages’ answer and APA Format with citations Please no plagiarism.