Select and Update Data in Related Tables Instructions: Running reports on existing data and updating data records are very common tasks in the industry. Download and unzip the Microsoft® Access® database (ZIP file) available on the Cengage’s website. (You may need to convert the database depending on the version of Microsoft® Access® you are using. To convert the database, follow Microsoft®’s Convert a Database to the .accdb File Format instructions.) Open the database in Microsoft® Access® and explore the tables it contains by following this path: /folderYouNameWhenYouUnzip/1305627482_526407/Student/Ch07- Intro-to-SQL/Databases/Ch07_SaleCo.mdb Note: If you have chosen not to use Microsoft® Access® in this course, you will need to download the SQL statements for MySQL, Oracle®, or SQLserver and run those statements against your RDBMS to create a populated database. Download the Select and Update Data in Related Tables document and follow the instructions. Your completed assignment will consist of one document and two screenshots placed in one document (one screenshot showing the results of the “before” SELECT statement and a second showing the results of the “after” SELECT statement). Submit your assignment.

In this assignment, you will be working with a Microsoft Access database and performing tasks related to selecting and updating data in related tables. The purpose of this assignment is to familiarize yourself with running reports on existing data and updating data records, which are common tasks in the industry.

To begin, you will need to download and unzip the Microsoft Access database provided on the Cengage’s website. Depending on the version of Microsoft Access you are using, you may need to convert the database to the .accdb file format. You can follow Microsoft’s instructions to convert the database if needed. Once you have the database file, open it in Microsoft Access and explore the tables it contains.

The database is located within the downloaded and unzipped files on your computer. You can find it by following this path: /folderYouNameWhenYouUnzip/1305627482_526407/Student/Ch07-Intro-to-SQL/Databases/Ch07_SaleCo.mdb.

Note: If you have chosen not to use Microsoft Access in this course, you will need to download the SQL statements for MySQL, Oracle, or SQLserver and run those statements against your RDBMS (Relational Database Management System) to create a populated database.

Once you have the database open, you will need to download the “Select and Update Data in Related Tables” document provided to you. This document contains the instructions for the assignment. You will need to follow the instructions in the document to complete the assignment.

Your completed assignment will consist of one document and two screenshots placed in one document. One screenshot should show the results of the “before” SELECT statement, which will display the data before the update, and the second screenshot should show the results of the “after” SELECT statement, which will display the data after the update.

To submit the assignment, you will need to submit the document containing your completed assignment and the two screenshots.

In summary, for this assignment, you will be working with a Microsoft Access database to select and update data in related tables. You will need to follow the provided instructions and submit your completed assignment along with two screenshots of the before and after results of the SELECT statement.

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer