FINAL PROJECT – FINAL Project Submission FINAL PROJECT
The final project must b
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 3rd 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:–CREATEINSERT INTO Customers (FirstName, LastName) VALUES (‘John’, ‘Doe’);–READSELECT * FROM Customers WHERE FirstName = ‘John’ and LastName = ‘Doe’;–UPDATEUPDATE Customers SET FirstName = ‘Jane’, LastName = ‘Smith’ WHERE FirstName = ‘John’ and LastName = ‘Doe’;–DELETE DELETE FROM Customers WHERE FirstName = ‘Jane’ and LastName = ‘Smith’;
