Below are the Computer MCQs for PPSC Papers MCQs:
Microsoft Access MCQs:
1➤ We can remove a relationship defined between two tables by
ⓑ Select the relationship line and press Delete
ⓒ Choose Delete option from Relationship menu
ⓓ All of above
2➤ If you need to edit a relationship
ⓑ Double click the relationship line
ⓒ Both of above
ⓓ None of these
3➤ If you write criteria values vertically (one in a row) it will mean
ⓑ AND conditions
ⓒ NOT condition
ⓓ None of these
4➤ To achieve AND effect when you are entering criteria in a uery design window
ⓑ Write criteria values in same field separated with AND
ⓒ Write criteria values in same field separated with &
ⓓ none of these
5➤ A search value can be an exact value or it can be
ⓑ Relationship
ⓒ Wild card character
ⓓ Comparison operation
6➤ Both conditions display on the same row in the design grid when _ operator is in use
ⓑ IN
ⓒ LIKE
ⓓ AND
7➤ The two form layout types will display multiple records at one time are tabular and
ⓑ justified
ⓒ date sheet
ⓓ pivot table
8➤ You can automatically include all of the field in a table in a uery by a strike that appear list box in uery design view
ⓑ Right clicking
ⓒ Double clicking
ⓓ None of the above
9➤ The operator will cause a record to be selected only if two or more conditions are satisfied
ⓑ Range
ⓒ If or
ⓓ And
10➤ When a picture or other graphic image is placed in the report header section it will appear
ⓑ At the top of every page
ⓒ Every after record break
ⓓ On the 1st and last pages of the report
11➤ To duplicate a controls formatting you can use-------?
ⓑ Wizard
ⓒ Painter
ⓓ Control
12➤ The button on the tool box display data from a related table
ⓑ Relationships
ⓒ Select objects
ⓓ More controls
13➤ Which of the following database object can be used if you need to mail the invoice to customers?
ⓑ A very
ⓒ A report
ⓓ A Table
14➤ In Access, this displays the results of a calculation in a uery
ⓑ Calculated field
ⓒ Source field
ⓓ Child field
15➤ In Access, this operation copies a backup file from the storage medium back onto the computer
ⓑ Restore
ⓒ Copy
ⓓ Structure
16➤ If you make an invalid entry in the Input Mask Wizard dialog box, this will display to advise you that the entry is not correct
ⓑ Literal error
ⓒ Entry error
ⓓ Validation error
17➤ In the Form Wizard dialog box, the fields from the selected table are displayed in this list box.
ⓑ All Records
ⓒ Available Records
ⓓ Available Fields
18➤ This form displays the field name labels down the left side of the column, with the data for each field just to the right of its corresponding label.
ⓑ Justified
ⓒ Columnar
ⓓ Datasheet
19➤ This form displays data in a table layout with field name labels across the top of the page and the corresponding data in rows and columns under each heading.
ⓑ Justified
ⓒ Datasheet
ⓓ Tabular
20➤ This form displays multiple records, one per row, in the Form window
ⓑ Tabular
ⓒ Columnar
ⓓ Justified
21➤ DCL Provides Commands to Perform Actions Like
ⓑ Insert, Update Or Delete Records and Data Values
ⓒ Authorizing Access And Other Control Over Database
ⓓ None
22➤ The Database Language That Allows You To Access Or Maintain Data In A Database
ⓑ DML
ⓒ DDL
ⓓ None
23➤ What Is The Maximum Length A Text Field Can Be?
ⓑ 255
ⓒ 265
ⓓ 75
24➤ Which Of The Following Is Not A Database Object?
ⓑ ueries
ⓒ Relationships
ⓓ Reports
25➤ A Enables You To View Data From A Table Based On A Specific Criterion
ⓑ uery
ⓒ Macro
ⓓ Report
26➤ What Are The Columns In A Microsoft Access Table Called?
ⓑ Records
ⓒ Fields
ⓓ Columns
27➤ Which Of The Following Is Not A Type Of Microsoft Access Database Object?
ⓑ Form
ⓒ Worksheets
ⓓ Modules
28➤ Which of the following database object hold data?
ⓑ Reports
ⓒ Tables
ⓓ ueries
29➤ Which of the following database object produces the final result to present?
ⓑ Reports
ⓒ ueries
ⓓ Tables
30➤ What is the difference between 'open' and 'open exclusively'
ⓑ Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed
ⓒ Both open and open exclusively are same
ⓓ Open exclusive command does not exist in ms access
0 Comments