What is the Access database?
Credit:AFPAFPGetty Images
Q:

What is the Access database?

A:

Quick Answer

The Microsoft Access database program is a management system included in the Microsoft Office application suite, and an Access database is a file that one creates while using this software program. It comes with the professional edition and higher levels of the Office suite, and it is also available as a separate program. It stores data in a proprietary format and can link to or import data in other programs.

 Know More

Full Answer

The Microsoft Access database program can use its own storage files, but it can also serve as a front-end using other products at the back-end, like Oracle, Sybase and Microsoft SQL Server. The .accdb and .mdb formats of Access databases can use more than one back-end source. Also, some programs like ASP.NET, Visual Basic and Visual Studio .NET uses the Access format for their queries and tables. It is also possible to integrate Access with other programs in the Office suite, as well as ActiveX Controls.

It is possible to automate repetitive tasks in Access by setting up macros that have point-and-click options, and it is also simple to put a database up on a shared network so that users have the ability to update and share data without erasing the work of anyone else. Whereas Excel locks the whole spreadsheet, Access locks it one record at a time.

Learn more about Software

Related Questions

  • Q:

    What is the difference between Access and Excel?

    A:

    Microsoft Access is a database management program, while Microsoft Excel is a spreadsheet application. Someone can use these programs simultaneously to track business productivity and other factors.

    Full Answer >
    Filed Under:
  • Q:

    What is Google Docs?

    A:

    Google Docs is a suite of web-based applications offered by Google that gives free access to word processing, spreadsheet and presentation programs. Users can create documents using the apps, save them to Google Drive, which provides data storage, and easily share files with other online users.

    Full Answer >
    Filed Under:
  • Q:

    What is MS Publisher?

    A:

    MS Publisher, or Microsoft Publisher, is desktop publishing software authored by Microsoft that is part of the Microsoft Office package or suite. MS Publisher is an entry-level program that allows users to place emphasis on layout, pictures and effects.

    Full Answer >
    Filed Under:
  • Q:

    What is a software suite?

    A:

    A software suite is a collection of several applications that are bundled together and sold or distributed as a package. Each component program generally provides different, but related, functionality.

    Full Answer >
    Filed Under:

Explore