Question # 1

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

Choose an answer

OR

IN

LIKE

AND

Which field tye can store phots.

Choose an answer

Hyper link

Ole

Both of these can be used

Access tables can't store photos

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

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

This data type allows alphanumeric characters and special symbols

Choose an answer

Text

Memo

Auto number

None of the 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

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

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

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

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

Choose an answer

Data sheet

Tabular

Columnar

Justified

This type of data base contains multiple tables that are connected to produce combined output from all tables.

Choose an answer

Bound

Relational

Linked

Joined

The operation of checking input data against specified criteria is known as.

Choose an answer

Data verification

Data validation

Cross check

Data control

Which of the following data base object hold data.

Choose an answer

Forms

Report

Queries

Tables

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

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

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

This key Uniquely identifies each record.

Choose an answer

Primary key

Key Record

Unique key

Field name

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

Microsoft Access is A

Choose an answer

RDBMS

OODBMS

ORDBMS

Network Data base Model

Which of the following database object is created first before any other created

Choose an answer

Table

Form

Report

Query

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