Question # 1

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 is Not A type of Microsoft access Data base object.

Choose an answer

Table

Form

Worksheets

Modules

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

What is the maximum length A text field Can be.

Choose an answer

120

255

265

75

Following is not A data base model

Choose an answer

Network Data base model

Relational Data base model

Object oriented data base model

None

To create this you enter an expression in the design grid that instructs access to perform a calculation using the current field values.

Choose an answer

formulated field

Numeric field

Formula field

Calculated field

What does the show check box in query design windows indicate.

Choose an answer

If indicates whether the field is to be sued or not.

It indicates whether the field is to be displayed in Query result or not.

It indicates whether the field names to be displayed in query result or not.

None

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

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

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

Choose an answer

Operator

Query

Expression

None of the above

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

Choose an answer

Table

Data base

File

None

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

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

When entering fields Name How many characters you can type in maximum.

Choose an answer

60

64

68

Any number of character

In access this displays the result of a calculation in query

Choose an answer

Lookup field

Calculated field

Source field

child field

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

It is used to calculate and restructure data for easier analysis of your data it calculates the sum.

Choose an answer

Parameter

Select

cross tab

Append

The expression builder is an access tool that controls an expression ____ for entering an expression.

Choose an answer

Table

Box

cell

palette

When creating an input mask this character does not require an entry but if an entry is made it must be a letter from A-Z

Choose an answer

?

!

\@

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