在MS Access 2007中创建视图 [英] Create View in MS Access 2007

问题描述

我在MsAccess 2007中有一个数据库，其中有5个表

I have database in MsAccess 2007 having 5 Tables inside them

我想在MS Access中创建视图

I want to create View in MS Accesss

我不需要语法，但是我需要创建视图的步骤(因为我无法在MS Acccess中找到CreateView

I dont need Syntax, but i need Step to create View (because i cant find CreateView in MS Acccess

推荐答案

您无法在MS Access 2007中创建视图，不支持该视图.但是，您可以创建查询以返回所需的数据.

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.

请参见用于创建视图语句的MSDN

.

Microsoft Access数据库引擎不支持使用 使用非Microsoft Access创建视图或任何DDL语句 数据库引擎数据库.

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.

但是创建SELECT查询与View相同，因为您可以检索数据并由其他查询使用.

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

例如，如果您创建一个名为GetQuery1的查询，该查询将执行以下操作:

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

这篇关于在MS Access 2007中创建视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！