Scribd Logo
Upload

Welcome to Scribd!

  • 62 views

    Advantages of MS Access

    Uploaded by

    Prem Lal
    Microsoft Access is a relational database management system that is part of the Microsoft Office suite. It allows importing and exporting of data from many formats, linking to existing data for editing and reporting, and easy distribution through its Jet Database format. As a programmer tool, it provides SQL compatibility for manipulating data tables. Access is useful for businesses to capture, archive, and transfer data between programs, as a web database application, and for group project management through servers.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPTX, PDF, TXT or read online from Scribd

    Advantages of MS Access

    Uploaded by

    Prem Lal
    62 views5 pages
    Microsoft Access is a relational database management system that is part of the Microsoft Office suite. It allows importing and exporting of data from many formats, linking to existing data for editing and reporting, and easy distribution through its Jet Database format. As a programmer tool, it provides SQL compatibility for manipulating data tables. Access is useful for businesses to capture, archive, and transfer data between programs, as a web database application, and for group project management through servers.

    Original Description:

    mba notes

    Original Title

    Presentation 1 MBa

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Microsoft Access is a relational database management system that is part of the Microsoft Office suite. It allows importing and exporting of data from many formats, linking to existing data for editing and reporting, and easy distribution through its Jet Database format. As a programmer tool, it provides SQL compatibility for manipulating data tables. Access is useful for businesses to capture, archive, and transfer data between programs, as a web database application, and for group project management through servers.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    62 views5 pages

    Advantages of MS Access

    Uploaded by

    Prem Lal
    Microsoft Access is a relational database management system that is part of the Microsoft Office suite. It allows importing and exporting of data from many formats, linking to existing data for editing and reporting, and easy distribution through its Jet Database format. As a programmer tool, it provides SQL compatibility for manipulating data tables. Access is useful for businesses to capture, archive, and transfer data between programs, as a web database application, and for group project management through servers.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    You are on page 1of 5

    Advantages of MS Access

    What is MS Access
    Microsoft Access is a relational database management system that is part of the Microsoft Office professional suite. The software combines the Microsoft Jet Database Engine with a graphical user interface and development tools. It can also import data in other Access databases including Excel, SharePoint, XML, Outlook, HMTL and many other types of data.

    ADVANTAGES
    Data Access Importing and exporting data of many formats is key to the advantages of Access. It has the ability to link the data in its existing location for viewing, querying, editing and reporting. This allows the data to be changed and enables anyone with the Access platform to use the latest edits. Jet Database Format Access can use the Jet Database format, which allows the application and data in one file to be easily distributed to other users who can run it elsewhere. Jet allows multiple users to access data concurrently and employs a datalocking policy when multiple users try to write the same data. SQL Compatibility From a programmer's perspective, this gives the software more utility to edit SQL statements and use them directly in macros or VBA Modules. This allows the data being used in Access to be view graphically or edited in the form of SQL statements, making it easier to manipulate Access tables.

    Importance of Microsoft Access 2007 to Businesses


    Function As a program to capture data, archive data or transfer data to other programs. As a server-side database application for web development, which saves web developers time in developing a database application for the web. Supports groupware project management from various geographical locations through Microsoft server management products.
    Features Access 2007 increased the number of business templates that can be created through its wizard interface. To form input, database structure and tables. Access also allows tables to be joined on a primary key, which is important for business applications that have more than one database.

    Different Softwares in MS Office package


    ms wrd mexecl ms ppt ms outl 65 35 52 56
    70
    60

    50 40 30 20 10 0 ms wrd mexecl ms ppt ms outl Series1

    You might also like