Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.
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
Edit the items in a drop-down list
Publish the Issues Web Database to Access Services
Add a new issue
-
Click the Open Issues tab.
-
Click New Issue.
-
In the Issue Details form, fill in the information that you have.
-
If you want to add another contact, click Save & New, and repeat step 3. Otherwise, click Save & Close.
View and edit issues
-
Click the Open Issues tab.
-
In the Summary column of the datasheet, double-click the issue that you want to view or edit.
-
Edit the information as needed, and then click Save or Save & Close.
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:
-
Click the down-arrow to display the list.
If the list is editable, the Edit List Items button will appear just below the list. -
Click the Edit List Items button.
-
If the Edit List Items dialog box appears:
-
Type the list items you want, one on each line.
-
Optionally, select a default value from the Default Value list.
-
Click OK.
-
-
If a Details form appears:
-
Click the New (blank) record button at the bottom of the form.
-
Type the information in the form, and then click Save and Close.
-
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:
-
Double-click the Attachments field.
-
In the Attachments dialog box, click Add.
-
Browse to the file you want to attach, and then click Open.
-
In the Attachments dialog box, click OK.
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.
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:
-
Click the File tab, and then click Publish to Access Services.
-
In the Server URL box, type the URL of the SharePoint server that you want to use.
-
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.
