Change the field size of the field to 3 . c. Add a new field with the name Description and the Short Text data type. Save the table with the name ClientTypes , but do not close it. 2. 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.
Shelly Cashman Access 2016 | Module 1: SAM Project 1b Table 1: Records for ClientTypes Table TypeID Description COM Commercial CRP Corporate RES Residential 3. Open the Manager table in Datasheet View. Add a new field following the PhoneNumber field with the field name StartDate and the Date/Time data type. Close the table. 4. Open the Client table in Design View and make the following changes to the AmountPaid field: a. Change the data type from Number to Currency . b. Change the Format property to Currency . c. Change the Decimal Places property from Auto to 2 . 5. With the Client table still open in Design View, add Manager of client properties as the Description (Optional) to the ManagerID field. 6. With the Client table still open in Design View, change the field size property for the ClientName field to 40 . Save the changes to the Client table, and then close it. ( Hint : Because there were changes to data types 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.)
You've reached the end of your free preview.
Want to read all 4 pages?
- Summer '19
- Osmosis, Manager Salary Report