Project Description

Small Star - Online Technology

ABOUT Access Database

Microsoft Access is a database management system (DBMS), which is used to store and maintain data in its own format. You can directly import or export data stored in other applications and databases. Similar to other Microsoft Office applications, Access supports Visual Basic for Applications (VBA) and object-oriented programming. Access is much more than a desktop database. It is a simplified tool used to develop browser-based database applications, helping you to run a business.

The data stored in Access are more secure as compared to a SQL database. Data sharing is also easy is Access. You can start developing the custom applications by using professionally-designed app templates. You can establish the entity relationships simply by dragging the tables and defining the relations between them.

MAIN USES

The common applications of Access are as follows:

  • Can be used as a front-end of a program, whereas the other applications or software are used as the back-end tables.
  • Provides support for various standard types, indices, and referential integrity.
  • Allows the programmers to define solutions using VBA.
  • Provides great bandwidth and memory for the applications, executing complex queries.
  • Allows developing or publishing databases to SharePoint 2010.
  • Allows creating tables, queries, forms, and reports.
  • Allows scaling Access applications as Web solutions.

HISTORY OF Access Database

During the mid of 1980s, Microsoft made the first attempt to sell the relational database. In late 1980s, Microsoft developed the new software as a solution named Omega. Omega was considered as a front end for the Microsoft SQL server. After the Omega project was scrapped, the developers started working on the new project named Cirrus. The objective was to define a competitor for applications, such as Paradox and dBase.

On 13th November 1992, Microsoft introduced Access version 1.0. Later in May 1993 Access 1.1 was introduced. Further, in 1994, Access version 2.0 was released. The latest version available on the market is Access 2013.

Access Database OFFICIAL WEBSITE

  • adv

    ADVANTAGES OF Access Database

  • Helps you to manage and organize data for your business. 

  • Eliminates the requirement for the redundant data entry from the spreadsheets. 

  • Provides more security than a spreadsheet for the users to access data from the system. 

  • Allows users to quickly search database for specific records. 

  • Accommodates the large volume of data in comparison to spreadsheets where limited amount of data is stored. 

  • Archives older data in a database easily. 

  • Provides reports in a robust manner from a database. 

  • Allows database users to access the same file and data at the same time. 

  • dis-adv

    DISADVANTAGES OF Access Database

  • Outdated technology.

  • Sometimes, the MS Access database file gets corrupted or damaged. 

  • The database at times becomes overburdened as multiple users access Microsoft Access. 

  • Some challenges, such as version incompatibility are often considered while migrating data from one to another during software update. 

  • The data of the entire database is maintained in the computer memory. 

  • The needs of a database are completely unpredictable and keep on changing. 

  • Ideal for individual departments or small and medium business sectors; not a perfect solution for large organizations. 

  • It becomes difficult to manage databases larger than 2GB in size.

Small Star - Online Technology

RELATED PROJECTS