Quest1
Make 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
Question 2
Make a 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
Question 3
Make 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.
Question 4
make a ResourcesQry which displays all resources as specified below:
Resource, Author, Title, PublicationReleaseDate, Type, Quantity
Question 5
Run or Execute the query ResourcesQry and take a screen shot of the results. Paste the screen shot into a Word document (or save it as a JPG or PDF).
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.