Further instructions in PDF link. .create a database to store information about the administrators of Texas Lakes Community College and their departments For Project 17D, you will need the following files: Blank database a17D_Administrators (Excel workbook) a17D_Departments (Excel workbook) You will save your database as: Lastname_Firstname_17D_College_Administrators Start Access. In the Access opening screen, click Blank database. In the Blank database dialog box, to the right of the File Name box, click Browse. In the File New Database dialog box, navigate to your Access Chapter 17 folder. In the File New Database dialog box, click in the File name box, type Lastname_Firstname_17D_ College_Administrators and then press . In the Blank desktop database dialog box, click Create. a. Close the Navigation Pane. In the field names row, click in the text Click to Add, and then click Short Text. Type Title and then press . b. In the third field name box, click Short Text, type Last Name and then press . In the fourth field name box, click Short Text, type First Name and then press . Create the remaining fields shown in Table 1, pressing after the last field name. All of the data is typed on one line. Table 1 Data Type Short Text Short Text Short Text Short Text Short Text Short Text Short Text Short Text Short Text Short Text Currency Field Name ID Title Last Name First Name Middle Initial Address City State Postal Code Phone Number Department ID Salary c. If necessary, scroll to bring the first column into view, and then click the ID field name. On the Fields tab, in the Properties group, click Name & Caption. In the Name box, change ID to Employee ID and then click OK. On the ribbon, in the Formatting group, click the Data Type arrow, and then click Short Text. d. In the new record row, click in the Employee ID field, type, ADM-9200 and press . In the Title field, type Vice President and press . Continue entering data in the fields shown in Table 2, pressing or to move to the next field and to the next row. Table 2 Last Name First Name Middle Initial Address City State Postal Code Phone Number Department ID Salary Shaffer Lonnie J 489 Ben Ave Austin TX 78734 (512) 555-6185 AS 123500 e. On the Quick Access Toolbar, click Save. In the Save As dialog box, in the Table Name box, using your own name, replace the selected text by typing Lastname Firstname 17D Administrators and then click OK. f. In the new record row, enter the data for two college administrators shown in Table 3, pressing or to move from field to field and to the next row. Table 3 Employee ID Title Last Name First Name Middle Initial Address City State Postal Code Phone Number Department ID Salary ADM-9201 Associate Vice President Holtz Diann S 8416 Spencer Ln Georgetown TX 78627 (512) 555-1069 AS 101524 ADM-9202 Director, Enrollment Services Fitchette Sean H 3245 Deer Trl Spicewood TX 78669 (512) 555-9012 SS 45070 g. Close your 17D Administrators table. On the External Data tab, in the Import & Link group, click New Data Source, click From File, and then click Excel. In the Get External Data – Excel Spreadsheet dialog box, click Browse. In the File Open dialog box, navigate to your student data files, and then doubleclick the a17D_Administrators Excel file. h. Click the Append a copy of the records to the table option button, and then click OK. In the Import Spreadsheet Wizard, click Next, and then click Finish. In the Get External Data – Excel Spreadsheet dialog box, click Close. Chapter Review Skills Review: Project 17D College Administrators (continued)

Overview: You just began a position as a financial accountant at Peyton Approved. In this role, your first task is to prepare the company’s financials for the year-end audit. Additionally, the company is interested in expanding its business within the next year. They would like your support in assessing their ability to meet their goals. Refer to the data below and use the Final Project Workbook that includes the income statement, balance sheet, retained earnings statement and cash flow statement to complete the final project and associated milestones. Peyton Approved Financial Data: Preliminary Financial Statements have already been prepared (2017 statements in the Final Project Workbook).Final adjusting entries have not yet been made. See table for possible adjustments that indicate what will be recorded at 12/31/17 (fiscal year end). Use the following to complete year-to-year documentation and notes for managing depreciation, inventory, and long-term debt. A supplier shipped $3,000 of ingredients on 12/29/17. Peyton receives an invoice for $3,175 for the goods and freight of $175, all dated 12/29/17. Goods were shipped FOB supplier’s warehouse. At 12/31/17, Peyton has $200 worth of merchandise on consignment at Bruno’s House of Bacon. On 12/23/17, Peyton received $1,000 deposit from Pet Globe for product to be shipped by Peyton in the second week of January. On 12/03/2017, a mixer with a cost of $2,000, accumulated depreciation $1,200, was destroyed by a forklift. As of 12/23/17, insurance company has agreed to pay $700 in January, 2018, for accidental destruction. The company is planning to open another location in 2018. Using the Preliminary Statements as a base, prepare pro forma (budgeted) financials for 2018 for the new location using the following information: Cost of leasing commercial space: $1,500 per month. Cost of new equipment: $15,000, purchased with a long-term note. Use straight line depreciation assuming a seven-year life, no residual value. Use full year’s depreciation for the first year.Equipment purchase was financed with a long-term note. Cost of hiring and training new employees: three at $25,000 each for the first year. Except as noted in 1, 2, 3, and 5, assets, current liabilities, sales, costs, and expenses are expected to be 80% of the existing store (from preliminary statements) except no stock. Retained earnings = net income. Cash: $7,000. Accounts receivable amount to 4.0 turns (accounts receivable turnover will be 4.0); inventory amount to show 3.0 turns (inventory turnover will be 3.0). No stock will be issued. Retained earnings are to equal net income. Additional financing of $5,000 will be long-term. Add remaining amount needed to balance into accounts payable. For notes to the financial statements and Management Analysis Memo, consider the following: Peyton Approved uses the following accounting practices: Inventory: Periodic, LIFO for both baking and merchandiseEquipment: Straight line method used for equipment6% interest note payable was made on Jan 31, 2017, and is due Feb 1, 2019.5-year loan was made on June 1, 2016. Terms are 7.5% annual rate, interest only until due date.Insurance: Annual policy covers 12 months, purchased in February, covering March 2017 to February 2018. No monthly adjustments have been made. Business Financing Information: Use this information to calculate interest rates and insurance information, and to assess their impact on the company’s financial obligations: