I need help with steps 10-14 in Access. (Showing steps would be helpful)

The Access Document: https://1drv.ms/u/s!AoQGMTkNnGG_hQWrVdk43ke1VBPv

EX16_AC_VOL1_GRADER_CAP_AS - Student Loans

Project Description:

Quill Financial Services has recently started working with student loans. You will build the companys 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.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

10	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.	10
11	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.	6
12	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 Information and close it.	12
13	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.	6
14	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.	4
15	Close all database objects. Close the database and then exit Access. Submit the database as directed.	0
	Total Points	100