Assignment: SQL Statements, MS ACCESS
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
1. Click on the Create Menu Button
2. Select Query Design
3. Depending on which version of Access you have Select SQL View if you have ACCESS 2013
4. In older versions select View then SQL View
5. 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
6. Save the Query as
o Add Painter or Artist incrementing each query name by 1 to distinguish one insert from another
o Add Gallery
o Add Painting
7. 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.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.