Database security – Regulatory Frameworks 1 – HIPAA

OverviewThis week we will be examining HIPAA (Health Insurance Portability and Accountability Act of 1996) is United States legislation that provides data privacy and security provisions for safeguarding medical information.
You will also begin preparations for your final project by picking a topic. Your final project is a paper and a 20 minute presentation to a group of aspiring DBA’s on a security topic. Please select a topic from the material covered in this course or another topic that interests you (maybe one that you need to know for work). 

Required Readingshttp://blog.securitymetrics.com/2014/05/hipaa-faq.html
https://www.hitechanswers.net/hipaa-hospitals-five-reasons-medical-data-storage-often-not-compliant/
https://www.careersinfosecurity.com/2-million-hipaa-penalty-after-patient-data-exposed-on-web-a-9465
https://www.medscape.org/viewarticle/810563_2
https://www.bankinfosecurity.com/ocr-considering-hipaa-privacy-rule-enforcement-changes-a-10750

Required Videoshttps://www.youtube.com/watch?v=E6mSlxux1Co
HIPAA Risk Analysis
HIPAA Security Risk Assessment Week 10 PaperWrite an essay of at least 500 words discussing the Safe Harbor provisions under HIPAA.  
Do not copy without providing proper attribution. This paper will be evaluated through SafeAssign. 
Write in essay format not in outline, bulleted, numbered or other list format.  
Use the five paragraph format. Each paragraph must have at least five sentences. Include 3 quotes with quotation marks and cited in-line and in a list of references. Include an interesting meaninful title.
Include at least one quote from each of 3 different articles, place the words you copied (do not alter or paraphrase the words) in quotation marks and cite in-line (as all work copied from another should be handled). The quotes should be full sentences (no more, less) and should be incorporated in your discussion (they do not replace your discussion) to illustrate or emphasize your ideas.
Cite your sources in a clickable reference list at the end. Do not copy without providing proper attribution (quotation marks and in-line citations). Write in essay format not in bulleted, numbered or other list format. 
It is important that you use your own words, that you cite your sources, that you comply with the instructions regarding length of your submission Do not use spinbot or other word replacement software. It usually results in nonsense and is not a good way to learn anything. I will not spend a lot of my time trying to decipher nonsense. Proof read your work or have it edited. Find something interesting and/or relevant to your work to write about.  Please do not submit attachments unless requested.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

programming

COP 3014: Fall 2018 Homework 4

Total Points: 200 Due: Friday, 11/16/2018

The objective for this assignment is to make sure You understand and can work with C++ arrays. You are comfortable with writing functions in C++. You are familiar with repetitive structures (loops) and selection statements (if/else or switch) in any combination and can use them in functions and to manipulate array data. You can approach a complex problem, break it down into various parts, and put together a solution.
From this assignment, please make sure you conform to Output requirements. You should now be familiar enough with cout statements and output formatting that you should be able to EXACTLY match the sample output (other than certain exceptions you will be informed about beforehand).
This assignment requires you to several files on Canvas. Please do so in a SINGLE submission. Canvas allows you to turn in multiple flies in one submission. Once you have uploaded your first file, click “attach another file” to upload your second file and so on.
Turn in your 3 files functions.cpp, arrays.cpp and matrix.cpp, (and the extra credit programevaluate.cpp, if you are attempting it) to Canvas.

2 Program 1 – Writing Functions – 75 points

Squilliam Fancyson has heard of the fancy calculator that Squidward (supposedly) made for the Krusty Krab’s Cash Register. Determined to prove that he is the best programmer in town, he has challenged Squidward to a series of programming challenges. If Squilliam wins, Squidward has to hand over his clarinet and never paint again. If Squidward wins, Squilliam will work Squidward’s shift at the Krusty Krab’s cash register for a week. Squidward is determined to win, except he is not really a programmer. He has left no stone (pioneer transport or otherwise) unturned. He has even tried asking Karen, who was unable to help. He realizes that instead of working off Mr. Krabs’ old computer (the one Patrick smashed while painting the house), he could just pay you to do the challenges for him. Your task today is to help Squidward retain his sanity and dignity (whatever is left of it).

The first challenge is to write a few mathematical functions. For this program, we define a new term called Special Difference. The Special Difference of a number is the difference between the number and the one you obtain by reversing its digits. For example, the Special Difference of 1234 is 3087 (| 1234 – 4321 |).

1

We also find the value of ex using the Taylor’s series expansion. The Taylor’s Series expansion of ex is defined as

e =
Please make sure your program conforms to the following requirements.

number. (20 points) Write a function called difference that accepts a number as a parameter, calculates the special difference of the number and returns it. (15 points) Write a function called factorial that returns the factorial of a number. You can use the code from the class examples. Write a function called sum that takes a number ’x’ and a number ’n’ as parameters and calculates ex accurate to the ’nth’ term. You cannot just raise e to x. You have to use the expansion to calculate the value. (20 points) You can use the pow function to calculate xn. In the main function, accept a series of numbers from the user. Stop if the number entered is negative. Use the difference method to find the sum of the special differences and print it. (10 points) Next, still in the main function, accept the values of ’x’ and ’n’ from the user and use the sumfunction to calculate the required value and print it. (5 points) Make sure you add comments to explain your logic. (5 points)

2.1 Sample Run Calculating the Special Differences:
Enter the numbers:
1234
57
982
603
-2
The Sum is 4095
Calculating e^x through Taylor’s Series Expansion:
Enter the value of x: 5
Enter the number of terms: 20
e^x is 148.413

3 Program 2 – Array Operations – 75 Points

Squilliam has been soundly beaten in the first challenge. He still refuses to give in. It is now a best of 3 challenge. The next item on the agenda is array operations. For this program, we’re going to perform a range of standard array operations to show Squilliam once and for all, that Squidward is familiar with arrays and how they work. You’re required to write functions to insert and delete

inf
x ????xn x0 x1 x2 x3

n!=0!+1!+2!+3!…
1. Write a function called reverse that takes a number as a parameter and returns the reversed

n=0

2

elements from an array, and sort the array. We’re also going to write a command line menu to do these tasks repeatedly. For this problem, you can assume that the array size will never drop below 1 and will never rise above 99.

Please make sure you conform to the following requirements: Create a global constant integer called CAPACITY and set it to 100 (5 points) Use the class examples and exercises to write functions to initialize the array by reading values from the user, and to print the array. These functions take the array and its current size as parameters. You can use the code in the examples. (5 points) Write a function called insert that takes the array, a number, a position and the current size of the array as parameters. Insert the number at the given position. (15 points) Write a function called remove that takes the array, a number and the current size of the array, and removes the first instance of the number from the array. (15 points) Write a function called sort that takes the array and its current size as parameters and sorts the array in ascending order. You need to use insertion sort, which is given below. (15 points) In the main function, have the user initialize the array. Then, write a command line menu with the following options:
• Print
• Insert
• Remove• Sort
• Exit
Call the appropriate functions when the user chooses a particular option. Print and error message and continue if the user enters a wrong option. (15 points) Please make sure your code is appropriately commented. (5 points)

Algorithm for insertion sort loop i from 1 to Length(A)
       x = A[i]

j=i-1
loop as long as j >= 0 and A[j] > x

A[j+1] = A[j]

j=j-1 end loop        A[j+1] = x
end loop

3.1 Sample Runs Enter the number of elements you want to enter (Max 100): 5
Enter 5 numbers
2.5 6 -7 10.7 0.8
1. Insert an element
2. Remove an element
3. Print the array

3 4. Sort the array
5. Exit
Enter your option: 1
Enter the number: 3.1
Enter the position: 2
Element Inserted.
1. Insert an element
2. Remove an element
3. Print the array
4. Sort the array
5. Exit
Enter your option: 3
The array is:
2.5 6 3.1 -7 10.7 0.8
1. Insert an element
2. Remove an element
3. Print the array
4. Sort the array
5. Exit
Enter your option: 4
1. Insert an element
2. Remove an element
3. Print the array
4. Sort the array
5. Exit
Enter your option: 3
The array is:
-7 0.8 2.5 3.1 6 10.7
1. Insert an element
2. Remove an element
3. Print the array
4. Sort the array
5. Exit
Enter your option: 2
Enter the element: 0.8
Element deleted.
1. Insert an element
2. Remove an element
3. Print the array
4. Sort the array
5. Exit
Enter your option: 3
The array is:
-7 2.5 3.1 6 10.7

4 1. Insert an element
2. Remove an element
3. Print the array
4. Sort the array
5. Exit
Enter your option: 5

Goodbye!

4 Program 3 – Matrix Norms – 50 points

The competition is heating up. The special judging panel, consisting of Karen, Old Man Jenkins and Sandy, do not want to release the results of the previous challenge until this one is complete as well. For this challenge, you have to compute the Max Norm of a matirx. The Max norm of a ma- trix is defined as the largest elements of a matrix. Write a C++ program to compute the Max norm.

Please make sure you conform to the following requirements: Declare global constant integers for ROWCAP and COLCAP. Set both to 100 (5 points) Use the class examples and exercises to write functions to initialize the matrix by reading values from the user, and to print the matrix. These functions take the matrix and its current number of rows and columns as parameters. You can use the code in the examples. (5 points) Write a function called findnorm that accepts the matrix, its current number of rows and columns and return its max norm. (20 points) In the main function, initialize the matrix, read in its values and compute and print its norm. (15 points) Please make sure your code is commented (5 points).

4.1 Sample Run

Enter the number of rows: 3 Enter the number of columns: 3 Enter the matrix:
-3 5 7
2 16 4
028 The max Norm is: 16

5 Extra Credit Problem – Simple Calculator – 50 points

In the distant and slightly dystopian future, the Grand Poobah has banned the use of hand held calculators. Some say he was hit on the head with one. Others believe it is due to his fear of accountants. Either way, hand calculators are a thing of the past. However, you find yourself in sudden need of a calculator that can perform simple calculations. No worries. You are a C++ programmer and you can write a console application to do this.

This program does not serve any practical purpose and is, in fact, a very inefficient way to de- sign a calculator. This exercise is just to give you some practice in writing functions.

5

Specifications This program makes use of functions. The main function should only contain one effective line (that is not the usual program stub), which is a call to the evaluate function. (5 points). Write 5 functions to perform the 5 basic arithmetic operations: +, -, *, / and %. Give them some sensible name (for example, the function that performs addition can be called add). Each of the functions will take 2 integer arguments and return an integer value. (25 points) Write a function called evaluate, that does not take any arguments and does not return a value. This function will read in an arbitrary number of values from the user: an integer followed by a character that denotes an operation. Once you have the number and the operation, call the appropriate function from the five that you just wrote to keep a running evaluated total. The user input ends when the character entered is a ‘=’. When the user is done with input, print the result. (15 points) You may assume that all inputs are valid. You need not test for wrong inputs. Here, you need to ignore the order of operations and calculate the values as they come. Please include comments wherever appropriate. (5 points)

5.1 Sample Run Enter the expression:
1
+
26
*
2
%
19
/
5
=
The result is 3

5.2 Sample Run 2 Enter the expression:
12
*
9

37
+
-8
=
The result is 63

6 Generic Guidelines

1. Include the header comment with your name and other information on the top of your files.

6 Please make sure you’re only using the concepts already discussed in class. That is, please try and restrict yourself to input/output statements, variables, selection statements, loops, functions and arrays. Using any other concept (like pointers) will result in loss of points. You cannot use arrays for Problem 1 and Problem 4. For those, you are restricted to functions, loops and selection statements. The first 2 programs are worth 75 points each. the third program is worth 50 points. Please make sure that you’re conforming to specifications (program name, print statements, expected inputs and outputs etc.). No global variables (variables outside of main() ), excpet for constants. All input and output must be done with streams, using the library iostream You may only use the iostream, iomanip and the cmath libraries (you do not need any others for these tasks) NO C style printing is permitted. (Aka, dont use printf). Use cout if you need to print to the screen. When you write source code, it should be readable and well-documented (comments). Make sure you either develop with or test with Jetbrains CLion (to be sure it reports no compile errors or warnings!) before you submit the program. Program submissions should be done through the Canvas class page, under the assignments tab (if its not there yet Ill create it soon.) Do not send program submissions through e-mail e-mail attachments will not be accepted as valid submissions. TheONLYfilesyouwillsubmitviaCanvasarefunctions.cpp, arrays.cppandmatrix.cpp, (and the extra credit program evaluate.cpp, if you are attempting it). Please make sure you’ve compiled and run your program before you turn it in. Compilation errors can be quite costly (4 points per error,until the 10th error, after which you will be assigned a grade of 0). General Advice – always keep an untouched copy of your finished homework files in your email. These files will have a time-stamp which will show when they were last worked on and will serve as a backup in case you ever have legitimate problems with submitting files through Canvas. Do this for ALL programs.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

Business Continuity Planning and Disaster Recovery Planning

1.  Discuss the importance of the after-action review and “lessons learned” documents.  How will these help to improve the BC plan? 

2.  What do you think would be the issues for a small “Mom & Pop” type business? Is BC planning within their financial ability to perform? What options does a small business have? 

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

What are four important tactical tasks for a negotiator in a distributive situation to consider?

  For each discussion, you are required to write an initial post (300 words) and one secondary post (200 words).  The discussion forums will be worth 40 points apiece—25 points for the initial post and 15 points for the secondary post.  For your initial post, you must have two academic peer-reviewed articles for references.  You must get them from the library.  There are directions at the top of our Moodle page showing how to utilize the library. 

  All discussions must be completed on-time and must include in-text citations and references in APA style formatting. If you do not use in-text citations or they are not in APA format you will lose 3 points.  If you do not have references or if they are not in APA format, you will lose 5 points. (You do not need citations and references for secondary posts).  You will lose 10% based on word count if your posts are too short.  For example, your initial post is 300 words, if you have 250 words you will lose 5 points.  50 words short times 10% (50 x .10 = 5).

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

help ds

Topic : Mobile User Data Security

1. Powerpoint slide deck (10 slides just the matter)

2. 800 word paper on “Mobile user Data Security”

3. Five source annotated bibliography

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

Consider a student club or organization in which you are a member

1. Consider a student club or organization in which you are a member. What are the data entities of this enterprise? List and define each entity. Then, develop an enterprise data model showing these entities and important relationships between them.

2.

You have been tasked to create a database for your college to track students, their courses (past, present, and future), grades and academic standing, and instructors. 

Describe the entities and their attributes that might be required for this application, the type of database processing required, and the application software needed. 

Consider all users of the application and how the issues of data integrity, security, and user interfaces would best be handled.

3. Part I – Number Conversions

Pick the amount from one of the checks in your checkbook.
1) Convert the decimal number into a binary number with three places to the right of the binary point.
2) Convert the binary number into a hexadecimal number.

3) Convert the binary number to a floating-point number using the IEEE -754 Floating-Point Standard 

Part II – Adding Binary Numbers 

Select two decimal numbers between -60 and +60. One should be positive and the other should be negative. 

Convert the numbers into 8-bit unsigned numbers with negative numbers in the 2’s complement form. (Remember that positive numbers have the leftmost bit =0 and negative numbers have the leftmost bit =1).
Add the two numbers together to generate an eight-bit binary result. Show your work.

Part III

If a computer is capable only of manipulating and storing integers, what difficulties present themselves? How are these difficulties overcome

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

IT 315 Final Project Part II Milestone

Overview: Throughout the course, you will develop the skills required of a software architect—a role that is in high demand in the software industry. This final
project resembles a typical development project of an actual software designer or software architect. You will have the opportunity to apply, practice, and
receive feedback on how software systems are designed using object-orientation and Unified Modeling Language (UML) modeling.
For this assessment, you will assume the role of a consultant tasked with designing a Student Information System (SIS) for a small college that offers both online
and face-to-face classes. The SIS should keep track of students’ information and their course registrations. You will be provided with information about the
system, its business context, and its requirements. With this information, you will need to design the software system by applying object-oriented techniques
and methods and UML modeling.
Specifically, this final project is divided into three different parts, which will each be submitted separately. Each part focuses on a different stage in the
development process, and will be completed in sequence throughout the course. Additionally, at each stage you will validate and verify your design, explain how
you arrived at it, and reflect upon your process and lessons learned. Through the milestones, you will have an opportunity to gather feedback first before you
submit final versions. The three final project submissions are Part I: Functional Model, submitted in Module Four; Part II: Structural Model, submitted in Module
Six, and Part III: Behavioral Model, submitted in Module Eight.
Prompt: You, as a software architect, did a good job on the functional model of the SIS. The small college is happy with your functional model and has approved
it. The college wants you to proceed to the next step of the SIS structural model.
Based on your SIS functional model, create an SIS structural model consisting of: A class responsibility collaboration (CRC) card for each class in your model
A class diagram From the SIS functional model, identify the classes of your structural model. You should have between six to nine classes. Using the provided Part II Solution
Submission Template document, document each class showing its responsibilities, collaborations, attributes, and relationships.
Formalize the information from the CRC cards into a class diagram. Your class diagram should use the class relationships of association, generalization,
aggregation, and composition to structure the classes and should indicate the multiplicities of these relationships. The class diagram must be generated by a
UML drawing tool. After creating your model, make sure to complete the other deliverables listed below.
Links to UML drawing tools: draw.io Visio Specifically, the following critical elements must be addressed: Creation: Analyze your SIS functional model and create a structural model UML class diagram. Classes in the class diagram should include all the classes
that are needed to realize the use cases. The class diagram should also include all the relationships among these classes. Provide a CRC card for each
class in your class diagram that describes the class purpose, class responsibilities, and class collaboration with other classes.
Testing: Verify and validate your structural model against your functional model of the SIS system.
Approach Explanation: Explain your approach to creating your structural model and the design decisions you made to create it.
Self-Reflection: Discuss your experience creating your structural model and the lessons you learned from it. Specifically, draw connections between your
experience and the object-oriented techniques and methods discussed in this course. Guidelines for Submission: Use the Final Project Part II Solution Submission Template document and follow the formatting directions therein when submitting
your work. Your structural model should be complete and professional.
Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information,
review these instructions. 

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

S discussion 2

Lesson 3 Discussion Forum 1: Primary post is due Wednesday by 11:59pm. Responses due by Sunday at 11:59pm

If you became the new manager at a restaurant with high employee turnover, what actions would you take to increase retention of employees?

Your discussion is to be submitted in 12-point Times New Roman font using APA format. You must have a minimum of two sources to support your answer. Lesson 3 Discussion Forum 2: Primary post is due Wednesday by 11:59pm. Responses due by Sunday at 11:59pm

What labor markets should be considered when recruiting to fill an opening for a housekeeping staff at a local hospital? What labor markets should be considered for staffing the chief surgeon for the local hospital?

Your discussion is to be submitted in 12-point Times New Roman font using APA format. You must have a minimum of two sources to support your answer.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

Assignment 1: Digital Computer Crime

Write a three to four (3-4) page paper in which you:Explain the four (4) major categories of computer crimes, and provide at least one (1) example for each.Explain the most common forms of digital crime.Determine the category of computer crimes or cyber terrorism that presents the greatest overall threat at the present time. Provide a rationale to support your response.Summarize the roles and responses that the U.S. government, court systems, and law enforcement agencies in combatting computer crime. Next, suggest one (1) additional way—i.e., one not discussed in the textbook—that the law enforcement agencies can better counteract computer crime.Use at least three (3) quality references for this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

Javascript

 Start Access. Open the downloaded Access file named exploring_acap_grader_a1_Loans.accdb. 

 Import the exploring_acap_grader_a1_Clients.xlsx Excel workbook into a table named Clients. While importing the data, make sure to select the option First Row Contains Column Headings, and select ClientID as the primary key field. 

 After you have completed the import, open the Clients table in Design view. Change the ClientID field size to 6 and remove the @ symbol from the ClientID format property. Change the ZIP field size to 5. Change the ExpectedGraduation field to have 0 Decimal Places. 

 Delete the Comments field. Add a new field named LastContact as the last field in the table. Change the data type to Date/Time, and change the format to Short Date. 

 Switch to Datasheet View, and apply Best Fit to all columns. Sort the table on the LoanAmount field in descending order, then save and close the table. 

 Open the Relationships window. Add the Clients and Colleges tables to the window, and create a one-to-many relationship between the CollegeID fields in the Clients and Colleges tables. Enforce referential integrity between the two tables and select the cascade updates and cascade delete options. Save the changes, and close the Relationships window. 

 Create a new query using Design view. From the Clients table, add the LastName, FirstName, Email, Phone, and ExpectedGraduation fields, in that order. From the Colleges table, add the CollegeName field. Sort the query by LastName and then FirstName, both in ascending order. Set the criteria in the ExpectedGraduation field to 2019. Run the query. Save the query as 2019 Graduates and close the query. 

 Create a copy of the 2019 Graduates query. Name the copy Loan Payments and open the query in Design view. Remove the criteria from the ExpectedGraduation field. Create calculated field named MonthlyPayment that determines the estimated monthly student loan payment. The loan will have a fixed rate of 5% interest, paid monthly, for 10 years. Using the Pmt function, replace the rate argument with 0.05/12, the num_periods argument with 10*12, and the present_value argument with the LoanAmount field. Use 0 for the future_value and type arguments. Ensure the payment displays as a positive number. Format the field as Currency. 

 Run the query. Add a total row to Datasheet view. Average the MonthlyPayment field, and count the values in the LastName column. Save and close the query. 

 Create a new query using Design View. From the Colleges table, add the CollegeName field. From the Clients table, add the ClientID and LoanAmount fields. Display the Total row, and group by CollegeName. Show the count of ClientID and the average LoanAmount. 

 Change the caption for the ClientID field to Num Loans, and the caption for LoanAmount to Avg Loan. Format the LoanAmount field as Standard. Run the query. Save the query as Loan Summary by College and close it. 

 Create a Split Form using the Clients table as the source. Change the format of the ClientID field so the font is 18 and the font color is Dark Red (last row, first column in the Standard Colors section). Change the fill color of the ClientID field to be Black (first row, second column in the Standard Colors section). Reorder the fields in the bottom half of the split form so the FirstName displays before the LastName field. Switch to Form view and click the row for Riya Gonzalez. Change her expected graduation date to 2021. Save the form as Client Informationand close it. 

 Create a report using the Report Wizard. From the Loan Payments query, add the LastName, FirstName, Email, ExpectedGraduation, CollegeName, and MonthlyPayment fields. Group by Colleges. Ensure the report has a Stepped layout and Landscape orientation. Save the report as Loans by College. 

 Apply Best Fit to all columns. Change the font size of ExpectedGraduation field values to 16. Apply Bold style to the LastName field values. Save and close the report. 

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.