Question # 1

Data base access levels are specified so as to define who can access what ina data base it is identified through.

Choose an answer

User ID

Passwords

Status

None

Which of the following creates A drop down list of values to choose from.

Choose an answer

Ole object

Hyper link

Memo

Lockup Wizard

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

The third stage in Designing A database is when We analyze our tables more closely and create a _________ between tables.

Choose an answer

Relationship

Join

Query

None

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

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

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

Choose an answer

Or

If Or

Range

And

Microsoft Access is A

Choose an answer

RDBMS

OODBMS

ORDBMS

Network Data base Model

Some rules are set in databases to check and permit only correct values What is the feature called.

Choose an answer

Data verification

Auditing

Data filtering

Data validation

Both condition display on the same row in the design grid when ____ operator is in use.

Choose an answer

OR

IN

LIKE

AND

Which of the field has width 8 bytes.

Choose an answer

Memo

Number

Date/time

Hyper link

This is the stage in Data base design where one Gathers and list all the necessary field for the data base project.

Choose an answer

Data definition

Data refinement

Establishing Relationship

None of the above

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

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

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

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 expression builder is an access tool that controls an expression ____ for entering an expression.

Choose an answer

Table

Box

cell

palette

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

Following is not A data base model

Choose an answer

Network Data base model

Relational Data base model

Object oriented data base model

None

If you write criteria values vertically it will mean

Choose an answer

OR Conditions

AND Conditions

NOT condition

None

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

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 field tye can store phots.

Choose an answer

Hyper link

Ole

Both of these can be used

Access tables can't store photos

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

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

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

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer