About Microsoft Access 2003
Microsoft Access 2003 is a database management system (DBMS) that is a component of the Microsoft Office 2003 Professional software suite. Access is suitable for casual users but also provides advanced features such as programmability using Visual Basic, and integration with enterprise databases including Oracle and SQL Server.
-
Database Applications
-
Users can create database elements such as tables, forms, queries and reports with Microsoft Access using a menu driven point-and-click interface. Several customizable database templates are included, enabling casual users to create relational database solutions without formal programming knowledge.
Programmability
-
Access supports programming languages such as Visual Basic and Structured Query Language (SQL), which allow power users and developers to create custom solutions. Access database tables and queries are compatible with web applications written in ASP.NET, PHP and JAVA.
-
Extensibility
-
Access databases can exchange information with many data formats including Excel, dBASE, FoxPro, SQL Server and Oracle. Database applications can be compiled to create stand alone programs that can be distributed to users who do not own the software using runtime files. The program's features scale appropriately for use by casual users, power users, corporate users and developers.
-
References
- "Access 2003 for Dummies;" Alan Simpson; 2003