Country : Canada

Assignment Task

Access Exercise 1: Small Business Loans
You are employed as a technical supervisor at a lending firm for small business loans. You will learn how to populate an Access table, work with a form that can be used to add, delete, and modify member loan records, apply a filter to a table, and locate loan officer information through a query.
Modify Data in a Table
You will open an original database file and save the database with a new name. You will then modify, add, and delete information using tables and forms.\Apply a Selection Filter and Sort a Query
You are interested in quickly filtering the data in the Loans, Officers, and Members query based on a specific loan officer. You will then sort the filtered results to view the loans by loan status.
11.Open the Loans, Officers, and Members Query in Datasheet view.
12.Use a Selection filter to show only the loans managed by the loan officer whose name is John Badman.
13Sort the query by LoanStatus in alphabetical order. Save and close the query.
Back Up a Database and Add an Application Part
You will first back up the database to reinforce the importance of backing up stored data. You will also add an application part to the database.
14.Create a backup copy of your database, accepting the default file name.
15.Add a Comments application part, selecting the option One ‘Loans’ to many ‘Comments’.  Select the LoanStatus field as the field from the Loans table and sort this field ascending. Name the lookup column Status and then click on the Create command button.
16.Open the Comments table. In row 1, enter Current in the Status column, select 12/23/2021 for the Comment Date, and enter the comment Loan 47 rate changed from 18.99% to 12.54%.  
17.Click on the Click to Add column heading and select the Short Text option. Change the Field1 column heading to Explanation. Enter the text Entry error in the Explanation column in row 1. 
18.Close the Comments table. Right-click on the Comments table in the navigational pane and rename it Interest Rate Changes.
19.Close the database and exit Access. 
20.Submit the Acc1Loans_LastFirst.accdb file and its backup file for marking.

 

    

This IT Assignment has been solved by our IT Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
    
Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

  • Uploaded By : Roman
  • Posted on : February 02nd, 2020
  • Downloads : 280

Whatsapp Tap to ChatGet instant assistance