Chapter 12 – From the chapter reading, we learned that e-mail is a major area of focus for information governance (IG) efforts, and has become the most common business software application and the backbone of business communications today. In addition, the authors provided details to support their position by providing 2013 survey results from 2,400 corporate e-mail users from a global perspective. The results indicated that two-thirds of the respondents stated that e-mail was their favorite form of business communication which surpassed not only social media but also telephone and in-person contact. Q1: With this detail in mind, briefly state why the e-Mail has become a critical component for IG implementation?ALL original posts and comments must beYou must do the following:1) Create a new thread and share your perspectives with examples and references to course material with APA guidelines2) Please make your initial post with 500 words and two response posts substantive with at least 150 words . A substantive post will do at least TWO of the following:Ask an interesting, thoughtful question pertaining to the topicAnswer a question (in detail) posted by another student or the instructorProvide extensive additional information on the topicExplain, define, or analyze the topic in detailShare an applicable personal experienceProvide an outside source (for example, an article from the UC Library) that applies to the topic, along with additional information about the topic or the source (please cite properly in APA)Make an argument concerning the topic.

Assume that you are nearing graduation and have applied for a job with a local bank. As part of the bank's evaluation process, you have been asked to take an examination that covers several financial analysis techniques. The first section of the test addresses time value of money analysis. See how you would do by answering the following questions. Draw time lines for (a) a $2000 lump sum cash flow at the end of year 4, (b) an ordinary annuity of $1000 per year for 5 years, and (c) an uneven cash flow stream of -$450, $1000, $650, $850 and $500 at the end of years 0 through 4. What is the future value of an initial $1000 after 5 years if it is invested in an account paying 5% annual interest? What is the present value of $1000 to be received in 4 years if the appropriate interest rate is 5%? We sometimes need to find out how long it will take a sum of money (or anything else) to grow to some specified amount. For example, if a company's sales for 2020 is $1000 and expected to grow at a rate of 10% per year, how long will it take sales to double? If you invested $10,000 in an investment account and you expect it to double in 4 years, what interest rate must it earn? What is the future value of a 5-year ordinary annuity of $1000 if the appropriate interest rate is 5%? What is the present value of the annuity? What is the future value of $1000 after 4 years under 10% annual compounding? Semiannual compounding? Quarterly compounding? Monthly compounding? Daily compounding What is the effective annual rate (EAR or EFF%)? What is the EFF% for a nominal rate of 5%, compounded semiannually? Compounded quarterly? Compounded monthly? Compounded daily? Construct an amortization schedule for a $1,000, 12% annual rate loan with 4 equal installments. What is the annual interest expense for the borrower, and the annual interest income for the lender, during Year 2? Suppose on January 1 you deposit $1000 in an account that pays a nominal, or quoted, interest rate of 12%, with interest added (compounded) daily. How much will you have in your account on October 1, or 9 months later? You want to buy a car, and a local bank will lend you $10,000. The loan would be fully amortized over 6 years (72 months), and the nominal interest rate would be 10%, with interest paid monthly. What is the monthly loan payment? While Mary Corens was a student at the University of Tennessee, she borrowed $20,000 in student loans at an annual interest rate of 5%. If Mary repays $200 per year, then how long (to the nearest year) will it take her to repay the loan? Question 2 1. Jackson Corporation’s bonds have 10 years remaining to maturity. Interest is paid annually, the bonds have a $1,000 par value, and the coupon interest rate is 9%. The bonds have a yield to maturity of 10%. What is the current market price of these bonds? 2. Renfro Rentals has issued bonds that have a 10% coupon rate, payable semiannually. The bonds mature in 10 years, have a face value of $1,000, and a yield to maturity of 9%. What is the price of the bonds? 3. Wilson Wonders’s bonds have 10 years remaining to maturity. Interest is paid annually, the bonds have a $1,000 par value, and the coupon interest rate is 10%. The bonds sell at a price of $900. What is their yield to maturity? 4. Heath Foods’s bonds have 10 years remaining to maturity. The bonds have a face value of $1,000 and a yield to maturity of 9%. They pay interest annually and have a 10% coupon rate. What is their current yield? 5. Suppose Hillard Manufacturing sold an issue of bonds with a 12-year maturity, a $1,000 par value, a 10% coupon rate, and semiannual interest payments. Two years after the bonds were issued, the going rate of interest on bonds such as these fell to 5%. At what price would the bonds sell? Suppose that 2 years after the initial offering, the going interest rate had risen to 11%. At what price would the bonds sell? Suppose that 2 years after the issue date (as in part a) interest rates fell to 5%. Suppose further that the interest rate remained at 5% for the next 10 years. What would happen to the price of the bonds over time?

This lab assumes you are using MS Access 13 or above. You may use a higher version; however, be aware that there may be slight changes in the different versions. If your submission does not work in MS Access 13 or above, it is considered non-functioning and you will receive a zero.Grading RubricTOTAL: 36 pointsPart A: 39 points(5 pts) Required changes made to the items table(3 pts) Update Type Query meets specifications(4 pts) Item Split Form meets specifications(3 pts) Update Query meets specifications(3 pts) Reorder Filter Query meets specifications(5 pts) Delete ‘M’ Query meets specifications(5 pts) Table Properties has a description for the Items table that includes first and last name(6 pts) Item Status Report meets specificationsPart B: 1 pointFollows requested project submission formatGuidelines and PoliciesGetting HelpIf you have a question, please post on Piazza, and we will answer as quickly as possible. We will try to answer questions and provide help within 24 hours of your request. If you do not receive a response in 24 hours, please send the request again.Although we will answer questions, provide clarification, and give general help where possible up until the deadline, we will not help you with your submission within 24 hours of the deadline. We will not provide any help after the deadline.GuidelinesThis is an individual lab assignment. You must do the vast majority of the work on your own. It is permissible to consult with classmates to ask general questions about the assignment, to help discover and fix specific bugs, and to talk about high level approaches in general terms. It is not permissible to give or receive answers or solution details from fellow students.You may research online for additional resources; however, you may not use material that was written specifically to solve the problem you have been given, and you may not have anyone else help you write the material or solve the problem. You may use resources found online, providing that they are appropriately and clearly cited, within your submission.By submitting this assignment, you agree that you have followed the above guidelines regarding collaboration and research.In this lab, you will learn to:Use and Design MS Access QueriesModifying a Database Note: This is the third in a series of Database (Access) labs that build on each other. We will use a single database file and keep adding to that file as the labs progress. Please submit the version of the file as it exists after each lab is complete. Problem: The manager of the Science Museum gift shop needs to change the database structure, add validation rules, and update records. Also, a volunteer at the gift shop was asked to add some items to the database. By mistake, the volunteer created a new database in which to store the items. These items need to be added to the Museum Gift Shop databaseOpen the “Lab7-lastname.accdb” database and File > Save As “Lab8-lastname.accdb”Note, if you get a message that says, “Security Warning – Some active content has been disabled”, click on the “Enable Content” button.Open the Items table in Design viewAdd a new short text field, “Item Type”, to the Items table. Note - When complete:The field MUST appear AFTER the Description field. This field will contain data on the type of item for sale. The valid item types are ACT (activity, game), BKS (book), and NOV (novelty, gift).In the properties General tab, make the field size 3Make the default value property “ACT”Click on the “...” button at the right of the “Validation Rules” property to bring up the Expression Builder dialog.In the Expression Builder dialog, create an expression that checks to make sure that the value is one of the three values specified above. Then hit OK.In the “Validation Text” field, enter a message that the user will see if the validation rule fails.Change the “Required” property to “Yes”.Go to the “Lookup” tab in the properties for this field, and change “Display Control” to “Combo Box”.Make the Row Source Type a “Value List”.Click on the “...” button at the right of the Row Source property to bring up the “Edit List Items” dialog.Fill in the “Edit List Items” dialog with the values above, and make “ACT” the default value, then click on “OK”Add a validation rule to the “On Hand” field to check to make sure that the On Hand value is between 0 and 50, inclusive. Add validation text as well. Note: you can add a validation rule either by using the Field Properties for the On Hand field or add a validation rule in the Table Properties property sheet.Save the items table. Note... A pop-up will appear that says “Data integrity rules have changed...” respond “Yes”. Another pop-up will appear that informs you that “Existing data violates the setting for the “Required” property...” Again, respond “Yes”. Another pop-up may appear which also gets a “Yes” response.Create a new query for the Items table. Make this an Update query to update the Item Type to “ACT”. Save this query as “Update Type Query” and run the query. You will get a pop-up that asks for confirmation... say “Yes”.Open the Items table to see these updates.Make a new form using the “More Forms” icon to select a “Split Form”, and save it as “Item Split Form”.View the Item Split Form in the Forms View, and use it to:Change the Item Type for items 6234, 6345, and 7123 to BKS.Change the item type for items 3663 , 4583 , 6185, 8196, and 8344 to NOVSave the changes, then open the Items table and make sure your updates are complete.Save and close all changes to your database, and exit Access.Download the Lab 8 Gift Shop New Items.accdb file and open this database.Create and run a query to append the data from the Additional Items table to the Items table in the Lab 8 Museum Gift Shop database (your existing database). Save the query as “Update Query” and close the Lab 8 Gift Shop New Items database.Re-open the Lab 8 Museum Gift shop database and Open the Items table. You should now see the additional items.Create a new Query by using the “Advanced” filter icon and “Advanced Filter/Sort” for the Items table. Filter the table to find all items with fewer than 10 items on hand and sort the filter by Item Type and Description. Apply the filter using the “Toggle Filter” icon, then save the query as “Reorder Filter”. Clear the filter from the Items table using the Toggle Filter icon again.Create a query to delete all records in the Items table where the description starts with the letter M. Run the query and save it as “Delete ‘M’ Query”.Right-click the Items table in the Object List pane. Click Table Properties, and add a description for the Items table that includes your first and last name. Save the changes to the table.On the Database Tools tab, click on the “Relationships” icon, to open up the “Relationship Tools” ribbon. In the Design Tab of the Relationship Tools Ribbon. If asked to open tables, open both the Vendor and the Items table. If there is already a line between Vendor/Vendor Code and Items/Vendor code, click on that line, and then click on the “Edit Relationships” icon. If there is no line between Vendors and Items, then click on the “Vendor Code” field in the Vendor table, and drag it onto the Vendor Code field in the Items table. When you do this, the Edit Relationships dialog should pop-up.The top of the dialog should already be filled in with Vendor table and Vendor Code selected on the left and Items table and Vendor Code selected on the right.Click on the “Enforce Referential Integrity” check box.Click on the “Cascade Update Related Fields” check boxLeave the “Cascade Delete Related Records” box unchecked.Click on the “Create” button.You should now see the relationship (a line) between Vendor/Vendor code (1) and Items/Vendor Code (∞ indicating that many lines in this table can have a single vendor code.) Close the “Relationship Tools” tab by clicking on the X box inside the ribbon.Specify referential integrity between the Vendors table (the “one” table) and the Items table (the “many” table). Cascade the update but not the delete. Add the Item Type field to the Item Status Report. The new field should follow the Description field. Save the result and switch to the Report View. The result should look like:Save the workbook as Lab8-lastname.accdbSubmissionRequired code naming and organization:Lab8-lastname.accdb Every lab will have required submission guidelines. Please read submission requirements carefully. Any deviations from specifications on future labs or projects will result in significant point deductions or incomplete grades.Submit this file on MyCourses. To do so, go to: CS-105 > Assignment Submission > Lab 8Attach your file and submitIgnore the preview. It will not display correctly.You may submit as many times as you like until the deadline. We will only review your final submission.