Question # 1

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

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 small button with three dots usually displayed at the right of field properties box.

Choose an answer

Make button

Expression button

Build button

None

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

?

!

\@

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

Choose an answer

Logical operator

Relationship

Wild card character

Comparison operation

To create a new table in which method you don't need to specify the field type and size.

Choose an answer

Create table in design view

Create table using wizard

Create table by entering data

All of above

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

Choose an answer

forms

Reports

Queries

Tables

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

Which of the following is method is create a new table in MS Access.

Choose an answer

Create table in design view

Create table using wizard

Create table by entering data

All of above

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

The size of yes no field is always

Choose an answer

1 bit

1 byte

1 GB

1 Character

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 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 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

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

Choose an answer

Table

Data base

File

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

The Data base language that allow you to access or maintain data in Data base.

Choose an answer

DCL

DML

DDL

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

The button on the tool box display data from a related table

Choose an answer

Sub form sub report

Relationships

Select objects

More control

What it is called to present information in a particular order based on numeric or alphabetical value.

Choose an answer

Sorting

Searching

Arranging

cropping

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