Question # 1

Which of the field has width 8 bytes.

Choose an answer

Memo

Number

Date/time

Hyper link

This form displays data in a table layout with field name labels across the top of the page and the core spending data in rows and columns under each heading.

Choose an answer

Comumnar

Justified

Data sheet

Tabular

This form display 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.

Choose an answer

Tabular

Justified

Columnar

Data sheet

The operation of checking input data against specified criteria is known as.

Choose an answer

Data verification

Data validation

Cross check

Data control

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

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

This data type allows alphanumeric characters and special symbols

Choose an answer

Text

Memo

Auto number

None of the above

You can automatically include all of the field in a table in a query by_____ a strike that appear list box in query design view.

Choose an answer

Clicking

Right clicking

Double clicking

None of above

Microsoft Access is A

Choose an answer

RDBMS

OODBMS

ORDBMS

Network Data base Model

Which of the following data base object hold data.

Choose an answer

Forms

Report

Queries

Tables

What is the maximum length A text field Can be.

Choose an answer

120

255

265

75

If you write criteria values vertically it will mean

Choose an answer

OR Conditions

AND Conditions

NOT condition

None

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

Which of the following is Not A Data Base object.

Choose an answer

Tables

Queries

Relationships

Reports

In table design view which key can be used to switch between the field names and properties panels.

Choose an answer

F3

F4

F5

F6

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

It is sign or symbol that specifies operator and values that product a result.

Choose an answer

Operator

Query

Expression

None of the above

DCL provides commands to perform actions like

Choose an answer

Change the structure of tables

Insert update or delete records and data values

Authorizing access and other control over data base

None

Which of the following is Not A type of Microsoft access Data base object.

Choose an answer

Table

Form

Worksheets

Modules

Which field type will you select when creating a new table if you require to enter long text in that field.

Choose an answer

Text

Memo

currency

Hyper link

Which of the following data base object produce the final result to present.

Choose an answer

forms

Reports

Queries

Tables

More Classes

Other Links

PPSC Computer Science Chapter 6 Microsoft Access Online Test MCQs With Answers

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer