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.

Know More
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.


Is this answer helpful?

Similar Questions

  • Q:

    What is Microsoft Access?

    A:

    Microsoft Access is a database management system used for capturing and analyzing data from computers or networks. Access can also be used to build new applications that use the data once it has been categorized.

    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:
  • Q:

    What are the advantages of DBMS?

    A:

    A database management system (DBMS) offers several advantages, such as preventing redundancy of data and improvement in data security. DBMS reduces the costs associated with the retrieval of data.

    Full Answer >
    Filed Under:
  • Q:

    What is SQL Server?

    A:

    A SQL server can refer to a database management system that is accessible from devices that is formatted using the SQL language. When "SQL" is capitalized, it typically refers to database management products that are produced by either Microsoft or Sybase.

    Full Answer >
    Filed Under:

Explore