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