Question # 1

In access this displays the result of a calculation in query

Choose an answer

Lookup field

Calculated field

Source field

child field

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

Unlike text data type this can store up to maximum of 65,535, characters.

Choose an answer

Query

Form

Report

None of the above

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

Choose an answer

Operator

Query

Expression

None of the above

The command center of access file that appears when you create or open the MS access database file.

Choose an answer

Database window

Query Window

Design view window

Switch board

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

Choose an answer

60

64

68

Any number of character

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

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

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

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

In access this operation copies a backup file from the storage medium back on to the computer.

Choose an answer

Recreate

Restore

Copy

Structure

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

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.

This key Uniquely identifies each record.

Choose an answer

Primary key

Key Record

Unique key

Field name

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

Choose an answer

Data sheet

Tabular

Columnar

Justified

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

To duplicate a controls formatting you can use.

Choose an answer

Manager

Wizard

Painter

Control

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

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

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

Choose an answer

Logical operator

Relationship

Wild card character

Comparison operation

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