Microsoft Access
Very simply, Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis. Microsoft Access helps you analyze large amounts of information, and manage related data more efficiently than Microsoft Excel or other spreadsheet applications.
Extension = .mdb (Microsoft Data Base)
Microsoft Access is a Relational Database Management System (RDBMS), designed primarily for home or small business use.
Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. MS Access uses “objects" to help the user list and organize information, as well as prepare specially designed reports. When you create a database, Access offers you Tables, Queries, Forms, and Reports.
History of Access
In the late-1980s: Microsoft started developing its own database targeted for Microsoft Windows and OS/2. Mid 1992: Microsoft released a beta version of Cirrus, a database product. It was given the official name of Access. Late 1992: Microsoft released the first version of Access.
MS ACCESS INTERFACE (GUI)
ASCII CODES
ACCESS TERMS AND DEFINITIONS
Tables
Tables store raw data that is the backbone of the entire database system. Tables are often related to other tables in the file.
Forms
Forms display live data from the tables for data entry or editing. They are sometimes called “screens” or “user interfaces.”
Queries
Queries answer a question by selecting and sorting data for you based on what you want to know. For example, a query can tell you “how many open orders are there this month?”
Reports
Reports display data in pre-formatted templates for printing or display. Data cannot be edited in reports. It must be edited through data entry, prior to running the report.
Microsoft Access Basic Tutorial
MS Access Queries:
