Assignment
1. Open tblFacilities in datasheet view. Notice that the fields Management, Facility Type and Manage Type are numbers. Modify these fields to store a number but show a text value instead.
2. In the Relationship window, modify the three relationships to enforce referential integrity.
3. Create a relationship report that only shows the tables tblFacilities, tblManagement, tblFacType, tblManageType. Make sure that all fields and relationship are visible. Save the relationship report as rptRel.
4. Create a query named qryFac-Lookups. Include the fields FacID, MgtID, FacTypeID, MgtTypeID. Show only hospitals that are Long Term (FacTypeID 3) facilities.
5. Create a query named qryMgtContacts. Add the name of the management companies. Next add a field that includes the contact's first names. The field's label should be Name. Add the contact's phone number.
Attachment:- Data-File.rar