How to Add an Access Form Filter to a Web Page

Microsoft Access 2010 has a new feature called Publish to Access Services. This feature lets you publish an Access web database to a SharePoint website. Users can then add information to your database by using the forms. The forms have filters built into the column headers that can be used to refine the results obtained by the Access web database.

Instructions

1. Open Access 2010 and locate the web database. Click the "File" tab and select the "New" icon. Type "Web" in the search window. Access displays a list of web databases that are available for download. Click one and see the preview of the database in the right task pane. Click the "Download" button to download the database.

2. Publish the web database to the SharePoint site by clicking the "File" tab and selecting "Save & Publish." Select "Publish to Access Services." Type the name of your SharePoint server in the "Server URL" field. Click "Publish to Access Services."

3. Click the tab for one of the forms in your web database. Click the column header's drop-down arrow. Review the filtering options available for your web database.

References

• Microsoft: Publish A Database To A SharePoint Site

Resources

• Microsoft: Access How To & Help