Create a View

1. In the Database window, click Queries   under Objects, and then click New.
2. In the New Query dialog box, select Design View.
3. Design the view in the Diagram and Grid panes of the Query Designer.
4. Click Save on the toolbar.
5. In the Save As dialog box, enter a name that follows Microsoft Access object-naming rules.

   Microsoft Access adds the view to Queries under Objects in the Database window.