COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Form
|
|
|
Report
|
|
|
Queries
|
|
|
Field
|
Detailed explanation-1: -A query is another type of database object. A query is data resulting from questions you ask of one or more tables. For example, let’s say you want to find out how many male students are in Mr. Emerson’s class.
Detailed explanation-2: -A query, or SQL SELECT statement, selects data from one or more tables or views.
Detailed explanation-3: -Just like it sounds, a multiple-table query blends together information from two or more related tables. The main difference between a multiple-table query and a single-table query is that with multiple-table queries, Access creates a link between related tables.
Detailed explanation-4: -An SQL SELECT statement retrieves records from a database table according to clauses (for example, FROM and WHERE ) that specify criteria.