Shelly Cashman Access 2016 | Module 1: SAM Project lb ' All Around Outside Maintenance CREATING AND MODIFYING TABLES AND OTHER DATABASE OBJECTS GETTING STARTED .Open the file SC AC161b_FirsttastName 1.accdb, available for download . Save the file as SC AC16 1b_FirstLastName 2.accdb by changing the "1 from the SAM website to a "2" o Hint: If you do not see the .accdb file extension in the Save As dialog box, do not type it. Access will add the file extension for you automatically To complete this Project, you will also need to download and save the following support file from the SAM website: o Support SC AC16_1b_Property.xlsx displayed as the first record in the table. If the table does not contain your Open the _GradingInfoTable table and ensure that your first and last name is name, delete the file and download a new copy from the SAM website. PROJECT STEPS You work for All Around Outside Maintenance, an outdoor maintenance company, and have decided to create an Access database to make it easier to keep track of business information. In this project, you will create and update tables, import data, and create queries, forms, and reports. 1. Create a new table in Datasheet View with the following options: a. Rename the default primary key ID field to TypeID and change the data type to Short Text. (Hint: TypeID should remain the primary key.) Change the field size of the field to 3. Add a new field with the name Description and the Short Text data type. b. c. Save the table with the name ClientTypes, but do not close it. With the ClientTypes table still open in Datasheet View, add the three records shown in Table 1 on the next page. If necessary, resize the Description field so that all field values are completely visible. Save and close the ClientTypes table. 2. Shelly Cashman Access 2016 | Module 1: SAM Project lb ' All Around Outside Maintenance CREATING AND MODIFYING TABLES AND OTHER DATABASE OBJECTS GETTING STARTED .Open the file SC AC161b_FirsttastName 1.accdb, available for download . Save the file as SC AC16 1b_FirstLastName 2.accdb by changing the "1 from the SAM website to a "2" o Hint: If you do not see the .accdb file extension in the Save As dialog box, do not type it. Access will add the file extension for you automatically To complete this Project, you will also need to download and save the following support file from the SAM website: o Support SC AC16_1b_Property.xlsx displayed as the first record in the table. If the table does not contain your Open the _GradingInfoTable table and ensure that your first and last name is name, delete the file and download a new copy from the SAM website. PROJECT STEPS You work for All Around Outside Maintenance, an outdoor maintenance company, and have decided to create an Access database to make it easier to keep track of business information. In this project, you will create and update tables, import data, and create queries, forms, and reports. 1. Create a new table in Datasheet View with the following options: a. Rename the default primary key ID field to TypeID and change the data type to Short Text. (Hint: TypeID should remain the primary key.) Change the field size of the field to 3. Add a new field with the name Description and the Short Text data type. b. c. Save the table with the name ClientTypes, but do not close it. With the ClientTypes table still open in Datasheet View, add the three records shown in Table 1 on the next page. If necessary, resize the Description field so that all field values are completely visible. Save and close the ClientTypes table. 2