Home

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 : 15
In a database table, the category of information is called ____________

tuple
field
record
All of above

Question No : 16
To create a new table, in which method you dont need to specify the field type and size?

Create table in Design View
Create Table using wizard
Create Table by Entering data
All of above

Question No : 17
This data type allows alphanumeric characters and special symbols.

text
memo
auto number
None of the above

Question No : 18
Query design window has two parts. The upper part shows

Name of fields, field type and size
Tables with fields and relationships between tables
Criteria
Sorting check boxes

Question No : 19
When a picture or other graphic image is placed in the report header section it will appear____

Once in the beginning of the report
At the top of every page
Every after record break
On the 1st and last pages of the report

Question No : 20
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

Question No : 21
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

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