While creating a relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
A. a doctor’s sign
B. thin + sign
C. outline rectangle
D. None of above
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
Queries in Access can be used as
A. view, change and analyze data in different ways
B. a source of records for forms and reports
C. Only A
D. Both A and B
Which field type can store photos?
A. Hyperlink
B. OLE (Object Linking and Embedding)
C. Both of these can be used
D. Access tables can’t store photos
The___ operator will cause a record to be selected only if two or more conditions are satisfied
A. Or
B. If or
C. Range
D. And
Data Control List (DCL) provides commands to perform actions like
A. Change the structure of the tables
B. authorizing access and other control over the database
C. insert, update or delete records and data values
D. None of above
If you need to edit a relationship in MS Access
A. Right-click the relationship line and choose Edit Relationship
B. Double click the relationship line
C. Both of above
D. None of above
Microsoft Access is a
A. RDBMS
B. OODBMS
C. ORDBMS
D. Network database model
Which of the following statement is true?
A. Foreign key fields don’t allow duplicate values
B. In the primary key field, you can enter a duplicate value
C. In an indexed field, you may or may not enter duplicate value depending upon the setting
D. All statements are true
What is the maximum length a text field can be?
A. 120
B. 255
C. 265
D. 75
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
A. Parameter
B. Select
C. crosstab
D. Append