Question # 1

Which of the following data base object hold data.

Choose an answer

Forms

Report

Queries

Tables

How can you define a field so that when entering data for that field it will display instead of actual typed text.

Choose an answer

input Mask

Validation rule

Indexed

IME mode

A__ enables you to view Data Base A table based on a specific criterion

Choose an answer

Form

Query

Macro

Report

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

If you write criteria values vertically it will mean

Choose an answer

OR Conditions

AND Conditions

NOT condition

None

The key uniquely identifies each record in a table

Choose an answer

Primary key

Key word

Field name

All above

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

The filter by selection allows you to filter those records

Choose an answer

That match the selected field

That match the criteria specified

That meet any of several criteria specified

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

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

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

Choose an answer

OR

IN

LIKE

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

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

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

Choose an answer

Table

Data base

File

None

What is the maximum length A text field Can be.

Choose an answer

120

255

265

75

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

In A data base table The category of information is called _______

Choose an answer

Tuple

Field

Record

All above

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

Choose an answer

Sub form sub report

Relationships

Select objects

More control

Which of the following is not a field type in access

Choose an answer

Memo

Hyper link

Oie object

Look up Wizard

Which of the following database object can be used if you need to mail the invoice to customers.

Choose an answer

A form

A query

A report

A table

Which field tye can store phots.

Choose an answer

Hyper link

Ole

Both of these can be used

Access tables can't store photos

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