what is the purpose of 1.a query 2.a report,3.a form in a database????

Question

could u give me a brief explanation separetely,because i think they r all doing the same...

Answer 1

Query : The code we use to get data out of the database

Report : The code used to present the data extracted by the query

Form : A predfined query and report.

Answer 2

It's easy.

A query will return a subset of information or records from tables, queries, or a combination of both, based on the criteria you specified (e.g., a list of all cars manufactured after 1985), but it's not pretty.

The report is the pretty version of the information returned from a table or query. You can change the font, layout, etc. to suit your needs.

The form is a front-end way for a programmer to make running queries and other actions user-friendly. Instead of having to know report1 is an invoice report, a person can create a form that automatically opens as a little window, with a button on it that says "Print Invoice Report."

Answer 3

I'm going to assume that you're talking about Microsoft Access with this question, but in reality, the terms that you're asking about apply to any database. The answer that was already provided here was actually perfectly accurate, but a little bit brief, so I thought I'd take the time to go in to some detail:

First of all, I want to point out that forms and queries are not actually a *part* of the database, so much as they are ways to obtain information *from* a database.

A database is just a collection of information. For instance, you could have a database that lists your classmates by their first name, last name and age. Take a look at the example below, noting that the spacing isn't going to be quite right...The first name of each student goes in the FirstName column, the last name of each student goes in the LastName column, and the Age goes in the Age column:

***FirstName*** ***LastName*** ***Age***
Sally Johnson 12
Billy Wilson 14
Joey Thompson 18


In the above example, you have a database that lists the first name, last name, and age of various students...Keep this in mind as we talk about...

Queries

A query is, by definition, a question. When we are talking about databases, it is said that we are "Querying the database". In other words, we're asking for something from it.

A query of our above database in English might go something like this:

"Find me the student who's first name is Sally."

In SQL, (a very popular computer language for querying databases), the same request would look like this:

SELECT * FROM tblStudents WHERE FirstName="Sally"

I know that may not look like it makes any sense, but the point I want to underscore here is that all that junk up there is just a *question* asked in computer language instead of English. This "query" would return the first record, Sally Johnson.

So, a query is nothing more than a request for information from a database.


That brings us to Forms.

Forms are sort of like the missing link between a database and a query. Ask yourself this...If you want to request information from a database, where do you enter the request? When the database returns an answer to your request, where does it display it? The answer, is...on a form.

A form is just a GUI, (graphic user interface), for displaying information from a database, and for allowing users to request information from a database. A good form will have a place where you can enter the request, a button or some other thing to click in order to have your request processed, and then a place for the response to you request to be displayed.

Briefly put, the form is the object that allows you to request information from a database, and then displays the data you requested.

I know this might have been a bit long winded, but I hope it helped!

Answer 4

you're able to be waiting to come upon if the internet site is working from a placed up of itself ( i.e. am I working hence of somebody choosing a 'exhibit effects' button. you're able to consequently be waiting to declare do not run the question in any respect if that requirement isn't met. yet another factor this is a universal factor - it would be worth limiting the quantity of effects displayed. maximum consumers are not going to choose on even one hundred effects under no circumstances ideas hundreds which may well be the effects of a few queries. So it would desire to be worth development that into your internet site besides.