MS Access


In MS Access I have a database of 5000 companies. I need you to create a GUI to make queries. 

Query the database to retrieve the following information:   

  1. Companies with the same type of      business
  2. Companies in the same region (use post      codes for this query)
  3. Companies with similar names (report their      company numbers and post codes)
  4. Companies which were created in the      last 5 years
  5. Companies which are based in London and      no longer active
  6. Companies created before 01/01/1970      which are still active
  7. The longest existing Active company in      your database.
  8. All public limited companies.
  9. Select companies involved in computing      business.