Microsoft Access MCQ

Microsoft Access MCQ

MS-Access

This is our Microsoft Access MCQ section here everyone can get thousands of Multiple Choice Question (MCQ) of Microsoft Access.


1. When a picture or others graphic image is placed in the report header section is will appear………

A. Once in a beginning of the report
B. Every after record break
C. At the top of every page
D. On the first and last pages of the report

Answer: A

2. Cascade delete option

A. is used to delete all the records of all tables in a database
B. will repeat the recent delete operation to all the records of current table
C. is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent table is deleted
D. None of above

Answer: C.

3 This data type allows alphanumeric characters and special symbols.

A. text
B. memo
C. auto number
D. None of the above

Answer: A

4. Query design windows ha two parts . The upper part shows

A. Name of fields, field type and size
B. Criteria
C. Tables with fields and relationships between tables
D. Sorting check boxes

Answer: B

5. In a database table, the category of information is called

A. tuple
B. field
C. record
D. All of above

Answer: B

6. To create a new table, in which method you don’t need to specify the field type and size?

A. Create table in Design View
B. Create Table using wizard
C. Create Table by Entering data
D. All of above

Answer: C

Microsoft Word Processing Multiple Choice Question Click Here

7. Which of the following is not a database object?

A. Tables
B. Queries
C. Relationships
D. Reports

Answer: C

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

A. A relationship is created
B. Edit relationship dialog box appears
C. Error occurs
D. Nothing happens

Answer: B

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

A. Create table in Design View
B. Create Table using wizard
C. Create Table by Entering data
D. None of above

Answer: B

10. A database language concerned with the definition of the whole database structure and schema is

A. DCL
B. DML
C. DDL
D. All of above

Answer: C

Leave a Reply

Your email address will not be published. Required fields are marked *