Limited Offer Get 25% off — use code BESTW25
No AI No Plagiarism On-Time Delivery Free Revisions
Claim Now
Prices start at $5 per page · plagiarism-free papers · free revisions for 14 days 24/7 support: support@bestwriters.com
Uncategorized

Inserting the data

  • Posted
  • Authoradmin
  • Length517 words
  • Reading time3 min
Write My Assignment FREE

You must use the attached file content.

Using the SQL statements provided write CREATE and INSERT statements to populate the ARTIST, GALLERY and PAINTING tables in Microsoft ACCESS. When inserting the data remember that if the data is Text data it should be enclosed in single quotes if it is numeric it will not be enclosed in quotes. Review the examples in chapter 7. You will need to save your Statements in MS Access in the Query view to receive credit for this exercise. I will need to see an INSERT statement for the Artist Table, the Gallery Table and the Painting Table. You will need to insert records into the Parent table before entering records into the child/related table. In addition create 2 new INSERT statements by copying 2 of the existing INSERT statements from each table and change the data and save those INSERT statements with a name of NEW_INSERT_PAINTER_1 , NEW_INSERT_GALLERY_1, NEW_INSERT_PAINTING_1. Increment the 2nd INSERT STATEMENT and save it to the query view pane.

When creating a query in ACCESS do the following

Click on the Create Menu Button
Select Query Design
Depending on which version of Access you have Select SQL View if you have ACCESS 2013
In older versions select View then SQL View
Execute your CREATE and INSERT statements and add the data. Review the examples in Chapter 7 on Adding Table Rows for help with writing Insert statements
Save the Query as
Add Painter or Artist incrementing each query name by 1 to distinguish one insert from another
Add Gallery
Add Painting
You will insert each record in each table. Again, I emphasize the SQL Statements must be saved in order to get credit. I will test your SQL statements to see if they work. I have included the text file that has both the CREATE and INSERT statements. You will use these in the Query View of SQL to learn to write simple SQL Statements.
Please make sure that you turn on the primary key field. You can do this in ACCESS by going to DESIGN VIEW and click on the row that is the primary key of the table and then go to TOOLS and select primary key.

DELIVERABLES

Do not make this assignment complicated. You are simply copying the text provided and executing the SQL statements and creating 2 new INSERTS for each of the 2 entities. I need you to save 6 INSERT statements total not including the ones provided for this exercise. If you don’t save the statements I will lose a significant amount of points because everything is already provided. You will execute the INSERT statements provided to populate the table but do not save the queries provided for these statements. I already have them. Save only the 6 new queries by modifying the INSERT statements data values to the GALLERY, PAINTER and PAINTING tables.

I have including an attachment name Ch07_Artist_SQL.txt. These are the INSERT Statements you will use in this assignment.

When you have completed the assignment, first close ACCESS and then upload the database to B

The post Inserting the data appeared first on My Assignment Online.

Plagiarism Free Assignment Help

Expert Help With This Assignment — On Your Terms

✓ Native UK, USA & Australia writers ✓ Deadline from 3 hours ✓ 100% Plagiarism-Free — Turnitin included ✓ Unlimited free revisions ✓ Free to submit — compare quotes

admin

Academic writer and editor at BestWriters.

Get your paper off your plate tonight

Post your instructions for free. Prices start at $5 per page.

Place an order