Higher+Queries+and+Validation+Practical+Tasks


 * Y **** our teacher will show you how to complete queries and validate input within Microsoft Access. **

For the following tasks, under the section ISDD, create the page "Queries and Validation".
 * Computing OneNote Instructions **

Lewis Brindley is a web developer for Forrester Sports TV Network. In preparation for the Euro 2016 competition in France, Forrester has decided to display their top 10 players that will be at the competition on their website. After discussing with experts, Lewis creates the following table in a Word document ready to go into a website's database.
 * Task 1 - Euro 2016 **





1. Lewis knows he will have to split this data into two separate tables for his database to work. Complete the following data dictionary for this database. State Validation that might be needed and create any Primary Keys / Foreign Keys if needed for the relational link between the two:



2. Create the relational database with all links and validation stated in your data dictionary.

3. Screenshot your database tables in both design view and table views and paste your evidence in your OneNote notebook.


 * Task 2 - Queries **

Lewis wants to create a set of queries that might be searched for on the Forrester Sports Network website. Complete the following queries and copying and paste both the design and run views into your OneNote file.


 * Example answer: **

Example 1: find all the players that play for the Swedish team

Answer: Country = "France"

1. Find all the players that play for the Swedish national team. 2. Find all the players that play in Forward position. 3. Find all the Midfield Players that play for the French national team. 4. Find all the players that play for countries that are ranked lower than 10 in the UEFA Rankings. 5. Find all the French players that have shirt numbers lower than 11.