Microsoft Access mcq questions with answer – Set 1

Important Instructions:

• Total Number Of Questions : 10
• Passing Marks : 7
• Each Question Carry 1 Mark, No Negative Marking.
• Do Not Refresh The Page.
• This Is A FREE Online Test, DO NOT Pay Money To Anyone To Attend This Test.
• Best Of Luck…

Results

-

Congratulation…
You Have Passed The Test, You Should Try To The Next One…!!

4.5/5 - (2 votes)

You May Also Like :   Microsoft Access mcq questions with answer - Set 3

Unfortunately…
You Did Not Pass. Why Not Try It Again?

4.5/5 - (2 votes)

You May Also Like :   Microsoft Access mcq questions with answer - Set 3

#1. Which data type allows alphanumeric characters and special symbols?

Text

Text

Memo

Memo

Auto number

Auto number

None of the mentioned

None of the mentioned

#2. When a picture or other graphic image is placed in the report header section it will appear___________.

Once in the beginning of the report

Once in the beginning of the report

At the top of every page

At the top of every page

Every after record break

Every after record break

On the 1st and last pages of the report

On the 1st and last pages of the report

#3. In a database table, the category of information is called?

Tuple

Tuple

Field

Field

Record

Record

All of the above

All of the above

#4. The query design window consists of two parts, what does the upper part show?

Name of fields, field type and size

Name of fields, field type and size

Tables with fields and relationships between tables

Tables with fields and relationships between tables

Criteria

Criteria

Sorting check boxes

Sorting check boxes

#5. Which key uniquely identifies each record?

Primary key

Primary key

Key record

Key record

Unique key

Unique key

Field name

Field name

#6. What is a database language that deals with the definition of a complete database structure and schema?

DCL

DCL

DML

DML

DDL

DDL

All of above

All of above

#7. What is the command center of an Access file that appears when you create or open an MS Access database file called?

Database Window

Database Window

Query Window

Query Window

Design View Window

Design View Window

Switchboard

Switchboard

#8. What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?

A relationship is created

A relationship is created

Edit relationship dialog box appears

Edit relationship dialog box appears

Error occurs

Error occurs

Nothing happens

Nothing happens

#9. When creating a new table which method can be used to choose fields from standard databases and tables?

Create table in Design View

Create table in Design View

Create Table using wizard

Create Table using wizard

Create Table by Entering data

Create Table by Entering data

None of above

None of above

#10. Which of the following can you do to create queries in MS Access?

You can drag and drop fields on query builders

You can drag and drop fields on query builders

you can type the SQL command in SQL view

you can type the SQL command in SQL view

You can use query wizard or design view

You can use query wizard or design view

All of the mentioned

All of the mentioned

CHECK ANSWER