Create an MSAccess query and report to produce the core HTML code of IPTV Directory ([url removed, login to view]) web page. The MSAccess query and report should be provided in a database in MSAccess 95 format.
The functionality should be the same as the existing [url removed, login to view] web page.
The query should produce:
1. Bookmark Tag for category select list (categorycode_AIS)
2. Category Heading in HTML format
3. Category description below the heading in HTML format
4. List of companies (Hyperlink) format
The end result we desire is to execute the query and to produce the HTML code that we can insert to the web page each week.
Only companies that have categories identified in the IPTV Directory Product Categories are to be included in the result.
Reference tables (database – LH):
[url removed, login to view] (access database file – remove the .tmp)