It is an association established between common fields of two tables.
A. line
B. relationship
C. primary key
D. records
Microsoft Access MCQS
Microsoft Access MCQS Microsoft Access 2007, Microsoft Access 2009 MCQS, Microsoft Access 2013 MCQS Microsoft Access 2016 MCQS, Microsoft Access 2017 MCQS. All MS Access MCQS, MS Access Design, MS Access Page layout MCQS, MS Access Best MCQS, MS Access Online MCQS MS Access Pages, MS Access toolbar mcqs, MS Access Queries MCQS, MS Access RDBMS MCQS, MS Access Database. best of Microsoft Access mcqs for FPSC exams preparation BPSC exams preparation PPSC exams preparation SPSC exams preparation KPPSC exams preparation NTS tests preparation OTS tests preparation CTS tests preparation PTS tests preparation BTS tests preparation CTSP tests preparation
A __ name must be unique within a database
A. Table
B. Field
C. Record
D. Character
Referential integrity means in MS Access
A. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
B. Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table
C. Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table
D. All of above
The database language that allows you to access or maintain data in a database
A. DCL
B. DML
C. DDL
D. None of above
You can set a controls border type to make the border invisible.
A. Transparent
B. Invisible
C. Do not display
D. No border
Cascade update option in Microsoft Access
A. means do not change the value in the primary key field if that record has related records in another table
B. means change all the related records in child tables if the record in the parent table is changed
C. Both of above
D. None of above
The default and maximum size of text field in Access
A. 50 and 255 Characters
B. 8 and 1 GB
C. 266 characters & 64000 characters
D. None of above
Which of the following database object produces the final result to present?
A. Forms
B. Reports
C. Queries
D. Tables
A search value can be an exact value or it can be
A. Logical Operator
B. Relationship
C. Wild card character
D. Comparison operation
To achieve AND effect when you are entering criteria in a query design window
A. write criteria values vertically one in a row
B. write criteria values horizontally
C. Write criteria values in the same field separated with AND
D. Write criteria values in the same field separated with &