Preview

none

Good Essays
Open Document
Open Document
528 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
none
Microsoft access

Microsoft access is a database management system (DBMS) that combines a jet database engine with a graphical user interface. It is owned by the famous Microsoft company and has effectively evoluted since its release in 1992 with the Microsoft access version 1.0. Version 1.1 was introduced in 1993 but it was buggy. As a result, Microsoft updated its operating system and released the Microsoft access version 2.0. The latter was very efficient and used by many developers and designers but it required some patience to work with. As Microsoft built further operating systems, Access 95 was invented which made use of a graphical user interface instead of a 32 processing bit system followed by Access 97, Access 2000, Access 2003, Access 2007 and Access 2010. Minor enhancements were made since the Access 2000 version but the application software proved to be more stable.
The main features of Microsoft access are that the DBMS is implemented on C++ with a commercial license (not open source). It is compatible on Windows only. Microsoft Access makes use of SQL for running queries. Its access methods include DAO, OLE DB, ADO.NET and ODBC.C. It can moreover support programming languages such as C, C#, C++, JAVA, VBA and Visual Basic.Net. Microsoft Access is not a real database server, but it makes use of DLLs and is mostly used for developing small single-user-applications.

PostgreSQL

PostgreSQL is an object-relational DBMS released by the PostgreSQL Global Development Group. Micheal Stonebreaker's team first intended to add object features to relational databases. Between 1989 to 1993, they released four successful versions of their project before open-source developers holding an MIT license, adopted and converted it to Postgre95. In 1994, its query language changed from QUEL to SQL and three years later, its name itself was modified to PostgreSQL.
The main features of PostgreSQL are that the DBMS is firstly open-source. Queries can be written

You May Also Find These Documents Helpful

  • Satisfactory Essays

    In this assignment, you will learn to create an Access database from a given ERD. To complete this assignment, you will need to be able to run Access 2010, either through Citrix or installed on your workstation or laptop.…

    • 694 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Define database architecture. Consider Microsoft® Access®, Microsoft® SQL Server®, Oracle®, and IBM DB2® software as possible examples.…

    • 644 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    pt2520 assignment 1

    • 466 Words
    • 2 Pages

    Let’s get the definition out the way, the standard meaning if you will SQL or “sequel” to some is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS). Now that we got that out the way, let’s get to the first question.…

    • 466 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Unit 18 - Database P1, M1

    • 995 Words
    • 4 Pages

    MS Access is a database management system design by Microsoft. It offers user four important objects they are:…

    • 995 Words
    • 4 Pages
    Powerful Essays
  • Satisfactory Essays

    Ilab Instructions

    • 2258 Words
    • 10 Pages

    Download an existing Microsoft Access database file; open the database, then find and identify different database objects.…

    • 2258 Words
    • 10 Pages
    Satisfactory Essays
  • Satisfactory Essays

    • Define relational database architecture. Consider Microsoft® Access*', Microsoft SQL Server®', Oracle®, IBM DB2®, and so on.…

    • 352 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Bis 220 Wk 4

    • 526 Words
    • 3 Pages

    Microsoft Access has evolved into very user friendly tool and has become simple to learn. It provides for the easier adding, subtracting, and altering of data once the database. Access offers the ability to construct queries to extract reports from the database to analyze all aspects of the data captured in the database (Grauer, 2011). Whereas this is possible in Excel, it is much more cumbersome. Access also offers the ability for more than one user to update tables at the same time but will not allow for the updating of one record by two individuals at the same time.…

    • 526 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Microsoft Access is a tool used to manage information which helps store information for references, reports, and analysis. It also helps to manage huge sums of information. (OpenGates Software, 2012) Microsoft Access consists of Tables, Relationships, Queries, Forms, Reports, Macros, and Modules. (SimplyAccess, 2012)…

    • 828 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Athabasca Assignment

    • 837 Words
    • 4 Pages

    Remember that Access, Excel, and even FrontPage, are all tools. This assignment will help you discover how to use a database tool to support a business. You will be analyzing the data in the database and answering the questions in the exercise to create the queries and reports that are necessary to determine what the Inn’s current business situation is.…

    • 837 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Microsoft Access and Microsoft Excel have many similarities that often times make it hard to decide what program to use. For example, both of the programs have the capabilities to store large amounts of data, run queries and, analysis, and perform complex calculations that return sought-after data. However, by converting data held in Microsoft Excel spreadsheets to Microsoft Access it can be useful for a company because Microsoft Access stores company data in tables that appear to be the same as Microsoft Excel spreadsheets only Microsoft Access is designed for complex querying in relation to data stored in other tables. Additionally, according to Microsoft Office 2012, Access is the best choice when one needs to track and record data regularly, and display, export, or print subsets of that data. Access forms provide a more convenient interface than an Excel worksheet for working with data Using Access or Excel to manage data. Anyone can use Access to automate frequently performed actions, and Access reports let’s one summarize data in printed or electronic form.…

    • 699 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Key Computer Terms

    • 441 Words
    • 2 Pages

    |Data management technology |Consists of the software governing |Ch. 1 (pp. 5-17) of |Access and FoxPro |…

    • 441 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Possessing the right collaborative tools when conducting business is essential; we have been using Microsoft Excel at Party Plates for quite some time now. In the search for a database that will be more compatible to hold and organize the data of the company, the capabilities of Microsoft Access will be what we are looking for. We want to highlight some keys elements that would help us in making that for the future of our business.…

    • 400 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Mis 300 Access Assignment

    • 1191 Words
    • 5 Pages

    The data are in the two attached files. They are called AccountInfo and CustomerInfo. These are Excel files, but are only meant to get you the required information for the Access database project. These two files contain the information needed to create two tables in Access. These instructions explain how to do this.…

    • 1191 Words
    • 5 Pages
    Powerful Essays
  • Powerful Essays

    Cis515

    • 3200 Words
    • 13 Pages

    References: Carter, J. (n.d.). Database Design and Programming with Access, SQL, Visual Basic and ASP.…

    • 3200 Words
    • 13 Pages
    Powerful Essays
  • Better Essays

    Topic#6: Relational Database Operators 6.1 Significance of Relational Operators • Relational database supports basic database operations in order to provide useful means for retrieving or manipulating data in tables. • Because the relational model has its mathematical basis upon the relational theory (by thinking tables as sets or relations), the supported database operators conform to existing operators in relational algebra. • In fact, a relational database software implementation, called DBMS, is said to have higher degree of relational completeness depending upon the extent to which relational algebra operators are supported.…

    • 1097 Words
    • 5 Pages
    Better Essays