是否可以在Access 2010中创建视图? [英] Is it possible to create a view in Access 2010?

问题描述

如标题所述-可以完成吗?我在MSDN页面上看到不支持此功能，但是我对如何分配的要求.可以而且怎么做?

As the title states - can it be done? I read on a MSDN page that this is not supported, but my assignment request for how. Can, and how can, it be done?

推荐答案

视图仅是保存的SQL SELECT语句.这就是在Access中保存的查询的内容(尽管您当然也可以保存DML SQL语句).

A view is nothing more than a saved SQL SELECT statement. This is what a saved query in Access is (though you can save DML SQL statements, too, of course).

在交互式Access中，使用查询设计器创建任何SELECT语句，将其保存并创建视图.

In interactive Access, use the query designer to create any SELECT statement, save it, and you've created a view.

如果要在代码中进行操作，则可以很容易地使用DDL SQL或DAO为其找到代码.

If you want to do it in code, it's pretty easy to find the code for it, using either DDL SQL or DAO.

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