Illustrated Access 2016 Module
Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10
Illustrated Access 2016 | Module 1: SAM Project 1a
Illustrated Access 2016 | Module 1: SAM Project 1a
Volunteer Service Hours Database
CREATING A TABLE AND BUILDING A RELATIONSHIP
Open the file IL_AC16_1a_FirstLastName_1.accdb, available for download from the SAM website.
Save the file as IL_AC16_1a_FirstLastName_2.accdb by changing the “1” to a “2”.
- Hint: If you do not see the .accdbfile extension in the Save As file dialog box, do not type it. Access will add the file extension for you automatically.
Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.
- Create a new table in Design View as follows:
- Add a field with the name InvolvementIDand the AutoNumber data type.
- Set the InvolvementIDfield as the table’s primary key.
Save the table with the name Involvement, but do not close it.
- With the Involvement table still open in Design View, add a second field to the table using the field name MemberNoand the Number data type.
- In Design View, add a third field to the Involvement table using the field name EventNameand the Short Text data type.
In Design View, add a fourth field to the Involvement table using the field name EventDate and the Date/Time data type.
- In Design View, add a fifth field to the Involvement table using the field name HoursDonatedand the Number data type. Save the Involvement table and switch to Datasheet View.
- 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 Table
InvolvementID MemberNo EventName EventDate HoursDonated 1 1 Adair Project 7/1/2019 5 2 2 Scout Camp 8/1/2019 4
Open the Members table in Design View. Change the name of the field named First to MemberFirst, then change the name of the field named Last to MemberLast.
With the Members table still open in Design View, change the data type property of the Bio field to Long Text.
In Design View, add a new field to the Members table after the Bio field. The field should be named CellPhone and have the Short Text data type. Save and close the Members table.
- Create a new relationship in the database as described below:
- Open the Relationships window, then add the Involvementtable to it. Close the Show Table dialog box.
- Create a one-to-many relationship between the Membersand Involvement tables using the common MemberNofield.
- Enforce referential integrity on the relationship.
Save and close the Relationships window.
- Open the Memberstable in Datasheet View. Find, select, and delete the record with the MemberNofield value 32 (and the MemberFirst and MemberLast field values Taney Wilson) from the Members table.
- With the Memberstable still open in Datasheet View, navigate to the record with the MemberNofield value 10 (and the MemberFirst and MemberLast field values Allie Pitt), then change the MemberLast field value to Espinoza.
- With the Memberstable still open in Datasheet View, navigate to the record with the MemberNofield value 35 (and the MemberFirst and MemberLast field values Joshua Parton), then change the Street field value to 202 Adams St. (Hint: be sure to include the period.) Close the Members table and save it, if necessary.
- Open the Memberstable in Datasheet View, then expand the subdatasheet for MemberNo 2. (Hint: You should see one related record from the Involvementtable.) In the subdatasheet, change the value of the EventName field to Boy Scout Camp. Close the Members table.
Save and close any open objects in your database. Compact and repair your database using the Compact and Repair Database button on the Database Tools tab of the Ribbon, close it, then exit Access. Follow the directions on the SAM website to submit your completed project.
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
The background and/or significance are missing. No search history information is provided.
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow