Alison Balter's Mastering Access 2002 Enterprise Development

Creating a Simple View

A view is actually a SELECT statement with a CREATE VIEW statement that causes SQL Server to save it as a view. You can use several different methods to create a SQL Server view:

• You can use the Create View Wizard to create a view.

• You can use the Enterprise Manager Query Builder to create a view.

• You can create a view from within an Access Project.

• You can use the Query Analyzer to create a view.

• You can use T-SQL to create a view.

The sections that follow cover each of these options.

Using the Create View Wizard to Create a View

The Create View Wizard facilitates the process of creating a view. To create a view with the Create View Wizard:

1.	Select Tools, Wizards from within the Enterprise Manager. The Select Wizard dialog ...