How do queries work in a database (ms acess) can you explain in detail please. for 10 points 3-4 sentances+?

Question

How do queries work in a database (ms acess) can you explain in detail please. for 10 points 3-4 sentances+?

Answer 1

queries are just actions that are processed using the database.

ex.retreive records, delete records, insert records ect. all can be done using queries.

Answer 2

How to import a Works database file into Access 2000 databaseDiscusses how to import a Works database file into an Access 2000 database. Requires you save the Works database file as an Access compatible format first.

support.microsoft.com/kb/197894 - Similar pages



Introduction to the Microsoft Works DatabaseNote: This workshop focuses on the database module in MS Works version 4.5 for Windows. There will be differences if working with earlier or later versions ...

www.zisman.ca/database/ - 33k - Cached - Similar pages



How a databse worksHow a database works ... Back to: Database, an introduction ... with the basic concepts of field and record, let's see how a database actually functions. ...

www.gianace.com/dispensa/applications/database2.htm - 4k - Cached - Similar pages



Database Works

Answer 3

SQL is simply the evaluation of a boolean expression against a set or subset of the records in a database. In the simple case, a single table is examined row-by-row to see whether the result of evaluating the expression is true. For each row where it is true, a pointer to the record is saved into the results list. Reports are sometimes run against the result list so that the records are qualified by the query.

Answer 4

Microsoft Access is now the most popular Windows database program. A major reason for its success is its revolutionary query interface. Once data is collected in a database, analysis and updates need to be performed. Queries offer the ability to retrieve and filter data, calculate summaries (totals), and update, move and delete records in bulk. Mastering Microsoft Access queries will improve your ability to manage and understand your data and simplify application development.



The visual representation of tables and the graphical links between them makes Microsoft Access queries extremely easy to use. Fortunately, the nice user interface also allows very powerful and advanced analysis. The entire query engine is modeled on SQL systems and allows switching between the graphical query design and SQL syntax. Many Microsoft Access users and developers learned SQL from this feature.



Knowing the many features of Microsoft Access queries will allow you to perform advanced analysis quickly without programming. This presentation covers the basics of queries revealing a variety of subtleties. It quickly moves to more advanced topics with hints and techniques for creating sophisticated queries. Finally, programmatic use of queries is presented.

Answer 5

Microsoft Access is a differet kettle of fish to professional databases. It uses a propietory version of SQL called Jet SQL. SQL is the Structured Query Language, and is used by most databases. An example SQL statement would be:



SELECT Staff.* FROM Staff WHERE Staff.Gender="M";

Answer 6

I think Thomas K's answer is probably the best so far.

That is how the a select query works yes.