Hyperlink subaddress syntax

To go to a location
in this type of file

Enter
Microsoft Access The object type and object name. For example, enter Table Customers to go to the Customers table.

Notes   If you omit the object type, and there are multiple objects with the same name, Microsoft Access uses the following order to determine which one to reference: forms, reports, queries, tables, data access pages, macros, modules, views, schemas, stored procedures, SQL linked tables, linked tables, and triggers. For example, if there is both an Orders form and an Orders table, Access assumes the reference is to the Orders form. To specify the Orders table, you must enter Table Orders.

On a non-English system, Access recognizes the object type in English and in the local language; however, hyperlinks created by using the Insert Hyperlink dialog box all have the English-language string for an object type.

Microsoft Excel A defined name or a sheet!range. For example, enter sheet1!A2 to go to the A2 cell in sheet 1.
Microsoft PowerPoint A slide number
Microsoft Word A bookmark name
HTML document A bookmark name (defined by using the NAME attribute of the <A> tag)