Monthly Archives: June 2023

Exp19_Access_App_CapAssessment – Student Loans 1.0

Exp19 Access App CapAssessment Student Loans 1.0 

EX19_AC_VOL1_GRADER_CAP_AS

Access  Application Capstone Assessment – Student Loan

Project Description:

Quill Financial Services has recently started working with student loans. You will build the company’s database. The initial set of financed student loans are stored in an Excel spreadsheet. You have already compiled the list of colleges and universities into an Access table. You will use your expertise to import the information from Excel, modify the table, create relationships, create queries, create forms, and create reports.

1

To start, you have been provided   with a database the Information Technology department created. The database   has one table. You will be importing an Excel spreadsheet into a table and   creating a primary key. 

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

2

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.

3

Now that you have imported the   data from the spreadsheet, you will modify the field properties in the   Clients table and demonstrate sorting.

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.

4

Now that the table is imported   and modified, you will create a relationship between the Colleges and Clients   tables.
 

  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.

5

Polly Esther, a financial   adviser, would like your assistance in helping her find certain information.   You will create a query for her and demonstrate how she can change information.
  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.

6

Now that you have created the query, you will create a second query   for Polly that will calculate the loan payments for which each student will   be responsible (assuming monthly payments).
 

  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. Format the field as   Currency. 

Run the query. Ensure the payment displays as a positive number. Add   a total row to Datasheet view. Average the MonthlyPayment field and count the   values in the LastName column. Save and close the query.

7

Stann Dupp, the director of   finance, needs to summarize information about all of the student loans Quill   Financial Services offers based on each college. You will create a totals   query for him to summarize the number of loans, average loan amount by   college.

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.

8

Jay Walker, one of the company’s administrative assistants, will   handle data entry. He has asked you to simplify the way he inputs information   into the Clients table. You will create a form based on the Clients table.

Create a Split Form using the Clients table as the source. Change the   height of all of the fields and labels to .25 collectively. 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 2022. Save the   form as Client Information and close it.

9

Stann is hoping you can create a   more print-friendly version of the query you created earlier for him to   distribute to the executives. You will create a report based on the Loan   Payments query.

   Create a report using the Report Wizard. From the Loan Payments query, add   the LastName, FirstName, Email, ExpectedGraduation, CollegeName, and   MonthlyPayment fields. Do not add any grouping or sorting. Ensure the report   is in Landscape orientation. Save the report as Loans by Client and view the report in Layout   view. Adjust the width and position of the fields and labels so that all of   the values are visible. Save the report.

10

Now that you have included the   fields Stann has asked for, you will work to format the report to make the   information more obvious.

   Apply the Integral theme. Group the report by the ExpectedGraduation field.   Sort the records within each group by LastName then by FirstName, both in   ascending order. Switch to Print Preview mode and verify that the report is   only one page wide (Note: it may be a number of pages long).

11

Save the database. Close the   database, and then exit Access. Submit the database as directed.

Write an essay discussing sqlmap, an automated tool for sql injection and database takeover in 500 words or more. Why do we need an automated tool for sql injection? 

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 an interesting meaningful title.

Include at least one quote from each of 3 different articles. Use the Research Databases available from the Danforth Library, not Google.    P lace 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 one  full sentence (no more, no less) and should be incorporated in your discussion (they do not replace your discussion) to illustrate or emphasize your ideas. Each quote must be cited in-line and at the end. 

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. 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.

Provide a reflection of at least 500 words of how the knowledge, skills, or theories of Application security have been applied, or could be applied, in a practical manner to your current work environment 

APA format with references needed.

 Exp19_Word_Ch02_ML1_Festival

Project Description:

In the following project, you will use Word to prepare a document promoting an upcoming festival. You will format the document, including bullets, styles, and line and paragraph spacing. In addition, you will add interest by including objects, such as pictures and WordArt.

Start   Word. Download and open the file named Exp19_Word_Ch02_ML1_Festival.docx.   Grader has   automatically added your last name to the beginning of the filename. 

Change the document theme to   Organic. Format the first paragraph in the document, Mount Vernon Hot Air Balloon Festival, as WordArt using the Fill:   Black, Text color 1; Outline: White, Background color 1; Hard Shadow: Orange,   Accent color 5 (third row, second column) style. Change the font size of the   WordArt object to 24.

Change the wrapping style of the   WordArt object to Top and Bottom. Format the WordArt object with Shape Style   Subtle Effect – Teal, Accent 2. If necessary, visually center the WordArt object on the   first paragraph of the document.

Format the second paragraph in   the document, See the Canyon From The   Top!, as center and bold with a   font color of Teal, Accent 2.

Select the remaining text on   page 1, beginning with May 28-29, 2022 and   ending with on the festival grounds.   Format the selected text into two columns with a line in between and equal   column width. Change the font of the columned text on page 1 to Century   Schoolbook. Insert a page break (not a section break) on page 2 after the   sentence ending with inflate balloons   on the festival grounds. 

No material for public   distribution should contain errors. You check for spelling and grammar   mistakes because it speaks to professionalism and influences how people see   the festival and those who run it.
  Check spelling and grammar—the word Ballumination   is not misspelled (for the purposes of this document). Correct any   spelling or grammar errors.

Right align the third paragraph on page 1—May 28-29, 2022. Format all columned text with a line spacing of   1.5 and paragraph spacing after of 6 pt. Insert a column break to the left of   the paragraph beginning with And don’t   forget the dogs!

With the insertion point   immediately to the left of the paragraph beginning As for the kids, search Online Pictures using the keywords hot air   balloons and   then insert an appropriate image from the results. Note: alternatively, you   can search for an image in a web browser, and then download and insert a   relevant image from the results.
  Select and delete any additional text boxes that may display when the image   is inserted. Change the height of the picture to 1”. Change the wrapping   style to Square and apply a picture style of Reflected Bevel, White. Position   the picture so that it is on the left side of the paragraph beginning with As for the kids, but still in the   right column.

Recolor the picture with Teal,   Accent color 2 Light. Apply the Paint Brush Artistic Effect. 

On page 3, format the heading When is the best time to see balloons?   as bold with a font color of Teal, Accent 2. Create a new style named Questions based on the formatting applied   to the same heading. Apply the Questions style to the other questions   (headings) on page 3.

On page 4, apply solid round   bullets to the nine paragraphs on the page beginning with Although there is no perfect and   ending with for a show to begin.   Decrease the indent so the bullets begin at the left margin. Change the color   of the bullet symbols to Teal, Accent 2. 

Insert a page break (not a   section break) before the heading How   can I plan for the best experience on page 3.

Select the schedule of items   under the heading Saturday (5/28/2022),   beginning with 6:00 AM and ending   with Balloon Glow. Set a left tab   stop at 1” and another left tab with a dot leader at 3”. Click at the   beginning of each line in the schedule of items and press TAB to move the   items to the left tab stop position. Move the activities to the 3” tab stop   position.
 

  Perform the same task with the schedule of items under Sunday (5/29/2022).

Save and close Exp19_Word_Ch02_ML1_Festival.docx.   Exit Word. Submit the file as directed.

 https://www.theatlantic.com/technology/archive/2021/10/fix-facebook-making-it-more-like-google/620456/?utm_source=pocket-newtab 

Discuss any point(s) that you found interesting or controversial.

What is your opinion of the author’s suggestion to limit / downscale communications of people utilizing these platforms?  

• Refer to the first three chapters in your Project Management Best Practices: Achieving Global Excellence textbook:
  • Chapter 1, “Understanding Best Practices.”
  • Chapter 2, “From Best Practice to Migraine Headache.”
  • Chapter 3, “Journey to Excellence.”
• Review this playlist of videos from LinkedIn Learning: Basecamp: Project Management Best Practices [total time 57:53].

For the purpose of this discussion, assume you are a newly minted Chief Information Officer (CIO) at an organization. The company you have joined does not have a history of adhering to project management best practices.

Please respond substantively to the following (3/4–1-page):

• Recommend to your Chief Executive Officer (CEO) a strategy and process to develop project management standards for the organization even though it has been operating without these types of standards in the past.
• Explain the main reasons that the strategy and process you are recommending will be effective.

    Write short answers, uploaded as a WORD DOCUMENT and attach references.  

• 7.1 What is the basic building block of an 802.11 WLAN?
• 7.2 Define an extended service set.
• 7.3 List and briefly define IEEE 802.11 services.
• 7.4 Is a distribution system a wireless network?
• 7.5 How is the concept of an association related to that of mobility?
• 7.6 What security areas are addressed by IEEE 802.11i?
• 7.7 Briefly describe the five IEEE 802.11i phases of operation.
• 7.8 What is the difference between TKIP and CCMP?

i need help in test

 Identify a topic in your specialization. (For IT students,  Information Technology is not a topic, however, Millennial’s perceptions  of smart phone technology could be a topic.).  

1. What is the cited problem? The problem you want to address has to  come from the literature, and be cited, who are saying there are  problems.
2. What is the population you would like to address?
3. What methodology are you planning on using? (If you are unsure, do  you plan on a quantitative or qualitative study? .
4. Locate at least one article related to your topic. What was the  research question in the study? Who were the participants in the study?  What findings were reported?

Method createInvoice generates a string that is printed in a JOptionPane dialog box. If the customer is type SILVER, the base cost is $25. If the customer is type GOLD, the base cost is $30. If the customer is type PLATINUM, the base cost is $35. createInvoice calls calculateCharge to add the video and test cost to the base cost. 

calculateCharge charges $1 for each video if customer type is SILVER and $.50 for each test. If the customer is type GOLD, each video is $.50 and each test is $.25. There is no extra charge if the customer is type PLATINUM. 

ArrayList lessonList keeps a list of all vides watched and tests taken by the customer. 

Write test case, CustomerTest, that creates two customers with the data given. The customers are kept in ArrayList, customerList. Then, using an enhanced for loop, polymorphically walk through the customerList and create the invoice for each customer. Print all customer’s charges in a dialog box as shown.