MCQ quiz on ms access for psc computer exam

The MCQ quiz on ms access is important for all psc exam of both assistant and full computer operator. The Public Service Commission (Lok-Sewa Aayog) has also asked more than 3 questions about the MS Access chapter. MCQ quiz on ms access is so useful for preparing PSC Computer exam.

Microsoft Access MCQ Quiz part-5

1. How can you define a field so that when entering data for that field it will display **** instead of actual typed text
   1.   Input mask
   2.   Validation Rule
   3.   Indexed
   4.   IME Mode
2. To sort records in a table
   1.   Open table, click on the field on which the sorting is to be done, then click Sort button on database toolbar
   2.   Open table, click Sort button on database toolbar, choose field based on which to sort, click OK
   3.   Click the field heading to sort it ascending or descending
   4.   All of above
3. To create relationship between two tables
   1.   drag the foreign key of a table into the primary key of another table
   2.   drag the primary key of a table into foreign key of another table
   3.   drag any field from parent table and drop on child table
   4.   Any of above can be done to create relationship
4. After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
   1.   You need to delete the whole table There is no method to remove a particular field only.
   2.   Delete all the fields from third downwards and reenter the required fields again.
   3.   Select the third column in datasheet view then Delete
   4.   Select the third row in table design view then Delete
5. To duplicate a controls formatting you can use___
   1.   Manager
   2.   Wizard
   3.   Painter
   4.   Control
6. Which field type will you select when creating a new table if you require to enter long text in that field?
   1.   Text
   2.   Memo
   3.   Currency
   4.   Hyperlink
7. In table design view what are the first column of buttons used for
   1.   Indicate Primary Key
   2.   Indicate Current Row
   3.   Both of above
   4.   None of above
8. What does the show check box in query design window indicate
   1.   It indicates whether the field is to be used or not
   2.   It indicates whether the field is to be displayed in query result or not
   3.   It indicates whether the field names to be displayed in query result or not
   4.   None of above
9. Which of the following is not a type of relationship that can be applied in Access database
   1.   One to One
   2.   One to Many
   3.   Many to Many
   4.   All of above can be applied
10. This option allows you to build a new table by entering data directly into the datasheet.
    1.   datasheet view
    2.   design view
    3.   link table
    4.   None of the above

 

MCQ quiz on ms access

This MCQ quiz on ms access contains 10 multiple-choice questions(MCQs) from the MS access chapter. Each question contains four options in which one is the correct option. Select the correct option by clicking on the "?" button. Your score will appear together.

We have published various MCQ quiz on ms access, MS-PowerPoint, and MS-Excel. Hope you all like these quizzes. If there are mistakes in any question, please comment on the related post. Thanks!