By Tricia Goss
Overview
Microsoft Access is part of the Microsoft Office Suite. Access allows users to create relational databases quickly and easily, by utilizing the familiar Microsoft Office interface and toolbars. Users can get organized at home using Access templates, while the advanced office user can create intricate databases using VBA and SQL.
History
The first version of Access was released by Microsoft in 1992. A few years later, Access was shipped as part of the MS Office 1995 suite. Access is currently available as a stand-alone application or as part of Microsoft Office Professional 2007 or Microsoft Office Ultimate 2007.
Function
Microsoft Access databases are made up of one or more relational tables. This means that each table is created based upon a particular relationship shared by the data in that table. For example, a doctor's office may have a database with a patient table, an employee table, a medical supply table and so on.
Features
Microsoft offers many free templates for Access, making it even easier to create database tables, forms, reports and queries. Access also features a free example database that can be practiced in, manipulated and changed for learning purposes.
Benefits
Access offers wizards that simplify the process of designing database objects such as forms. These forms then make it easier for users to enter data into a table.
Misconceptions
There is a common misconception that Access databases can only be created by developers with VBA and SQL experience. However, by using templates, wizards and other tools and features, anyone can create and make use of an Access database.
Microsoft Access Description by electronicsworks.net