Microsoft Office Access, previously known as Microsoft Access, is a pseudo relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interfaceand software development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. The current version is Microsoft Office Access 2007; Microsoft Access 2010 is in beta as of May 10, 2010.

Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to datastored in other Access databases, Excel, SharePoint lists, text, XML, Outlook, HTML, dBase, Paradox, Lotus 1-2-3, or any ODBC-compliant data container, including Microsoft SQL Server, Oracle, MySQL, andPostgreSQL.[citation needed]Software developers and data architects can use it to develop application software, and "power users" can use it to build simple applications.[citation needed] Like other Office applications, Access is supported by Visual Basic for Applications, an object-oriented programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports expose their methods and properties in the VBA programming environment, and VBA code modules may declare and call Windows operating system functions.

copyfrom : wiki