Reference no: EM131480665

None of the answers can be in excel format. They must be typed into the answer. This must be done within 2 hours and 15 minutes.

1.) Create a table "ResourceTypes" with the following fields (as always: keep the field names exactly as specified below and the data types, sizes and ranges exactly as specified. All fields required unless specified):

TypeId - autonumber unique id/primary key

Type - text(30) - examples could be Book, CD, DVD, Tape, VHS, eBook, Paper, Article, Movie, 35mm, etc...

Comment - Text(100)

Status - Active or Inactive

2.) Create a table "Resources" with the following fields (as always: keep the field names exactly as specified below and the data types, sizes and ranges exactly as specified. All fields required unless specified):

ResourceId - autonumber unique id/primary key

TypeId - foreign key referencing the ResourceTypes table from Question 1

Resource - text(50)

Author - text(50)

Title - text(100)

PublicationReleaseDate - date

Quantity - integer number between 0 & 1,000,000

Comment - Text(100)

Status - Active or Inactive

3.) Create 5 records in each of the tables ResourceTypes and Resources. All values must be meaningful, compliant with the data types, data sizes, data values, and data bounds.

Values for the TypeId in the Resources table must reference the TypeId values for the foreign key TypeId in the ResourceTypes table.

4.) Create a query named ResourcesQry which displays all resources as specified below:

Resource, Author, Title, PublicationReleaseDate, Type, Quantity

Hint: your answer should only be the actual query statement.

5.) Run or Execute the query ResourcesQry and display the results below.

Hint: your answer should be a result-set table that displays the values of each of the fields for Resource, Author, Title, PublicationReleaseDate, Type, Quantity fields from the query.