Question

• Open the file SC_AC16_3b_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as SC_AC16_3b_FirstLastName_2.accdb by changing the “1” to a “2”.
  • Hint: If you do not see the .accdb file extension in the Save As 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.

Answer 1

Hey, If you are curious about how these things could be done, I am here to help you.

For simplicity purposes, I had divided the explanation into parts.

So, let's start:

PART ONE: UNDERSTANDING THE REQUIRED NUMBER OF STEPS:

According to the problem statement:

1. You need to download a SC_AC16_3b_FirstLastName_1.accdb file from SAM Website. I assume you are being provided the address or URL of the website.

ACCDB means a file that belongs to the type access database.

2. Next step is you need to rename the file as SC_AC16_3b_FirstLastName_2.accdb.

3. You need to open this database and scroll to the table _GradingInfoTable. Please check whether your first name and last name is present as the first record in the table.

4. if yes, File integrity is maintained and it's not corrupted.

5. if no, File integrity has been modified and it has been corrupted and you need to download a new file.

PART TWO: OBJECTIVE OF THIS ACTIVITY:

This exercise is an introductory exercise to understand the concept of data integrity in cryptography.

whenever you download a file, how could you ensure that this file is not being modified?

This can be only done when you know the original file contents.

For maintaining the data integrity, message digests are attached to the file. Message digests are hash of the entire data.

When the receiver receives the data, it recalculates the hash and compares it with the attached hash from the sender. If both hashes are equal, the file is not modified and if not file is modified or corrupted.

So, once you downloaded your database and if that database containing tables doesn't contain your name, it means the accdb file has been modified or corrupted.

Hence, you need to understand the data integrity is lost and re-downloading the file is required.

Bonus Point: If during the Save-as window, you don't see the extension .accdb it means that Windows will take care of the extension and you only need to write the name of the new file as SC_AC16_3b_FirstLastName_2

I hope this might helped you in understanding the importance of this exercise.

Please don't forget to thumbs up if it helped you.

Keep learning and keep HomeworkLibing :)

All the best

*****************************COMPLETE****************************