More Classes
5th Class
6th Class
7th Class
8th Class
9th Class
10th Class
11th Class
12th Class
NAT I
NAT II
CSS
IQ
General Knowledge
MDCAT
ECAT
GAT General
GAT Subject
Other Links
Go to Home
Online Tests
PPSC Computer Science Chapter 6 Microsoft Access Online Test MCQs With Answers
Question # 1
The button on the tool box display data from a related table
Choose an answer
Sub form sub report
Relationships
Select objects
More control
Previous
Skip
Next
Question # 2
In one -to-many relationship the table in one side is called _____ and on many side is called.
Choose an answer
Child , parent
Parent, child
Brother , sister
Father , son
Previous
Skip
Next
Question # 3
Which of the following database object can be used if you need to mail the invoice to customers.
Choose an answer
A form
A query
A report
A table
Previous
Skip
Next
Question # 4
It is most common type of query it retrieves records from one or more tables and then displays the.
Choose an answer
Parameter
Select
Crosstab
All of above
Previous
Skip
Next
Question # 5
Name of the fields field type and size
Choose an answer
Tables with fields and relationships between tables
Criteria
Sorting check boxes
Previous
Skip
Next
Question # 6
Queries in Access can be sued as.
Choose an answer
View, change and analyze data indifferent ways
A source of records for forms and reports
Only A
Both A and B
Previous
Skip
Next
Question # 7
What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table.
Choose an answer
A relationship is created
Edit relationship dialog box appears
Error occurs
Nothing happens
Previous
Skip
Next
Question # 8
To sort records in a table.
Choose an answer
Open table click on the field on which the sorting is to be done then click sort button on data base toolbar.
Open table click sort button on data base tool bar, choose field based on which to sort click ok
Click the field heading to sort it ascending or descending
All of above
Previous
Skip
Next
Question # 9
The two form layout types will display multiple records at one time are tabular and.
Choose an answer
Columnar
Justified
Data sheet
Pivot table
Previous
Skip
Next
Question # 10
To create queries in Access
Choose an answer
You can drag and drop fields on query builders.
You can type the Sl command in Sl view
You can query wizard or design view
All above
Previous
Skip
Next
Question # 11
Which of the following is Not A Data Base object.
Choose an answer
Tables
Queries
Relationships
Reports
Previous
Skip
Next
Question # 12
Which of the following statement is true.
Choose an answer
Foreign key field don't allow duplicate values.
In primary key field you can enter duplicate value
In an indexed field you may or may not enter duplicate value depending upon setting.
All statements are true
Previous
Skip
Next
Question # 13
While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into.
Choose an answer
A doctor's sign
Thin + Sign
Outline rectangle
None
Previous
Skip
Next
Question # 14
Which of the following is not a type or relationship that can be applied in Access data base.
Choose an answer
One to one
One to many
Many to Many
All of above
Previous
Skip
Next
Question # 15
What are the different views to display A table.
Choose an answer
Datasheet view
Design view
Pivote table and pivot chart view
All of above
Previous
Skip
Next
Question # 16
Some rules are set in databases to check and permit only correct values What is the feature called.
Choose an answer
Data verification
Auditing
Data filtering
Data validation
Previous
Skip
Next
Question # 17
In table design view what are the first column of buttons used for
Choose an answer
Indicate primary key
Indicate current row
Both of above
None
Previous
Skip
Next
Question # 18
What is the columns n Microsoft access table called.
Choose an answer
Rows
Record
Fields
Columns
Previous
Skip
Next
Question # 19
When creating a new able which method can be used to choose field from standard data bases and tables.
Choose an answer
Create table in design view
Create table using wizard
Create table by entering data
None
Previous
Skip
Next
Question # 20
The expression builder is an access tool that controls an expression ____ for entering an expression.
Choose an answer
Table
Box
cell
palette
Previous
Skip
Next
Back