1) Using the Access QBE or SQL, produce and run the view-equivalent queries to answer the questions that follow. Save each query using the query name format viewViewQueryName, where ViewQueryName refers to the name specified within the question.

a) Produce an Access view-equivalent query named CustomerContact that shows the CUSTOMER, CustomerID, FirstName, LastName, Date, Type, and Remarks.

b) Produce an Access view-equivalent query named SalespersonCustomerContact that displays SALESPERSON.NickName, SALESPERSON.LastName, SALESPERSON.FirstName, CUSTOMER.CustomerI, CUSTOMER.LastName, CUSTOMER.FirstName, Date, Type, and Remarks.

c) Produce an Access view-equivalent query named Computer that shows Make, Model, ProcessorType, SerialNumber,ProcessorSpeed, MainMemory, and DiskSize.

d) Produce an Access view-equivalent query named EmployeeComputer that uses viewComputer for 3) above to show the EMPLOYEE.EmployeeNumber, LastName, FirstName, and data related to the computer assigned to that employee, involving Make, Model, SerialNumber, ProcessorType, ProcessorSpeed, MainMemory, and DiskSize.