Small Access Project - Create Query

Hello! Attached you will find an access database with Three Tables: Counties Districts Entities You will also find the file InstCode.txt. Step #1: Create a table called Institution Type in the access database with the Institution Type, Institution Detail and Institution number. For example, the first record would be: Institution Type = Public School District Institution Detail = Boces Institution Number = 00 Step #2: Please create one query that contains all of the Fields in Entitites Table with the following: a. The actual County name should be displayed instead of the county number b. The actual District Name should be displayed instead of the District number. c. The actutal instiution type and detail should be displayed instead of a number. Then, please make duplicate the query above, and make a seperate query for the following counties: Suffolk Nassau Kings Queens Richmond Manhattan Bronx Westchester Putnam "Suffolk" ## Deliverables 1) Complete and fully-functional working program(s) in MS-Access form as well as complete source code (if any) of all work done. 2) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows XP / MS-Access 2003