Q:

What is Microsoft Access used for?

A:

Quick Answer

Microsoft Access is a database management system that serves as an electronic filing system. With Microsoft Access, the user is easily able to modify any data within the database, produce reports from the database and submit queries about all information stored into it. Microsoft Access fully utilizes the Windows layout for ease of use.

Continue Reading
What is Microsoft Access used for?
Credit: Brad Dyksen E+ Getty Images

Full Answer

Most users of Microsoft Access use the tables, forms and queries. Database tables are very similar to spreadsheets. After listing the subject matter of each column, the user has the option of adding additional columns to detail the attributes of the subject. When done, each row has any needed information about each subject. The form method of data entry available in Microsoft Access allows one to enter information for the system in graphical form for it to be transferred to a database. Some may find this easier for data entry if they do not have to finalize the tables. The query function of Microsoft Access increases productivity by allowing the user to combine information from more than one table and specify the conditions of the data that the user retrieves. It shortens the time-consuming task of having to look manually through bountiful information to pinpoint certain ones that have certain characteristics.

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 the purpose of Microsoft Access?

    A:

    The purpose of Microsoft Access is to create quick and easy databases. Access provides a user-friendly interface that helps the user build and develop an information storage and retrieval system without much programming experience.

    Full Answer >
    Filed Under:
  • Q:

    How can you download Microsoft Access?

    A:

    As of 2015, users can download Microsoft Access from Office.com by either purchasing the software on its own or as part of the Microsoft Office application suite. Microsoft Access is available for both personal and commercial versions of Microsoft Office, and Office.com also offers potential users a free trial download link for both versions. Microsoft Access is a software that users can use to create applications for a database in business-friendly formats.

    Full Answer >
    Filed Under:
  • Q:

    What is "data integrity" in Microsoft Access?

    A:

    In Microsoft Access, data integrity refers to the values that are used and stored in the data structures of an application. To ensure data integrity the application must be able to control every data-using process so that the information being produced continues to be correct.

    Full Answer >
    Filed Under:

Explore