MS Access MCQ with Answers

MS Access MCQ with Answers

236) Which of the following functions is used to all the values in a numeric field

Answer is:

Count

237) Which of the following queries can create a table

Answer is:

Make-Table

238) In a query, which row do you need to place wildcards to affect a parameter

Answer is:

Criteria

239) 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

Answer is:

24

240) Which of the following types of joins displays records with the same value in the common field

Answer is:

Inner join

45
46
47
48
49
50
51