Microsoft Office Access 2007 is what ah

is Microsoft Office Office of Access, In addition, Office includes Word, PowerPoint, and so on, the previous version is Office2000 Later, 2003, 2007, is now a database, Microsoft Office is a usually used WORD, EXCEL is also a Microsoft Office Microsoft Office Access (formerly known as Microsoft Access) is published by Microsoft relational database management system.It The combination of Microsoft Jet Database Engine and the graphical user interface of the two features of Microsoft Office is a member of.
Access Access to Access / Jet, Microsoft SQL Server, Oracle (Oracle's software), or any ODBC-compliant database .Skilled software designers and data analysts to use it to develop application software, and the number of unskilled programmers and non-programmers of “advanced users” can use it to develop a simple software application.Although it support Part of the object-oriented (OO) technology, but not a complete object-oriented development.
Access is a Microsoft Windows-based desktop relational database management system (RDBMS), is the Office family of applications One.It provides tables, queries, forms, reports, pages, macros, modules 7 used to create the target database system; provides a wide range of guides, generators, templates, data storage, data query, interface design, Statements such as the generation of standardized operation; function for the establishment of a sound database management system provides a convenient, but also allows ordinary users do not have to write code that can be completed most of the data management task.
Microsoft Access in many parts of the widely used, such as small Enterprises and large companies, like programming and the development of specialized personnel to use it to create desktop data processing system.It is also used to develop a simple WEB application.These applications take advantage of ASP technology in the running Internet Information Services.WEB more complicated applications using PHP / MySQL, or ASP / Microsoft SQL Server.
it's easy to use and powerful tool designed to provide programmers for the primary function of many.However, this easy-to-use may be misleading.this type of development are not in the application of the data or the design of training employees in the office .Many people think that such a development can be used to create the system, but there are a lot of tools that have their own limitations such misleading.
A number of professional application developers use Access as a rapid application development, in particular, Is to the streets of the salesmen at the beginning of a production or an independent application.But if it is through a data network access, Access's Scalability was not high.Therefore, when the procedure was more users, they would be more inclined to choose some of the 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, and the sequence of VB code) can be used for other database applications at a later stage, including the JET (file-based database engine, Access using 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 does not have been in place at the expense of development.
Many developers Who use Microsoft Access to use Leszynski naming convention, although this is generally not the case; it is a program of the General Assembly, is not a DBMS implementation of the regulations.