With the Expression Builder, you can simply select the object you want from a list, and the Expression Builder writes the reference for you with all the operators in the correct places. To display the Expression Builder, right-click where you want to enter the expression, and then click Build on the shortcut menu. Providing Navigation to Tasks and Objects As an application developer, you determine how people navigate through your applications and complete their tasks. Navigating in a Microsoft Access application usually means moving from control to control within a form or switching between forms. Navigation within a form Within a form, navigation from control to control should follow the natural flow of the task your users shouldn't have to bounce from the top of the form to the bottom and then back to the top again in order to complete one task.
Group controls logically so that users can focus on one area of the form at a time.
Define how a user moves from control to control on a form with the keyboard by setting the AutoTab , TabStop , and TabIndex properties. If controls are used to find or filter records, place them in the form header or footer to show they're separate from the other fields in the current record. It's also a good idea to be consistent within your application to do similar tasks on different forms in similar ways. Command buttons have the advantage of being highly visible. For most common actions, you can create buttons on your forms by using the Command Button Wizard, which creates an event procedure for you.