The type of query extract the data and put them into separate table

Related MCQs

• What is the type of query that extracts data from a table and puts them into separate table?
• 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 can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view
• A query summarizes information in a grid, organized by regions and months. Which type of query is this?
• How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:
• A summary query can be created by adding which row to the design grid of a select query?
• This query wizard will create a select query.
• If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called:
• 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?