Encyclopedia > Microsoft Access

  Article Content

Microsoft Access

Microsoft Access is a database management system from Microsoft, packaged with Office which combines the "Jet" relational database engine with a graphical interface intended to make it possible for relatively unskilled programmers and non-programmer "power users" to build sophisticated "front-ends" to complex databases.

One of the major benefits of Access from a programmer perspective is its relative compatibility with SQL--queries may be viewed and edited as SQL statements. Otherwise, it uses VBA for programming forms and logic. The report writer in Access is similar to the other popular database report writer - Crystal Reports[?] but the two products are vastly different in their approach.

Access is commonly used by small businesses and hobby programmers to create customised systems for handling small tasks. Its cut and paste functionality can also make it a useful tool for connecting between other databases (eg Oracle and SQL Server) during data or database conversions.

Unlike complete RDBMSs it lacks Triggers and Stored Procedures.

See: Microsoft Office

Microsoft Access was also the name of a communications program from Microsoft, meant to compete with ProComm[?] and other programs. It proved a failure and was dropped. Years later they reused the name for their database.


Part of this article was originally based on material from FOLDOC, used with permission. Update as needed.

All Wikipedia text is available under the terms of the GNU Free Documentation License

  Search Encyclopedia

Search over one million articles, find something about almost anything!
  Featured Article
East Islip, New York

... The median age is 37 years. For every 100 females there are 95.2 males. For every 100 females age 18 and over, there are 90.1 males. The median income for a household ...

This page was created in 31.8 ms