Microsoft access quiz for psc computer exam

The Microsoft access quiz 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. Microsoft access quiz is so useful for preparing PSC Computer exam.

Microsoft Access MCQ Quiz part-3

1. This is the stage in database design where one gathers and lists all the necessary fields for the database project.
   1.   data definition
   2.   data refinement
   3.   establishing relationship
   4.   none of the above
2. The two form layout types will display multiple records at one time are tabular and___
   1.   columnar
   2.   justified
   3.   date sheet
   4.   pivot table
3. The size of a field with Number data type can not be
   1.   2
   2.   4
   3.   8
   4.   16
4. A small button with three dots usually displayed at the right of field properties box
   1.   Make button
   2.   Expression button
   3.   Build button
   4.   None of above
5. The size of Yes No field is always
   1.   1 bit
   2.   1 byte
   3.   1 character
   4.   1 GB
6. This key uniquely identifies each record
   1.   primary key
   2.   key record
   3.   unique key
   4.   field name
7. The command center of access file that appears when you create or open the MS Access database file.
   1.   Database Window
   2.   Query Window
   3.   Design View Window
   4.   Switchboard
8. A database language concerned with the definition of the whole database structure and schema is ________
   1.   DCL
   2.   DML
   3.   DDL
   4.   All of above
9. When creating a new table which method can be used to choose fields from standard databases and tables
   1.   Create table in Design View
   2.   Create Table using wizard
   3.   Create Table by Entering data
   4.   None of above
10. What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
    1.   A relationship is created
    2.   Edit relationship dialog box appears
    3.   Error occurs
    4.   Nothing happens

 

Microsoft access quiz

This Microsoft access quiz 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 online computer quizzes on Microsoft access quiz, 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!