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
