answersLogoWhite

0

What is a database query?

User Avatar

Wiki User

โˆ™ 2010-05-08 07:50:27

Best Answer

A database query is a piece of code (a query) that is sent to a database in order to get information back from the database. It is used as the way of retriving the information from database

A database "query" is basically a "question" that you ask the database. The results of the query is the information that is returned by the database management system. Queries are usually constructed using SQL (structured query language) which resembles a high-level programming language.

The term 'query' means to search, to question, or to find. When you query a database, your searching for information in the database. Different query languages exist for different type of databases. MS Access uses SQL, which stands for Structured Query Language. MS Access contains Tables, Forms, and Queries. The Forms are used to enter or display the data, the Tables are where the data is saved, and the queries are used to search for specific data.

An example of an query can be this:

SELECT DISTINCT Agent FROM QAMonitoring ORDER BY Agent;

The query searches the 'Agent' field from the QAMonitoring table and sorts the list by last name. There are plenty of MS Access DB forums on the net for more info and help.

Creating a Simple Query in Microsoft Access

Have you ever wanted to combine information from multiple tables in your database in an efficient manner? Microsoft Access offers a powerful query function with an easy-to-learn interface that makes it a snap to extract exactly the information you need from your database. In this tutorial we'll explore the creation of a simple query.

In this example, as with all of our Access tutorials, we will use Access 2000 and the Northwind sample database included on the installation CD-ROM. If you're using an earlier version of Access, you may find that some of the menu choices and wizard screens are slightly different. However, the same basic principles apply to all versions of Access (as well as most database systems).

Let's explore the process step-by-step. Our goal in this tutorial is to create a query listing the names of all of our company's products, current inventory levels and the name and phone number of each product's supplier.

1. Open your database. If you haven't already installed the Northwind sample database, these instructions will assist you. Otherwise, go to the File tab, select Open and locate the Northwind database on your computer.

2. Select the queries tab. This will bring up a listing of the existing queries that Microsoft included in the sample database along with two options to create new queries.

3. Double-click on "create query by using wizard". The query wizard simplifies the creation of new queries. We'll use it in this tutorial to introduce the concept of query creation. In later tutorials we'll examine the Design view which facilitates the creation of more sophisticated queries.

User Avatar

Wiki User

โˆ™ 2010-05-08 07:50:27
This answer is:
User Avatar
User Avatar

Cookiies4U

Lvl 1
โˆ™ 2022-02-01 19:45:09
Wow, this is a veryyyy old answer! *O* Not reading all that but thanks to u, good human ;)
Study guides

Is Microsoft Access an RDBMS or DBMS

How might an automobile company use a management information system to reduce its costs and better serve its customers

What are PCs that are classified as mobile computers

What are the entry barriers that act as a potiential threat to new entrants in the market

โžก๏ธ
See all cards
3.89
โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…
9 Reviews
More answers
User Avatar

Moth

Lvl 2
โˆ™ 2021-05-03 14:26:33

a search for data that matches given parameters

This answer is:
User Avatar
User Avatar

Cookiies4U

Lvl 1
โˆ™ 2022-02-01 19:45:37
This is correct for me, Moth, thanks a ton! :)

Add your answer:

Earn +20 pts
Q: What is a database query?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are you doing if you query a database?

You are searching the database or extracting data from the query.


Is database window query?

yeah, database is a query language,, abd it is stored datas


What is query?

Query is a statement which user gives in database.


What do mean by query language and its needs?

Query Language is way for communicating from the database. It work as a interface between user and the Database. its not possible to generate a result from database without query language. Query language helps us to communicate with database.


What is the importance of querying a database?

A database query is a piece of code (a query) that is sent to a database in order to get information back from the database. It is used as the way of retrieving the information from database.


What is database query?

A database "query" is basically a "question" that you ask the database. The results of the query is the information that is returned by the database management system. Queries are usually constructed using SQL (structured query language) which resembles a high-level programming language.


What does the acronym SQL stand for?

SQL stands for Structured Query Language as it refers to the type of database query or database server which accepts the query.


What is the database term query?

In database the term query refers to question to the database for accessing any data. Example of query : select * from table-name gives you all the records from table.


4 A Query of database is a synonym for a of database?

Search Search


What is query in data base?

query is a request for retrive the information from the database.


What does a query allow you to do on a database?

a query allows you to select certain data


What is it called when you search a database?

Query

People also asked

What software has the use of queries and reports as key functions?

View results

What type of software has been developed to enable users to make use of the vast amount of data being collected and organized today?

View results

What captures sales information records it and makes it available for use by finance departments?

View results