Understanding Access Projects 1. 2. 3. 4. 5. 6. 1. 2. 3. 4. 5. 6. 535 In the Database window, click Queries in the Objects list, and then Double-click Create View In Designer. In the Add Table dialog box, select the tables you want to include in the view, click Add, and then click Close. In the field lists for the tables, select the fields you want to include in the view. In the Sort Type column, select Ascending or Descending to sort the records by this field. Use the Sort Order column to change the order in which fields will be used to sortrecords. On the toolbar, click the Save button, enter a name for the view, and then click OK. On the toolbar, click the Run button to see the records the view returns. In the Database window, click Queries in the Objects list, and then Double-click Create Stored Procedure In Designer. In the Add Table dialog box, select the tables or views you want to include in the stored procedure. In the field lists, select the check boxes for the fields you want to include in the stored procedure. Enter any criteria for the stored procedure in the Criteria column. On the toolbar, click the Save button and then enter a name for the stored procedure. On the toolbar, click the View button to see the records the stored procedure returns. Create a stored procedure For more information: · SQL Server 2000 Books Online provides extensive documentation about Microsoft SQL Server. You can download SQL Server 2000 Books Online from the Web site http://www.microsoft.com/SQL/techinfo/pro- ductdoc/2000/books.asp. You can also learn more about SQL Server in the books Inside Microsoft SQL Server 2000 by Kalen Delaney (Microsoft Press, 2000) and Microsoft SQL Server Programming Step by Step by Rebecca Riordan (Microsoft Press, 2000).