【译文】Microsoft Access介绍之六：产品特点

时　间:2012-09-11 09:39:51
作　者:周芳 译   ID：24526  城市：上海
摘　要:用户可以创建表、查询、窗体和报告,并通过宏将它们连接在一起。高级用户可以使用VBA编写丰富的解决方案与高级的数据操作和用户控件。ACCESS也有报告创建特性,可以处理任何数据.源，也就是ACCESS可以访问数据源。
正　文:

原作者：未知      翻译：周芳

【译文】

    用户可以创建表、查询、窗体和报告,并通过宏将它们连接在一起。高级用户可以使用VBA编写丰富的解决方案与高级的数据操作和用户控件。ACCESS也有报告创建特性,可以处理任何数据.源，也就是ACCESS可以访问数据源。

    ACCESS最初的概念是可以让最终用户能够“访问”来自任何来源的数据。其他功能包括:导入和导出数据到包括Excel,Outlook,ASCII,dBase, Paradox, FoxPro,SQL Server, oracle,ODBC等等许多的格式。它也能够链接到数据在其现有的位置和用它来浏览、查询、编辑和报道。这允许现有的数据更新同时确保访问使用最新的数据。它可以执行异构数据集之间的连接存储在不同的平台上。ACCESS常常被人们从企业级数本地据库下载数据进行操作、分析和报告。

    还有Jet 数据库格式(MDB或ACCESS 2007中的ACCDB),可以将应用程序和数包含在一个文件中。这使得它非常方便的将整个应用程序发送给另一个用户,使得他可以在断开连接的环境中运行它。

    ACCESS的一个好处是可以从程序员的角度是其相对兼容SQL(结构化查询语言)-查询可以以图形方式查看或编辑作为SQL语句和SQL语句可以直接使用在宏和VBA模块来操纵访问表。用户可以混合和同时使用VBA和“宏”编程形式和逻辑并提供面向对象的可能性。VBA也可以包含在查询。

    Microsoft Access提供了参数化查询。 这些查询和存取表可以从其他程序引用像VB6和 .NET。通过Microsoft Access里面ADO或者DAO,VBA可以通过ADO引用参数化存储过程。

    桌面版本的Microsoft SQL Server可以于ACCESS一起使用从而替代Jet数据库引擎。这种支架是从MSDE开始(Microsoft SQL Server桌面引擎),缩小版的微软SQL Server 2000和SQL Server 2005和2008软件需求。

    Microsoft Access是一个基于服务器的数据库文件。不同于客户端-服务器关系数据库管理系统(RDBMS),Microsoft Access没有实现数据库触发器、存储过程或事务日志这些功能。ACCESS 2010包括表级触发器和存储过程构建到ACE数据引擎。因此一个客户机-服务器数据库系统并不是一个要求ACCESS 2010 使用存储过程或表触发器。表、查询、窗体、报表和宏现在可以在ACCESS 2010开发的专为web基本应用程序。集成了微软SharePoint 2010之后也得到了很大的提高。

【原文】Features

Users can create tables, queries, forms and reports, and connect them together with macros. Advanced users can use VBA to write rich solutions with advanced data manipulation and user control. Access also has report creation features that can work with any data source that Access can "access".

The original concept of Access was for end users to be able to "access" data from any source. Other features include: the import and export of data to many formats including Excel, Outlook, ASCII, dBase, Paradox, FoxPro, SQL Server, oracle, ODBC, etc. It also has the ability to link to data in its existing location and use it for viewing, querying, editing, and reporting. This allows the existing data to change while ensuring that Access uses the latest data. It can perform heterogeneous joins between data sets stored across different platforms. Access is often used by people downloading data from enterprise level databases for manipulation, analysis, and reporting locally.

There is also the Database format (MDB or ACCDB in Access 2007) which can contain the application and data in one file. This makes it very convenient to distribute the entire application to another user, who can run it in disconnected environments.

One of the benefits of Access from a programmer's perspective is its relative compatibility with SQL (structured query language) — queries can be viewed graphically or edited as SQL statements, and SQL statements can be used directly in Macros and VBA Modules to manipulate Access tables. Users can mix and use both VBA and "Macros" for programming forms and logic and offers object-oriented possibilities. VBA can also be included in queries.

Microsoft Access offers parameterized queries. These queries and Access tables can be referenced from other programs like VB6 and .NET through DAO or ADO. From Microsoft Access, VBA can reference parameterized stored procedures via ADO.

The desktop editions of Microsoft SQL Server can be used with Access as an alternative to the Jet Database Engine. This support started with MSDE (Microsoft SQL Server

Desktop Engine), a scaled down version of Microsoft SQL Server 2000, and continues with the SQL Server Express versions of SQL Server 2005 and 2008.

Microsoft Access is a file server-based database. Unlike client–server relational database management systems (RDBMS), Microsoft Access does not implement database triggers, stored procedures, or transaction logging. Access 2010 includes table-level triggers and stored procedures built into the ACE data engine. Thus a Client-server database system is not a requirement for using stored procedures or table triggers with Access 2010. Tables, queries, Forms, reports and Macros can now be developed specifically for web base application in Access 2010. Integration with Microsoft SharePoint 2010 is also highly improved.