MS Access
Microsoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. In mid-May 2010, the current version of Microsoft Access 2010 was released by Microsoft in Office 2010; Microsoft Office Access 2007 was the prior version.
Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases.
Software developers and data architects can use Microsoft Access to develop application software, and "power users" can use it to build simple applications. 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.
Versions
| Version | Year | Release Name | JET Version | Notes |
|---|---|---|---|---|
| 14 | 2010 | Access 2010 | 14 | - |
| 12 | 2007 | Access 2007 | 12 | - |
| 11 | 2003 | Access 2003 | 4.0 SP1 | - |
| 10 | 2001 | Access 2002 | 4.0 SP1 | - |
| 9 | 1999 | Access 2000 | 4.0 SP1 | Not backwardly compatible with previous versions. |
| 8 | 1997 | Access 97 | 3.5 | Patch required to work on computers with more than 1GB |
| 7 | 1995 | Access for Windows 95 | 3.0 | Will not work with computers with more than 1GB |
| 2 | 1993 | Access 2.0 | 2.0 | - |
| 1 | 1992 | Access 1.1 | 1.0 | Code name Cirrus although partly based on previous project Omega |
Sources
Wikipedia contributors. "Microsoft Access." Wikipedia, The Free Encyclopedia. Wikipedia, The Free Encyclopedia, 16 Aug. 2011. Web. 12 Sep. 2011.