While Access does provide standard shortcut menus for your form controls, you can provide users with customized menus that are tailored to their needs. For example, suppose you want users to be able to sort an Employees data form in ascending or descending order by the employees' last names. To create the shortcut menu, follow these steps:
To assign the Alpha Sort shortcut menu to the Last Name field, open the form in Design view, right-click the field, and select properties. Under the Other tab, click in the Shortcut menu bar box and select Alpha Sort from the drop-down list.
Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.