This project requires knowledge in SQL Server 2005 and MS Access 2003 syntax.
It consists of converting SQL Server stored procedures into MS Access queries.
In the attached files you will find the SQL script creating the stored procedures, and a 'mdb' file with empty data tables, that will be used by the queries.
? The project should comply with the following instructions:
1. The name of the MS Access query should be exactly the same as the? ? ? ? SQL stored procedure, including the 'sp' prefix.
2. Keep a convention inside the queries for parameters names and differ them from tables names.
3. The tables and columns names should remain the same.
4. Make sure to test each query on the 'mdb' file.
Write clean, understandable and commented code.