Menu
I have database in MsAccess 2007 having 5 Tables inside them
I want to create View in MS Accesss
I dont need Syntax, but i need Step to create View (because i cant find CreateView in MS Acccess
318
Each view in an Access web app must be unique. Click View Type and select Summary. If you want to use a different data source for the view, click Record Source and select the table or query you want to use. Click the Add New View button to create the summary view.
The four main objects of MS Access are tables, queries, forms, and reports.
A view is a way of looking at an Access object. Forms have three views: Form view, Layout view, and Design view. You can enter, edit, and view data in Form view.
The syntax for the CREATE VIEW statement in SQL is: CREATE VIEW view_name AS SELECT columns FROM tables [WHERE conditions]; view_name. The name of the SQL VIEW that you wish to create.
You cannot create a view in MS Access 2007, it is not supported. However, you can create a query to return the data that you need.
See MSDN for Create View Statement.
The Microsoft Access database engine does not support the use of CREATE VIEW, or any of the DDL statements, with non-Microsoft Access database engine databases.
But creating a SELECT query is the same as a View in that you can retrieve data and use it by other queries.
For example, if you create a query called GetQuery1 which performs the following:
SELECT *
FROM table1
If you want to use this like a view, you can call this directly from another query:
SELECT *
FROM GetQuery1
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
