Create a view in MS Access 2007

Question

I have a database in MsAccess 2007 with 5 tables inside them

I want to create a View in MS Access

I do not need syntax, but I need to take a step to create a View (because I can not find CreateView in MS Acccess

Answer 1

You cannot create a view in MS Access 2007, it is not supported. However, you can create a query to return the data you need.

See MSDN for a submission statement .

The Microsoft Access database engine does not support the use of CREATE VIEW or any of the DDL statements using a non-Microsoft Access database.

But creating a SELECT query is the same as a View query, in which you can retrieve data and use it for other queries.

For example, if you create a query called GetQuery1 , which performs the following actions:

 SELECT * FROM table1 

If you want to use this as a view, you can call it directly from another request:

 SELECT * FROM GetQuery1 

Answer 2

MS Access allows you to create a query that can be used in other queries. So it looks like a performance

Answer 3

 CREATE VIEW view [(field1[, field2[, …]])] AS selectstatement 

https://msdn.microsoft.com/en-us/library/bb177895(v=office.12).aspx