Work with data in Page view

Microsoft Office Access 2003

ShowAdd, edit, and delete data

ShowAdd a record

  1. On the record navigation toolbar, click New Button image.

    Note  If you don't see the New button, it means one of the following:

    • The page does not support data entry.
    • The designer of the page has customized the button. Look for custom instructions on how to use the page, or contact the designer.
  2. Type the data you want in the first field, and then press TAB to go to the next field.
  3. When you are finished adding data to each field, save the record.

Note  If you make a typing mistake, press BACKSPACE. To cancel your changes in the current field, press ESC. To cancel your changes to the entire record, click Undo Button image on the record navigation toolbar.

ShowEdit the data in a field

  1. Click in the field you want to edit.

    Note  You cannot edit group fields and calculated fields. If you can't insert the input cursor inside any of the fields in the page, the page does not support edits.

  2. Type the text you want to insert.
  3. Save the record.

Note  If you make a typing mistake, press BACKSPACE. To cancel your changes in the current field, press ESC. To cancel your changes to the entire record, click Undo Button image on the record navigation toolbar.

ShowDelete a record

Important  Once you delete a record, you cannot undo the deletion from the database.

  • On the record navigation toolbar, click Delete Button image.

Note  If you don't see the Delete button, it means one of the following:

  • The page does not support deletions.
  • The designer of the page has customized the button. Look for custom instructions on how to use the page, or contact the designer.

ShowAdd, change, or delete the path to a picture

Note  The picture is not stored in the database. Rather, the path to the picture's location is stored in the database, and the picture is stored in a computer's file system.

  1. Click inside the path field.
  2. Do one of the following:
    • To add the path to the picture, type the path of the picture's location.
    • To change the path to the picture, edit the path.

    • To delete the path to the picture, select the contents of the field and press DELETE.

Notes

  • You cannot edit a field on a page unless the page supports edits.
  • The path can be a relative path, a path on your computer, a universal naming convention (UNC) path, or a uniform resource locator (URL). The type of path you should use depends on the requirements of the database.

  • If you want to delete the picture file, you must do so from its location in your computer's file system. See Microsoft Windows Help for more information about deleting files.

ShowSave or undo changes

ShowSave a record

  • On the record navigation toolbar, click Save Button image.

Note  If you don't see the Save button or if it appears disabled, it means one of the following:

  • The designer of the page has customized the button. Look for custom instructions on the page on how to save your changes.
  • The page is read-only and does not support additions or edits.

ShowUndo changes when adding or editing records

  • Click Undo Button image on the record navigation toolbar.

Note  If you don't see the Undo button or if it appears disabled, it means one of the following:

  • The designer of the page has customized the button. Look for custom instructions on the page on how to undo your changes.
  • The page is read-only and does not support additions or edits.

ShowNavigate between fields and records

ShowSelect fields and records

The following table lists mouse techniques for selecting data or records in Page view.

To select Click
Data in a field Where you want to start selecting and drag across the data
An entire field Three times within the field
A record A field that belongs to the record

The following table lists keyboard techniques for selecting data or records in Page view.

To select Do this
Data in a field Move the insertion point to the start of the text you want to select, and then hold down SHIFT and press the arrow keys to move to the end of the selection.
An entire field Move the insertion point to anywhere in the field, press HOME, and then press SHIFT+END.
A record Press TAB until a field that belongs to the record gets focus.

Note  Your data access page might have a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component, which have their own methods of selection. To display Help for one of these components, click Help Button image on its toolbar.

ShowMove between records by using navigation buttons

  • Use the navigation buttons located on the record navigation toolbar to quickly move between records or a group of records on a grouped data access page.

    Record navigation buttons

Callout 1 First record

Callout 2 Previous record

Callout 3 Record source and number

Callout 4 Next record

Callout 5 Last record

Note  If you don't see the record navigation toolbar on your page, it means one of the following:

  • All the records are displayed on the page, so the navigation buttons are not necessary.
  • The designer of the page has customized the toolbar. Look for custom instructions on how to use the page, or contact the designer.

ShowSort, find, and filter data

ShowSort data

You can sort data on a data access page, including data that's grouped. For grouped data access pages, you can sort the list of groups or the records within a group.

  1. Open a data access page in Page view.
  2. Do one of the following:
    • In an ungrouped page, click the field you want to use for sorting records.
    • In a grouped page, expand the group that you want to sort, and then click the field you want to sort records on.

      Note  When you sort records within a group, the sort order applies only to that group. It does not affect the order of records in other groups.

  3. Do one of the following:
    • To sort in ascending order, click Sort Ascending Button image.
    • To sort in descending order, click Sort Descending Button image.

ShowTip

If the records are displayed in tabular format, simply click the label of the field you want to sort records on. The records will display in ascending order. To sort records in descending order, click the label again.

Notes

  • When you close the data access page, you'll lose the sort order. You can sort the records again when you open the page.
  • The order in which numbers, text, and special characters are sorted depends on the database and your regional settings in Microsoft Windows Control Panel.
  • This procedure doesn't apply to a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component. These features can be sorted independently from the rest of the data on the data access page, and may also support additional sorting capabilities. For more information, click Help Button image on the toolbar for the PivotTable list, spreadsheet, or chart, and then search for "sorting."

ShowFind specific data by using a filter

  1. Open the data access page in Page view.
  2. If the records are grouped on the page, expand the group that you want to filter.
  3. Move focus to the field that has the value that you want to use to filter records.
  4. Click Filter By Selection Button image on the record navigation toolbar for that group.

Note  On a grouped page, the filter applies only to the current group. In other words, if a page groups customer orders by country/region, and you filter the records for Brazil that have a required date of 6/2/98, that filter applies only to the records for Brazil, not to the records for the other countries/regions.

ShowApply an existing filter to data

You can reapply a filter that you created during the current working session.

  1. Open a data access page in Page view.
  2. Do one of the following:

    • On an ungrouped page, click Filter Toggle Button image on the record navigation toolbar so that it is selected.
    • On a grouped page, expand the group that you want to filter, and then click Filter Toggle on the record navigation toolbar for that group so that the button is selected.

Note  This procedure doesn't apply to a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component. These features can be filtered independently from the rest of the data on the data access page, and may also support additional filtering capabilities. For more information, click Help Button image on that component's toolbar.

ShowRemove a filter to show all records

  1. Open a data access page in Page view.
  2. Click Filter Toggle Button image on the record navigation toolbar so that it is not selected.

Notes

  • Removing a filter doesn't delete it. You can reapply a filter during the current working session by clicking the Filter Toggle button on the record navigation toolbar so that it is selected.
  • This procedure doesn't apply to a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component. These features can be filtered independently from the rest of the data on the data access page, and may also support additional filtering capabilities. For more information, click Help Button image on that component's toolbar.

ShowUse keyboard shortcuts

Note  To use the following keys, press the TAB key repeatedly until the expand indicator or record navigation toolbar has the focus. If a PivotTable list or spreadsheet control currently has the focus, press CTRL+TAB.

SPACE or ENTER
Expand or collapse a group of records corresponding to the expand indicator in a grouped data access page
TAB or SHIFT+TAB
Select a button on the record navigation toolbar
SPACE or ENTER
Activate the selected button on the record navigation toolbar