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_INSE
The post SQL statements provided appeared first on Assignment Freelancers.