MICROSOFT OFFICE ACCESS

Microsoft Access (or Microsoft Office Access) is a computer program relational database application that is intended for home and small-medium companies. This application is a member of several Microsoft Office applications, in addition to Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. This application uses the Microsoft Jet Database Engine database engine, and also uses an intuitive graphical interface making it easier for the user. The latest version is Microsoft Office Access 2007 is included in Microsoft Office System 2007.

Microsoft Access dapat menggunakan data yang disimpan di dalam format Microsoft Access, Microsoft Jet Database Engine, Microsoft SQL Server, Oracle Database, atau semua kontainer basis data yang mendukung standar ODBC. Para pengguna/programmer yang mahir dapat menggunakannya untuk mengembangkan perangkat lunak aplikasi yang kompleks, sementara para programmer yang kurang mahir dapat menggunakannya untuk mengembangkan perangkat lunak aplikasi yang sederhana. Access juga mendukung teknik-teknik pemrograman berorientasi objek, tetapi tidak dapat digolongkan ke dalam perangkat bantu pemrograman berorientasi objek.

History
Microsoft released Microsoft Access 1.0 in November 1992 and continued with the release of version 2.0 in 1993. Microsoft specified the minimum to run Microsoft Access 2.0 is a computer with Microsoft Windows 3.0 operating system, with a capacity of 4 megabytes of RAM (6 MB recommended) and hard disk space required 8 megabytes (14 MB recommended). Version 2.0 of Microsoft Access comes with seven 3 ½-inch floppy diskette 01:44 megabyte size.

The software works very well on a data base with many notes, but there are some cases where data was damaged. For example, the database size exceeds 700 megabytes often have problems like this (at that time, the hard disk is still below 700 megabytes). Started manual warns that some cases due to the obsolete device drivers or incorrect configurations.

Code name (codename), which was first used by Access is a Cirrus that was developed before Microsoft developed Microsoft Visual Basic, the forms engine that uses an interface called Ruby. Bill Gates saw the prototypes (prototype) and decided that the BASIC programming language component should be developed together as a separate application but can be expanded. This project is called Thunder. Both projects were developed separately, and the forms engine that is used by both are not compatible with each other. This ended when Microsoft released Visual Basic for Applications (VBA).

Employing
Microsoft Access is used mostly by small and medium-sized businesses, in a smaller organization may also be used by large companies, and also a programmer to make a homemade system for dealing with the manufacture and manipulation of data. Access can also be used as a database for basic Web applications that are stored on the server that is running Microsoft Internet Information Services (IIS) and using Microsoft Active Server Pages (ASP). However, the use of Access is less advisable, given the existing Microsoft SQL Server that has a higher ability.

Some professional application developers use Microsoft Access to develop applications quickly (used as Rapid Application Development / RAD tool), especially for the manufacture of prototypes to a bigger program and a stand-alone applications for the seller.

Microsoft Access is not so good if accessed through a network so that the applications used by many users tend to use the solution database management system client / server. However, the display face of Access (forms, reports, queries, and Visual Basic code) that can be used to handle the actual database being processed by other data base management systems, such as Microsoft Jet Database Engine (which by default used by Microsoft Access), Microsoft SQL Server, Oracle, and several other products that support ODBC.