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.

Continue Reading
What is the Access database?
Credit: AFP AFP Getty Images

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 are some features you should know when learning OpenOffice?

    A:

    The important features to know when learning OpenOffice depend on the specific program within the software suite in question, though basic actions should include creating new documents, making basic edits and saving the file for future use. Specific features can include editing fonts and formatting in Writer, inserting formulas in Calc or inserting images into slides with Impress.

    Full Answer >
    Filed Under:
  • Q:

    What is PowerPoint?

    A:

    PowerPoint is a software program developed by Microsoft that facilitates the creation of slide show presentations and is part of the Microsoft Office program suite. Presentations created on PowerPoint are typically used in both academic and business settings to accompany oral presentations.

    Full Answer >
    Filed Under:
  • Q:

    What are some important features of the Quicken Deluxe version?

    A:

    Important features of the Deluxe version of Quicken money management software include the ability to import data from previous versions of the program, access to all financial accounts in a single interface and the ability to create custom savings goals for retirement or a college education. It also offers access to free phone support and has features to help reduce debt quickly, as of 2015.

    Full Answer >
    Filed Under:
  • Q:

    How do you create a database?

    A:

    Create a database by using one of the free templates that come with Microsoft Access or creating one from scratch. Access is a part of the company's Office application bundle. You can then edit the templates according to your needs.

    Full Answer >
    Filed Under:

Explore