What Is the Difference Between Microsoft Access & Database?
Microsoft Access is a personal database product. The visual design environment and query tools make it friendly for first-time database users. The Jet-SQL engine that drives the database makes it powerful enough to stand up to corporate-level information management needs.
Other People Are Reading
-
Visual Database
-
Access does not rely on programming or arcane commands to build, query and report from its databases. The visual interface enables users to design and build their own database tables. It provides enough clues and hand-holding to ensure that the structures will be at least minimally compliant with the requirements of a relational database.
Query Features
-
Querying an Access database is performed in two different ways. For the new or casual database user, the Query By Example (QBE) feature builds the query visually by dragging and dropping the fields you want to see then adding examples of the data you are looking for. For more advanced users, Access supports SQL queries.
-
Access Programming
-
Complete database applications are developed using Access databases and the built-in Visual Basic for Applications (VBA) language. Forms, reports and queries are all developed visually then linked together with VBA programming code. Many other programming languages, such as the Visual Studio Suite of languages, support links to the Access database structure. This enables you to develop complex applications while still relying on the simplicity of Access for database functions.
-
