Home /
Expert Answers /
Computer Science /
1-create-a-new-table-in-design-view-as-follows-a-add-a-field-with-the-name-involvementid-and-the-pa596
(Solved): 1. Create a new table in Design View as follows: a. Add a field with the name InvolvementID and the ...
1. Create a new table in Design View as follows: a. Add a field with the name InvolvementID and the AutoNumber data type. b. Set the InvolvementID field as the table's primary key. Save the table with the name Involvement, but do not close it. 2. With the Involvement table still open in Design View, add a second field to the table using the field name MemberNo and the Number data type. 3. In Design View, add a third field to the Involvement table using the field name EventName and the Short Text data type. 4. In Design View, add a fourth field to the Involvement table using the field name EventDate and the Date/Time data type. 5. In Design View, add a fifth field to the Involvement table using the field name HoursDonated and the Number data type. Save the Involvement table and switch to Datasheet View. 6. In Datasheet View, enter the two records shown in Table 1 below into the Involvement table. Close the Involvement table and save it, if necessary. Table 1: New Records for Involvement Ioble