FINAL PROJECT $-$ FINAL Project Submission

FINAL PROJECT

The final project must be an Access database that contains a minimum of $10$ tables with $5$ relationships, in $3$rd normal form. Each table should have a minimum of $10$ rows of data.

You must also have four queries defined to perform CRUD from one table. There should be a total of $4$ saved queries minimum.

We$$re asking for the four basic CRUD queries for one table. For example, if you had a table called Customers, with FirstName and LastName, the four queries would be:

$--$CREATE

INSERT INTO Customers $($FirstName$,$ LastName$)$ VALUES $($John$,$Doe$)$;

$--$READ

SELECT $*$ FROM Customers WHERE FirstName $=$John$$ and LastName $=$Doe$$;

$--$UPDATE

UPDATE Customers SET FirstName $=$Jane$,$ LastName $=$Smith$$ WHERE FirstName $=$John$$ and LastName $=$Doe$$;

$--$DELETE

DELETE FROM Customers WHERE FirstName $=$Jane$$ and LastName $=$Smith$$;