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

    Full Answer >
    Filed Under:
  • Q:

    What are the advantages of tables in Microsoft Access?

    A:

    The advantages of Microsoft Access tables include easier data manipulation, creation of charts and easy entry and removal of data. The strong integrity features in these tables ensure that the right data is being inputted.

    Full Answer >
    Filed Under:
  • Q:

    What is a relationship in Microsoft Access?

    A:

    A relationship in Microsoft Access connects information between tables. It helps prevent redundant information and ensures that information is consistent from table to table. Relationships also help users create reports.

    Full Answer >
    Filed Under:
  • Q:

    What is the importance of Microsoft Access?

    A:

    Microsoft Access is an important information management tool that allows users to create databases to store various kinds of information for reference, reporting and analysis. It is a flexible program that allows the performance of simple end-user tasks as well as mission critical operations.

    Full Answer >
    Filed Under:

Explore