Video: Use the Issues Web Database template

This video shows you how to use the Issues Web Database to track maintenance or other issues in your home or workplace. Learn how to keep track of open and closed issues, customize drop-down lists, print reports, and publish the database to an Access Services SharePoint site.

In the video

Add a new issue

View and edit issues

Edit the items in a drop-down list

Attach files to a record

Preview and print a report

Publish the Issues Web Database to Access Services

Add a new issue

1. Click the Open Issues tab.

2. Click New Issue.

3. In the Issue Details form, fill in the information that you have.

4. If you want to add another contact, click Save & New, and repeat step 3. Otherwise, click Save & Close.

Top of Page

View and edit issues

1. Click the Open Issues tab.

2. In the Summary column of the datasheet, double-click the issue that you want to view or edit.

3. Edit the information as needed, and then click Save or Save & Close.

Top of Page

Edit the items in a drop-down list

Many of the drop-down lists in the Issues Web Database can be edited to suit your needs. Use the following procedure:

1. Click the down-arrow to display the list.
   
   If the list is editable, the Edit List Items button will appear just below the list.
   

2. Click the Edit List Items button.

3. If the Edit List Items dialog box appears:

   1. Type the list items you want, one on each line.

   2. Optionally, select a default value from the Default Value list.

   3. Click OK.

4. If a Details form appears:

   1. Click the New (blank) record button at the bottom of the form.

   2. Type the information in the form, and then click Save and Close.

Top of Page

Attach files to a record

If a form or datasheet contains an Attachments field, you can use that field to attach pictures, documents, or other files to the record. Use the following procedure:

1. Double-click the Attachments field.

2. In the Attachments dialog box, click Add.

3. Browse to the file you want to attach, and then click Open.

4. In the Attachments dialog box, click OK.

Top of Page

Preview and print a report

The Issues Web Database template includes four reports. To preview a report:

• Click the Report Center tab, and then under Select a Report, click the report you want to view.
  
  Access displays the report in the preview pane. To print the report:
  

• Click Open in New Tab, and then on the File tab, click Print, and select the print option that you want.

Top of Page

Publish the Issues Web Database to Access Services

If you have access to a SharePoint server that is running Access Services, you can publish the Issues Web Database to the server and share it with your team. Use the following procedure:

1. Click the File tab, and then click Publish to Access Services.

2. In the Server URL box, type the URL of the SharePoint server that you want to use.

3. In the Site Name box, type the name you want for the database. This will become part of the URL.

Click Publish to Access Services.

Access publishes the database to the server. If all goes well, Access displays a success message which contains a link to the new Web database.

Top of Page