Notes on Microsoft Access | Extra References > Computer Basics > Database Management | KULLABS.COM

Microsoft Access

  • Note
  • Things to remember
  • Videos
  • Exercise
  • Quiz

Introduction

Microsoft Access, also known as Microsoft Office Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately.

Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases.

Software developers and data architects can use Microsoft Access to develop application software, and "power users" can use it to build software applications. Like other Office applications, Access is supported by Visual Basic for Applications (VBA), an object-oriented programming language that can reference a variety of objects

Features

    In addition to using its own database storage file, Microsoft Access also may be used as the 'front-end' of a program while other products act as the 'back-end' tables, such as Microsoft SQL Server and non-Microsoft products such as Oracle and Sybase. Similarly, some applications such as Visual Basic, ASP.NET, or Visual Studio .NET will use the Microsoft Access database format for its tables and queries.
  • Microsoft Access may also be part of a more complex solution, where it may be integrated with other technologies such as Microsoft Excel, Microsoft Outlook, Microsoft Word, Microsoft PowerPoint and ActiveX controls.
  • Programmers can create solutions using VBA, which is similar to Visual Basic 6.0 (VB6) and used throughout the Microsoft Office programs such as Excel, Word, Outlook and PowerPoint.
  • Users can create tables, queries, forms and reports, and connect them together with macros.
  • Users can import and export data to many formats including Excel, Outlook, ASCII, dBase, Paradox, FoxPro, SQL Server, Oracle, ODBC, etc.
  • It also has the ability to link to data in its existing location and use it for viewing, querying, editing, and reporting. This allows the existing data to change while ensuring that Access uses the latest data.
  • Access is often used by people downloading data from enterprise level databases for manipulation, analysis, and reporting locally.



  • Microsoft Access, also known as Microsoft Office Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. 
  • In addition to using its own database storage file, Microsoft Access also may be used as the 'front-end' of a program while other products act as the 'back-end' tables, such as Microsoft SQL Server and non-Microsoft products such as Oracle and Sybase.

.

Very Short Questions

MS Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

Users can create tables, queries, forms and reports, and connect them together with macros.

Visual Basic for Applications (VBA) is an object-oriented programming language that can reference a variety of objects.

0%
  • What is full form of VBA?

    Variety Basic for Applications
    Visual Basic for Applications
    Visual Bank for Applications
    Vital Basic for Applications
  • Which of the following application do not use Microsoft Access database format for its tables and queries?

    ASP.NET
    Visual Basic
    Visual Studio .NET
    C++

  • Users can create tables, queries, forms and reports, and connect them together with ______.

    macros

    mini

    micros

    mainframe

  • Visual Basic for Applications (VBA) is ______  programming language.

    user-oriented
    task-oriented

    client-oriented
    object-oriented

  • Which cannot be formed using MS-access?

    Form

    Table

    Folder

    Query

  • You scored /5


    Take test again

ASK ANY QUESTION ON Microsoft Access

No discussion on this note yet. Be first to comment on this note