Language: SQL

On Microsoft Access

You learned how to create a table, to add data to it, to query it and display it using a date format.

Now, you will create a new table to keep track of holidays in the state of Florida for 2014.

Put three columns in the table: a sequence column, a text column, and a date column.

Put a primary key on the table; use the sequence as a primary key.

Make one row for each day of the nine holidays as shown in table 1 of your database table.

Create a query to list all nine holiday while formatting the dates to show the day of the week, the full name of the month, and a four-digit year.

Run the query and validate your results.

How to submit your work:

Place all the code you used in your query for the creation of the table in a word document as a screenshot of your RDBS GUI, or a text file as plain text.

Place the SQL query you used to pull the data from the newly created table in the same format (in a word document as a screenshot of your RDBS GUI, or a text file as plain text.) below the query for the creation of the table.

After you run the query successfully, add the result list at the end of your report file.