Question # 1

The option allows you to build a new table by entering data directly into the datasheet.

Choose an answer

Data sheet view

Design view

Link table

None of the above

A collection of related records in data base is known as a.

Choose an answer

Table

Data base

File

None

What is the columns n Microsoft access table called.

Choose an answer

Rows

Record

Fields

Columns

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

It is an association established between common

Choose an answer

Line

Relationship

Primary key

Record

Which of the following statement is true.

Choose an answer

Reports can be used to return data from tables and calculate

Queries can be printed in well formatted manner any presented as the information

Queries can include calculated fields that do not exist in table.

Reports and form are similar but forms are use to print the report to display on screen only.

A search value can be an exact value or it can be.

Choose an answer

Logical operator

Relationship

Wild card character

Comparison operation

What is a form in MS Access

Choose an answer

It is a printed page where users will write their data to fill it up

It is an input screen designed to make the viewing and entering Data easier

This is an important part of Data Base used by analysis to draw conclusions

All of above

The form displays multiple records one per row in the form window

Choose an answer

Data sheet

Tabular

Columnar

Justified

Name of the fields field type and size

Choose an answer

Tables with fields and relationships between tables

Criteria

Sorting check boxes

What do you mean by one to many relationship between student and class table.

Choose an answer

One student can have many classes

One class may have many student

Many classes may have many student

Many students may have manu classes.

Which field tye can store phots.

Choose an answer

Hyper link

Ole

Both of these can be used

Access tables can't store photos

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

Choose an answer

forms

Reports

Queries

Tables

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

This data type allows alphanumeric characters and special symbols

Choose an answer

Text

Memo

Auto number

None of the above

If you make an invalid entry in the input mask wizard dialog box the will display to advise you that the entry is not coorect.

Choose an answer

Text eooro

Validation error

Literal error

Entry error

It is a query that when run displays its own dialog box prompting you for information such as.

Choose an answer

Select

Crosstab

Parameter

Append

A __ name must be unique within a data base.

Choose an answer

Table

Field

Record

Character

The ______ operator will cause record to be selected only if tow or more conditions are satisfied.

Choose an answer

Or

If Or

Range

And

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

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