Access Homework: create the following $3$ tables with the column names and sizes defined using create table SQL

Email Table

$\backslash$table$[[$EmailNum$,$Date,Message,Student Number$],[1,\frac{2}{1}\frac{?}{2012},$For homework $1,$ do you want us to provide notes on our references?,$1325],[2,3/15/2012,$My group consists of Swee Lau and Stuart Nelson.,$1325],[3,3/15/2012,$Could you please assign me to a group?,$1644]]$

Student Table

$\backslash$table$[[$Student Number,Student Name,HW$1,$HW$2,$MidTerm$],[1325,$BAKER, ANDREA,$88,100,78],[1644,$LAU, SWEE,$75,90,90],[2881,$NELSON, STUART,$100,90,98],[3007,$FISCHER, MAYAN,$95,100,74],[3559,$TAM, JEFFREY,,$100,88],[4867,$VERBERRA, ADAM,$70,90,92],[5265,$VALDEZ, MARIE,$80,90,85],[8009,$ROGERS, SHELLY,$95,100,98]]$

Office$\_$Visit Table

$\backslash$table$[[$VisitID$,$Date,,Notes,Student Number$],[2,\frac{2}{13}\frac{?}{2012},$Andrea had questions about using IS for raising barriers to entry.,$1325,],[3,\frac{2}{17}\frac{?}{2012},$Jeffrey is considering an IS major. Wanted to talk about career opportunities.,$3559,],[4,\frac{2}{17}\frac{?}{2012},$Will miss class Friday due to job conflict.,$4867,]]$

Note: $1.$ Table and Column names can't have space in between

$2.$ Change the column name Date on Email$\_$Table to Email$\_$Date, change Date on Office$\_$Visit to Visit$\_$Date

$3.$ You need to create $3$ queries, save query to names such as "create student table query, create email table query, and create office visit table query

$4.$ Once you have completed, close all tabs$,$ then click File, Save As$,$ then click on "Save As$"$ button, then save it as Section number? Your name? Access HW$,$ then submit the access file via Canvas, Assignments. $($No email submission is allowed$).$

HW$1-$Using SQL to create $3$ tables with the column names the same as the powerpoint slide I showed in class $($you can find it on Syllabus tab from the blackboard, the third file said $"$HW$1$ SQL using Access picture file".

You should go to SQL view, and type the SQL DDL keywords you learned in class to create $3$ tables:

Student, Email, and Office$\_$Visit tables

Each time when you are done with one table, save that que $[$y$.$ For example, if you completed creating table called student table, save the query as "Step $1$ create table student query"

Once you are done with creating $3$ tables, you should have $3$ queries already saved.

Then you will need to use SQL DML keywords to insert few records to the tables you created. The sequence matter! You should insert into the first table student first as it is the parent table.

You have options of inserting exactly what the powerpoint slide showed, or having your own records.

After you have completed all steps with inserting few records, then click File, Save As$,$ then make sure you click another button said "SAVE AS$",$ NOT "Save Object AS$",$ then save it to the desktop with section number along with your name and HW$2.$ Then log onto Webcampus, under Assignment, and send the file as an attachment before $11$:$59$ PM on the due date stated on the syllabus.