MS Access Questions & Answers | Basic Computer Knowledge

21.

Which of the following is not a type of relationship that can be applied in Access database

   A.) One to One
   B.) One to Many
   C.) Many to Many
   D.) All of the above

Answer: Option 'D'

All of the above

22.

The size of Yes No field is always

   A.) 1 bit
   B.) 1 byte
   C.) 1 kilobyte
   D.) 1 megabyte

Answer: Option 'A'

1 bit

23.

To add two cells (A1 and A2) together you use the following formula:

   A.) A1 plus A2
   B.) =A1 + A2
   C.) =Add(A1+A2)
   D.) =together(A1:A2)

Answer: Option 'B'

=A1 + A2

24.

To create relationship between two tables

   A.) drag any field from parent table and drop on child table
   B.) drag the foreign key of a table into the primary key of another table
   C.) drag the primary key of a table into foreign key of another table
   D.) None of the above

Answer: Option 'C'

drag the primary key of a table into foreign key of another table

25.

Which of the following is the default join between two recordsets?

   A.) Inner join
   B.) Outer join
   C.) Right outer join
   D.) None of the above

Answer: Option 'A'

Inner join

MS Access MCQs Download Pdf

Recent Posts