利用表單篩選搜尋

  1. 開啟包含資料庫欄位的表單文件。

    As an example, open an empty text document and press + Shift + F4 keys. Open the bibliography database table biblio in the data source view. While pressing Shift+, drag a few column headers into the document so that the form fields are created.

  2. On the Form Controls toolbar, click the Design Mode On/Off iconIcon to turn off the design mode.

  3. On the Form Navigation toolbar, click the Form-Based Filters iconIcon. The current document is displayed with its form controls as an empty edit mask. The Form Filter toolbar appears.

  4. 在一個或數個欄位中輸入篩選條件。注意,如果您在數個欄位中輸入篩選條件,則所有輸入的條件都必須符合(布林 AND)。

有關萬用字元和運算子的更多資訊,可在查詢設計中找到。

如果您按一下 [表單篩選] 工具列上的套用以表單為基礎的篩選圖示,則將會套用篩選。 您會看到 [表單瀏覽] 工具列,並可瀏覽找到的記錄。

如果您在 [表單篩選] 工具列上的 [關閉] 按鈕上按一下,則表單會不使用篩選而直接顯示。

Click the Apply Filter iconIcon on the Form Navigation toolbar to change to the filtered view.

The filter that has been set can be removed by clicking Reset Filter/Sort iconIcon.

使用篩選助手

搜尋表格文件和表單文件