求达人用英文翻译一篇关于Access的文章

Question

特性
一好处进入从程序员视角在它的有关兼容性有SQL-质问可能被观看并且作为SQL语句编辑，并且SQL语句直接在巨视和VBA模里可以被使用操作进入桌子。用户可能混合并且使用两个VBA并且"宏"编程形式和逻辑既没提供面向对象的可能性。
导入导出报表的生成程序，当时有能力和到这项任务的复杂报告创造，没有另一受欢迎数据库报表程序的生成程序充满特色和强有力-水晶报告。MSDE(微软公司SQL服务器桌面发动机)2000，袖珍版本的MSSQL服务器2000，被包括开发版的办公室XP并且被用于进入可能作为除之外的另一种选择JET数据库引擎。(尽快的*版本的MSDE和微软公司交换服务器实际上使用这台喷气发动机处理巨大大量数据并且安置一“赝品”在它之上的那些应用的应用层。大约这事实的缺乏知识因进入/喷口家庭的软件产品而为不该受不敬做贡献，特别是关于"大"工程。)
进入分割和粘贴功能性能使它有用工具在其他数据库之间连结(例如，在数据或者数据库变换期间的Oracle和微软公司SQL服务器)。进入与给与窗子和其他平台应用一起的积分的各种各样进口和退场门特征一起来，一经请求从应用的里面或者手工由用户其中几可以被执行。例如非常紧密SNP完全格式化的为分享的形式与没有全部的进入软件的人们报告。它也能容易被升级到微软公司SQL服务器。
与一般的RDBMS完全不同，它缺乏数据库触发和预存程序。自从MS Access 2000 (Jet 4.0)，开发人员可以在查询中设定参数，这跟预存程序很相似的，但这些“预存程序”只能处理一个程序．当资料表内数据发生变化时，它确实允许形式包含被引发的代码，使用是普通的透过查询和其他技术在进入营运储存的程序在方面RDBMS支援这些的。
发展
进入可提供的编程语言，当时在另一个内产品Microsoft Office家具，微软公司应用的Visual Basic。两个数据库进入讯息库COM组成部分被提供：这笔遗产数据存取物体(DAO)，用进入和新只可提供ActiveX数据对象(忙乱)。
MicrosoftAccess容易被应用于小的工程但是规模无效对大的工程如果应用被不好设计。
全部数据库质问，形式和报告被储存在数据库里，并且与相关的模型的理想协调，没有与他们做一个身体上组织的阶层的可能性。
一种设计技术是把进入应用在数据和计划之间进行分发。一数据库应该只包含桌子和关系，当另一个将有全部计划时，形式，报告和质问和对第一个数据库桌子的连接。令人遗憾，当连结时，进入允许没有有关的道路，因此那些发展环境作为这种生产环境有相同的道路应该(虽然你写你们自己的能"动态连接程序"常规在里VBA那搜出能一定背面结束档案以透过这个目录树搜寻，如果它发现这条电流通路它不能)。
这种技术也允许开发者在不同的档案中分申请，因此一些架构是可能的。

Answer 1

Microsoft Office Access (formerly known as Microsoft Access) is released by Microsoft relational database management system. It combines the Microsoft Jet Database Engine, and two graphical user interface features, is a member of Microsoft Office.

Access can access Access / Jet, Microsoft SQL Server, Oracle (Oracle Corporation), or any ODBC-compliant database information. Skilled software designers and data analysts use it to develop application software, and some unskilled programmers and non-programmers "Advanced users" can use it to develop simple applications. Although it supports some object-oriented (OO) technology, but failed to become a complete object-oriented development tools.

In fact, Microsoft Access is also another name of the communication process, like with ProComm and other similar procedures are in place to compete. However, Microsoft later confirmed that this is a failed program, and suspend it. A few years later they renamed the name of the database software.

Overview

Access is Microsoft's desktop Windows-based relational database management system (RDBMS), is one of application software Office series. It provides a table, query, forms, reports, pages, macros, modules, seven kinds of database system used to create the object; provides a wide range of guides, generators, templates, data storage, data query, interface design, report generation such as standardized operation; to establish a fully functional database management system provides a convenient and also allows ordinary users do not have to write code, you can finish most of this data management task.

Use

Microsoft Access is widely in use in many places, such as small businesses, departments of large companies and developers enjoy programming expertise to use it to produce desktop systems for data processing. It is also often used to develop a simple application of the WEB. These applications have made use of ASP technology in running Internet Information Services. WEB more complicated applications using PHP / MySQL or ASP / Microsoft SQL Server.

It's easy to use and powerful design tool for junior programmers to provide many of the features. However, this easy-to-use may be misleading. These developers are no data in the application or the design of training employees in the office. So many people think that this kind of developers to create usable systems, but there are also many people think that the limitations of their tools have had this kind of misleading.

Some professional application developers use Access for rapid application development, especially to the streets early to produce a salesman or an independent application tool. However, if access is through a data network, Access can be extended to the release was not high. When the procedure was therefore more users, they will be more inclined to choose a number of client - server-based programs, such as Oracle, DB2, Microsoft SQL Server, Windows SharePoint Services, PostgreSQL, MySQL, Alpha Five, MaxDB or Filemaker. In any case, many of the functions of Access (forms, reports, sequence and VB code) can be later used for other database applications, including JET (file-based database engine, Access to use the default), Microsoft SQL Server, Oracle and with any other ODBC-compliant products. This approach allows developers to a mature mobile data applications to a more powerful server and not have been in place at the expense of development.

Many developers who use Microsoft Access use Leszynski naming convention, although this is not universal; it is a program the General Assembly, not a DBMS implementation of the regulations.

Answer 2

I entered from the programmers perspective of the benefits of it are the compatibility of the SQL-query can be Views and editors, as SQL statements and SQL statements directly in the giant TV and VBA module could be used to operate into the table. Users may use two mixed and VBA and "macro" programming forms and logic to provide neither the possibility of object-oriented.

Import and export statements to generate procedures, then have the ability and the complexity of this task to create the report, there is no other popular database program to generate procedural statements full of features and strong - Crystal Report. MSDE (Microsoft SQL Server Desktop Engine) 2000, pocket-sized version of MSSQL Server 2000, by including the development version of Office XP and may be used as an addition to entering an alternative JET database engine. (As soon as possible, the * versions of MSDE and Microsoft Exchange Server to use this fact to deal with a huge jet engine placement of a large amount of data and "forgery" in which those applications on the application layer. About the fact that due to the lack of knowledge into the / vents family of software products for the contribution should not be done by the disrespect, especially with regard to the "big" project.)

Into the performance of partition-and-paste function to make it a useful tool in the link between other databases (for example, transform the data or during the Oracle database and Microsoft SQL server). And give access to the window and other platform with a wide range of integral characteristics of import and out the door together, upon the request of the inside from the application or manually by the user and several of them can be executed. For example, very close SNP to share fully formatted form and not all people who access the software report. It also can easily be upgraded to Microsoft SQL Server.

RDBMS in general is completely different from its lack of database triggers and stored procedures. Since MS Access 2000 (Jet 4.0), developers can set the parameters in the query, which is very similar to stored procedures, but these "stored procedure" can only handle one. When the data in table changes, it does allow the form that contains code to be triggered, through the use of common inquiries and other technologies into the operating program stored in the RDBMS to support these aspects.

Development

Provide access to the programming language, then in another Microsoft Office furniture products within Microsoft applications, Visual Basic. The two databases into the COM component of the message database is provided: the legacy Data Access Objects (DAO), with access to and can only provide the new ActiveX Data Objects (hectic).

MicrosoftAccess easily be applied to small-scale projects, however large the project is invalid if the application was not designed.

All database query, forms and reports are stored in the database, and with the ideal model of coordination, not with them to make a physical possibility of class organization.

A design technique is applied to the access to data and programs distribution between. A database should contain only the tables and relations, when the other will have all the plans, forms, reports and query the database and table on the first connection. Regrettably, when the link is not allowed to enter the road, so that environment for the development of the production environment as this road should be the same (although you can write your own "dynamic linker" routine in VBA where it can be found the back of the end of a certain file in order to search through the directory tree, if it is found that the current path it can not).

This technology also allows developers to separate files in different applications, some structure is possible.