E-R AND DATABASE ASSIGNMENT

E-R and Database Assignment

E-R and Database Assignment

A ) Query to find the customer

Running into duplicate data for finding customers in an Access Database can be quite annoying during the hectic workday. There are many causes for duplicate data: for instance if you have multiple users entering data simultaneously via linked tables, or you might inherit a table with duplicate data already entered (Batini, 2002).

First open the MDB (Microsoft Database) containing the table you want to check for duplicates. Click on the Queries tab and New.

SELECT Contacts.

FROM Contacts LEFT JOIN Sales

ON Contacts.Rep = Sales.Rep

WHERE Sales.SaleDate Is ...