Q:

What is Microsoft Access used for?

A:

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.

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 "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 is the importance of a database management system?

    A:

    A database management system is important because it manages data efficiently and allows users to perform multiple tasks with ease. A database management system stores, organizes and manages a large amount of information within a single software application. Use of this system increases efficiency of business operations and reduces overall costs.

    Full Answer >
    Filed Under:
  • Q:

    What is a database management system used for?

    A:

    A database management system is used to let employees and owners access a large variety of information from a specific location like a computer. It allows access to specific information based on the user's credentials.

    Full Answer >
    Filed Under:
  • Q:

    What are examples of database management systems?

    A:

    Examples of database management systems, or DBMS, are MySQL, Microsoft Access, Oracle and DB2. A DBMS, also called a database manager, is a computer program that allows one or several users to execute database functions such as storing, retrieving, deleting and modifying data.

      Full Answer >
    Filed Under:

Explore