Home
Home >> Computer>> Softwares>> MS Office>> Microsoft Access

Microsoft Access MCQ Question with Answer

Microsoft Access MCQ with detailed explanation for interview, entrance and competitive exams. Explanation are given for understanding.

Download Microsoft Access MCQ Question Answer PDF

Try Microsoft Access Mock Test

Question No : 50
To create primary key for a table when in design view

Type PRIMARY in field type box when creating required field
Mark the Primary check box in field name of required field
Click the Primary Key button in Design ribbon when the cursor is in required field
None of the above
View Answer   Discuss

Question No : 51
A primary key in any table has the properties

Not Null
No Duplicates
Both of above
None of above
View Answer   Discuss

Question No : 52
A composite key is

Required when a table does not have any unique fields in it
The primary key with AutoNumber as the field type
Made up of two or more fields to uniquely identify records
Is a foreign key that uniquely identifies records
View Answer   Discuss

Question No : 53
If I create Student field in Fees table to store student_id of Students table, then this Student field in Fees table is called:

Foreign key
Native key
Composite key
Primary key
View Answer   Discuss

Question No : 54
Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called

Foreign key
Native key
Composite key
Primary key
View Answer   Discuss

Question No : 55
Which of the following expresses correct order?

Characters, Fields, Records, Tables, Files, Databases
Characters, Fields, Records, Tables, Database, Files
Databases, Tables, Files, Records, Field, Character
Files, Databases, Tables, Records, Fields, Characters
View Answer   Discuss

Question No : 56
An Access database object that is used to enter, view or edit records

Table
Form
Query
Report
View Answer   Discuss

Wanna test your skill? Here are some exams we prepared for you. So if you need to test your skill just attempt any exam from bellow.

Exam Name No. Of Q Link
MS Office set 1 30 Start
MS Office set 2 30 Start
MS Office set 3 30 Start
MS Office set 4 30 Start
MS Office set 5 30 Start
MS Office set 6 30 Start
MS Office set 7 30 Start
MS Office set 8 30 Start
MS Office set 9 30 Start
MS Office set 10 30 Start
MS Office set 11 30 Start
MS Office set 12 30 Start