Referencing Styles : Open Resize the StateName field so that all field values are completely visible. Save and close the States table. 4. Open the Guides table in Datasheet view. Add a new field following the PostalCode field with the field name YearsExperience and the Number data type. Close the table. 5. Open the Trips table in Design view and make the following changes to the Distance field. a. Change the data type from Short Text to Number b. Change the Caption property to Distance (Miles) 6. With the Trips table still open in Design view, make the following changes to the GroupSize field: a. Change the data type from Short Text to Number b. Change the Decimal Places property from Auto to 0. c. Change the Caption property to Maximum Group Size 7. With the Trips table still open in Design view, change the Field Size property for the State field to 2. Save the changes to the Trips table and then close it. (Note: Because there were changes to data type and field sizes, the “Some data may be lost” warning message appears. The data fits within the valid ranges, so ignore this message and continue saving the table.) 8. Import the data from the Excel file support_A1_Trips.xlsx available for download from the Black Board website. Append the records into the Trips table. Do not create a new table and do not save the import steps. 9. Open the Trips table in Datasheet view, navigate to the third record (which has a TripID field value of CLNHP1) and enter KS01 for GuideID field value. Navigate to the previous record (which has a TripID field value of BPMEH1) and enter RH01 for the GuideID field value. Close the table. 10. Open the Guide Listing Query in Design view and add a criterion to select only those records with a State field value of NH. Run the query, then save, and close the query. 11. Use the Simple Query Wizard to create a query based on the Trips table with the following options: a. Include all fields from the Trips table in the query. b. Make sure the Detail option button is selected. c. Save the query with as Trips Query (which is the default name). Close the query. 12. Create a simple form for the Trips table. Save the form as Trips Form and close the form. (Hint: Use the Form button to create this form.)