Mircsoft Access Assignment Assignment | Homework Help Websites

IllustratedAccess 2016| Module 1: SAM Project 1a

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Volunteer Service Hours Database

CREATING A TABLE AND BUILDING A RELATIONSHIP

 

GETTING STARTED

  • Open the file IL_AC16_1a_FirstLastNameaccdb,available for download from the SAM website.
  • Save the file as IL_AC16_1a_FirstLastNameaccdbby changing the “1” to a “2”.

o    Hint: If you do not see the .accdb file extension in the Save As file dialog box, do not type it. Access will add the file extension for you automatically.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
  • Open the _GradingInfoTabletable 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.

 

PROJECT STEPS

  1. Create a new table in Design View as follows:
    1. Add a field with the name InvolvementID and the AutoNumber data type.
    2. Set the InvolvementID field as the table’s primary key.

Save the table with the name Involvement, but do not close it.

  1. 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.
  2. In Design View, add a third field to the Involvement table using the field name EventName and the Short Text data type.
  3. In Design View, add a fourth field to the Involvement table using the field name EventDate and the Date/Time data type.
  4. 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.
  5. In Datasheet View, enter the two records shown in Table 1 below into the Involvement Close the Involvement table and saveit, 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

 

  1. 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.
  2. With the Members table still open in Design View, change the data type property of the Biofield to Long Text.
  3. In Design View, add a new field to the Members table after the Bio The field should be named CellPhoneand have the Short Text data type. Save and close the Members table.
  4. Create a new relationship in the database as described below:
    1. Open the Relationships window, then add theInvolvement table to it. Close the Show Table dialog box.
    2. Create a one-to-many relationship between the Members and Involvementtables using the common MemberNo
    3. Enforce referential integrity on the relationship.

Save and close the Relationships window.

  1. Open the Members table in Datasheet View. Find, select, and delete the record with the MemberNo field value 32 (and the MemberFirst and MemberLast field values Taney Wilson) from the Members
  2. With the Members table still open in Datasheet View, navigate to the record with the MemberNo field value 10 (and the MemberFirst and MemberLast field values Allie Pitt), then change the MemberLast field value to Espinoza.
  3. With the Members table still open in Datasheet View, navigate to the record with the MemberNo field 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.
  4. Open the Members table in Datasheet View, then expand the subdatasheet for MemberNo 2. (Hint: You should see one related record from the Involvement) 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, thenexit Access. Follow the directions on the SAM website to submit your completed project.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Social Work and Human Services
Good work.
Customer 462793, July 8th, 2022
Finance/Acc Related
Well answered.
Customer 460073, April 29th, 2022
Communications
The best writer. Thank you!
Customer 462787, August 1st, 2022
Religious studies
Thank you very much. I am going to keep using this service.
Customer 454195, March 30th, 2020
Military
Satisfactory work.
Customer 456821, April 14th, 2022
Other
Good.
Customer 462635, June 14th, 2022
Medicine
The writer has a good content
Customer 463147, December 28th, 2022
Leadership Studies
Excellent job.
Customer 456821, April 21st, 2022
Education
written to perfection. Thank you
Customer 463813, April 11th, 2023
SEO
Well-written content. The writer follows instructions to the letter upon revisions.
Customer 463679, December 13th, 2022
Other
Thank you again for another beautifully written paper and writing the thoughts as if they were my own.
Customer 452455, February 26th, 2023
Geography
Good job. Adequate introduction and thesis, has cited evidence & satisafies the question in context.
Customer 463019, June 8th, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat