Creating the User Interface

See Also

To make it possible for users to work with data in your team solution, you must provide a user interface. When you create a team solution using the supplied Issue Tracking template, a Web-based user interface using data access pages is created for you.

Although you can use any form of user interface that has read/write capabilities on a SQL Server database, the topics in this section use the data access pages in Access 2000 and FrontPage to create Web-based user interface.

For details about requirements and limitations with the solution user interface, see User Interface Considerations.

For additional information about data access pages, see the Access 2000 online Help, and search the Office Developer Web site at http://msdn.Microsoft.com/officedev/. The MSDN Library also contains reference material for creating Web sites. For details about accessing the MSDN Library, see Finding Information.

To create a team solution Web-based user interface

  1. Create a Web site on a server. For details, see Creating a Web using FrontPage.

  2. Create an Access Data Project. For details, see Selecting the Data Source.

  3. Create your team solution. For details, see Creating a Team Solution from a Database.

  4. Create the data access pages required to display your data. Typically, a summary view of all workflow items are contained on one page, while a second page makes it possible for you to view and edit detail information for a selected item. For details, see Creating Data Access Pages. For an example, see the Issue Tracking solution.

  5. Add the necessary database columns to each data access page, and format the user interface as desired.

  6. Add an offline redirection script, or use the Microsoft Office Developer Workflow Toolbar control. For details, see Workflow Toolbar Control.

  7. Create Web pages to provide help to users. For details, see Adding Help to Your Team Solution.