It is most common type of query. It retrieves records from one or more tables and then displays the

Related MCQs

• A query prompts a user for a data and then displays only records that contain the specified date. The type of of query is this
• You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
• You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?
• A(n) _______________ query locates data from one or more tables.
• A query summarizes information in a grid, organized by regions and months. Which type of query is this?
• The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
• Which of the following types of joins displays records with the same value in the common field?
• This type of database contains multiple tables that are connected to produce combined output from all tables.
• In a query\'s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?
• You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view