Data Normalization and other Tasks

I need to learn about these topics. Ususally I m using MS Access for design. Please check my previous work but stuck at data normalization.

Task 1: Data Normalization
Convert each of your relations schemas / tables to 3NF, showing all intermediate stages, that is, 1NF and 2NF

Task 2: Queries:

Minimum 5 different queries. For each query, provide the question that the query should answer and the SQL statement or Access Query required to answer the question. The questions should be of business value and should provide information you think is important to the management. Include screenshots of the result of each query in your report as a proof that it worked and produced the desired result.
Queries should include these if/when possible:
• Conditions using various operators on numbers, text and date columns with results sorted
• Conditions applied to more than one column (AND/OR in the WHERE clause)
• Arithmetic calculations and concatenated columns
• Column aliases where required
• Aggregate functions. (SUM, AVG, MIN, MAX, COUNT etc.)
• Queries displaying results from more than one table (joins)
• Queries including GROUP BY and HAVING

Task 3: Views / Reports
At least three useful and well designed data views / reports based on Task 2