Access Design and SQL Project:
There are three parts to this project:
Search the web to find the information you will need to populate the database.
Develop and populate a database table using data appropriate for the queries you need to make.
Query the database using SQL
First you need to search the web and find 10 articles that talk about soft skills: what they are and the value that business places on them. The information about these articles is what you are going to store on the database table that you are creating. Be sure to check the queries before entering the data so you know what you need to have in the database to answer the queries.
You need to design and setup a database table within a database to hold the information about the articles (be sure to check the queries below to help you decide about what data to use):
Each record should have a 5 digit unique identifying number (you decide on what numbers to use)
Name of the article
Web address to retrieve the article
Publication or web site where it appears
A code from 1 to 3 where you rank the credibility of the web site. If you recognize the site and find it credible give it a 1, if you are not sure about the credibility give it a 2, if you think the site is unreliable give it a 3. You should have some variety in your codes so you can effectively query the table.
Primary author of the site (first author listed)
Your opinion of the article. Rank the article from 1 to 5 based on whether you found the article provided a good explanation of what soft skills are and the value that business place on these skills. You should have some variety in your codes so you can effectively query the table.
Year of publication