Question # 1

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

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

Choose an answer

Data sheet

Tabular

Columnar

Justified

Which of the following statement is true.

Choose an answer

Foreign key field don't allow duplicate values.

In primary key field you can enter duplicate value

In an indexed field you may or may not enter duplicate value depending upon setting.

All statements are true

Following is not A data base model

Choose an answer

Network Data base model

Relational Data base model

Object oriented data base model

None

Which field type will you select when creating a new table if you require to enter long text in that field.

Choose an answer

Text

Memo

currency

Hyper link

The Data base language concerned with the definition of the whole Data base structure and scheme is

Choose an answer

DCL

DDL

DML

All 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

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

Choose an answer

Logical operator

Relationship

Wild card character

Comparison operation

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

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 operation of checking input data against specified criteria is known as.

Choose an answer

Data verification

Data validation

Cross check

Data control

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

A __ name must be unique within a data base.

Choose an answer

Table

Field

Record

Character

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

Which of the field has width 8 bytes.

Choose an answer

Memo

Number

Date/time

Hyper link

This form displays data in a table layout with field name labels across the top of the page and the core spending data in rows and columns under each heading.

Choose an answer

Comumnar

Justified

Data sheet

Tabular

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 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 of the following is Not A Data Base object.

Choose an answer

Tables

Queries

Relationships

Reports

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

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

Microsoft Access is A

Choose an answer

RDBMS

OODBMS

ORDBMS

Network Data base Model

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

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

Choose an answer

DCL

DML

DDL

None

To tables can be linked with relationship so that the data integrity can be enforced where can you fine relationship command.

Choose an answer

File menu

View menu

Data base menu

Tool menu

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