Q:

What is the function of reports in a database?

A:

Quick Answer

Reports offer a way to extract and present a specific subset of the information from a large database. Users who view database reports are spared having to view some extraneous data that is irrelevant to thinking about a particular question.

Know More

Full Answer

Database software programs such as Microsoft Access include a number of distinct features, including a forms mode to input data and a table mode to view all the database information in rows and columns. Report mode represents a useful way to answer specific questions using the information in the entire database. For instance, a business may maintain sales records in a database spanning many years and may want to understand why sales for a specific three-month period are unusually low. Using a report, information from a specific range of dates can be shown in a simplified manner in an effort to better understand the business problem.

Learn more about Software

Related Questions

  • Q:

    What are the components of a database?

    A:

    Database components include one or more tables for the data, a query language that retrieves specific data elements, and forms for entering or displaying data. Additional components include reporting tools and customized page views of data. Relational databases have a schema that defines the relationship between tables and may include components that automate routine tasks.

    Full Answer >
    Filed Under:
  • Q:

    What is a database environment?

    A:

    A database environment is a system of components that regulate the collection, management and use of data. It includes software, hardware, people, procedures and the data itself.

    Full Answer >
    Filed Under:
  • Q:

    Why is database design so important?

    A:

    A good database design is important in ensuring consistent data, elimination of data redundancy, efficient execution of queries and high performance application. Taking the time to design a database saves time and frustration during development, and a well-designed database ensures ease of access and retrieval of information.

    Full Answer >
    Filed Under:
  • Q:

    What is the Access database?

    A:

    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.

    Full Answer >
    Filed Under:

Explore