Q:

What is the purpose of a query in Microsoft Access?

A:

Quick Answer

A query retrieves data from an Access database. Even though queries for Microsoft Access are written in Structured Query Language, it is not necessary to know SQL to create an Access query. The Query by Example screen allows users to run queries by picking tables and fields from a list.

Know More

Full Answer

A common Access query is the Select Query. A Select Query pulls data from one or more tables in the database, and it displays the result for the user. Records in the database are not edited with a Select Query but are only displayed. For example, a Select Query is used to pull records from a database for customers who live in a specific zip code. This data is then displayed on the screen or in a report. Other common Access queries are Update Queries, which change information in existing records; Append Queries, which combine data from multiple tables or queries; Delete Queries, which delete records; and Make Table Queries, which create additional tables in a database.

After a query is created in Access, it is either displayed or run. A query displays in the Datasheet View. The Datasheet View allows users to see the results of the query before any changes are made. Once a query runs, data may be deleted or changed. In Access, a message window appears when data is about to be changed or deleted. This allows the user to terminate the query if necessary.

Learn more about Software

Related Questions

  • Q:

    What is the purpose of Microsoft Excel?

    A:

    Microsoft Excel is a spreadsheet application designed to perform basic and complex mathematical computations and functions. In addition to performing arithmetic operations, Excel allows users to create graphical displays of data, forms and pivot tables. It is also routinely used to sort information and assist users in identifying data trends.

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

    What is Microsoft Streets & Trips?

    A:

    Microsoft Streets & Trips is a discontinued Microsoft software program that generates travel routes. The last version of the software is Microsoft Streets & Trips 2013.

    Full Answer >
    Filed Under:
  • Q:

    What is Microsoft Visio?

    A:

    Microsoft Visio is a specialized diagram application for the creation of business plans, flowcharts and layouts with scalable vector graphics. The program offers a diverse set of visual applications and built-in stencils to simplify complex data through the creation of streamlined diagrams. Visio includes templates and stencils for business diagrams, network diagrams, flowcharts, organization charts and various multipurpose diagrams

    Full Answer >
    Filed Under:

Explore