Paterson Credit Union
You work as a database administrator at the Paterson Credit Union. You are modifying a database to add a lookup form, change an existing form to fix the tab order, include a combo box, and add text, and create a new report grouped by the type of loan.
For the purpose of grading the project you are required to perform the following tasks:
Start Access. Open the file namedexploring_a07_grader_a1_Bank.accdb.
Select the Customers table and use the Form tool to create a new form. Change the title to View Customers. Delete the subform containing loan information.
Change the Allow Edits, Allow Additions, and Allow Deletions settings to No. View the form and data in Form view. Save the form as View Customers and close the form.
Create a new table named AccountTypes in Design view. Name the first field AccountType, and then change the data type to Short Text. Set the field to be the primary key. Enter three records, Gold, Platinum, and Silver (in that order). Close the table.
Open the Update Customers form in Design view. Change the AccountType field to a Combo Box. Set the Row Source to AccountTypes and the Limit To List property to Yes.
Fix the tab order so the ZipCode field comes immediately after the State field. Save and close the form.
Open the View Customers form in Design view. Add a new label control in the left-side of the form footer at the 0.5-inch mark on the horizontal ruler that displays the text Always verify customer address information!. Change the font color to Black, Text 1 and bold the text. Change the font size to 18. Drag only the right border of the control to the 6-inch mark on the horizontal ruler so the text displays. Save and close the form.
Create a new report based on the Loans table using the Report Wizard. Select the
CustomerID, Date, Amount, and InterestRate fields. Remove the proposed grouping by the CustomerID field. Accept all other default options.
Switch to Layout view. Add grouping by the Type field. Add a sort by the Date field from oldest to newest. Switch to Design view. Display the Group Footer. Display the count of the CustomerID records in the Type Footer.