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.

Continue Reading

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:

    How do you access a Microsoft Word manual?

    A:

    Access Microsoft Word manuals by downloading the manual on Office.com or by opening the manual that comes with the application. The exact method to access the built-in manual depends on the version of the application.

    Full Answer >
    Filed Under:
  • Q:

    What is Microsoft InfoPath used for?

    A:

    Microsoft InfoPath allows users to create various electronic forms, including surveys, expense reports and time cards, to work in tandem with an existing business database or as a standalone solution. Companies also use it to improve the interface of their websites and automate the process of collecting and sharing information.

    Full Answer >
    Filed Under:
  • Q:

    What is a pivot table in access?

    A:

    A pivot table in Access is a data processing tool used to summarize large amounts of data quickly and easily. It is a feature also found in spreadsheets and business intelligence programs.

    Full Answer >
    Filed Under:
  • Q:

    What is the Citrix access platform used for?

    A:

    Citrix Access Gateway provides secure, single-point access to information resources. The Gateway works regardless of the presence of firewalls, and it also supports any application or protocol. Access Gateway also reconnects users to applications when they make a change to their location and/or device, and it replicates the desktop experience on all mobile devices. The Gateway works with any application hosted on Citrix Presentation Server, Windows or UNIX, and also works on network file shares and direct-access apps.

    Full Answer >
    Filed Under:

Explore