Microsoft Access - An Overview

WHAT IS ACCESS? 3

A BRIEF HISTORY OF ACCESS 4

ACCESS 1.X / ACCESS 2.0 4

ACCESS 95 / ACCESS 97 4

HARDWARE REQUIREMENTS 6

RAPID APPLICATION DEVELOPMENT 7

THE EVENT DRIVEN MODEL 7

VBA IN ACCESS 95 / 97 8

THE JET DATABASE ENGINE 10

WHERE IS ACCESS TYPICALLY USED? 11

ACCESS IN CORPORATE BUSINESSES 11

ACCESS IN SMALL BUSINESSES 13

ACCESS AT HOME 13

FEATURES OF ACCESS 97 15

INTEGRATING ACCESS WITH OTHER APPLICATIONS 17

MICROSOFT OFFICE 17

ACCESS AND VISUAL BASIC TOGETHER 18

CONCLUSION 20

GLOSSARY 20

ENDNOTES 23

BIBLIOGRAPHY 28

What is Access?

Executive Summary

Microsoft Access 97 for the Windows 95 and Windows NT operating systems provides relational database power for your programs. Its visual design and event driven nature make Access a powerful and easy tool to learn. Access is quick and easy to use which makes it a popular tool with home users.

Windows opstartscherm in etalage computerwinkel.

Microsoft Office Access 2007

Microsoft Access

Small business owners benefit greatly from Access because they can develop their own database applications and eliminate the cost of third party developers.

Microsoft Access 97 makes it easy to turn data into answers and includes tools that help even first time users get up and running quickly. For example, the Database Wizard can automatically build custom databases in minutes. The Table Analyzer Wizard quickly transforms linear lists or spreadsheets into powerful relational databases.

Access 97 offers greatly enhanced 32-bit performance with smaller forms, more efficient compilation, and better data manipulation technology for quicker queries and responses. Other features further improve execution time and help you build fast business solutions. The Performance Analyzer Wizard automatically recommends the best way to speed up your database. Additionally, Visual Basic for Applications and OLE make it simple to build quick solutions and integrate them with other Microsoft Office programs.

Table of Contents...