Access Assignment - Implement the Oil Company Database
Your assignment this week is to implement your design of the oil company. I suggest that you make sure I have checked the design before you implement it. Send it to me and I will look at it - feel free to nag me if I don't get it back quick enough!!!!!
Problem 1: Create an oil company database with tables that correspond to your design. Make sure that you establish primary keys and that you use tools, relationship to establish relationships. Also you must enter data into the tables so you can test.
Problem 2: Write three queries of your own design - tell me what you are trying to accomplish - that use two tables.
Problem 3: Write two queries of your own design - tell me what you are trying to accomplish - that use three tables.
Problem 4: Write a query that uses parameters. Try one testing against one parameter and try one with the between.
Problem 5: Write a query that uses the top 10 or top10% or something similar.