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

Question No : 15
In a database table, the category of information is called ____________

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.

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
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
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