ITEC 315 Towson University Easy Access Database Project Computer Language Task

This should not take you long if you are familiar with access database, it is due tonight but is only maybe a hour worth of work. will pay 2 hours worth

The final project should 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 5 rows of data.

You must also have a four queries defined to perform CRUD from each 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’;