Question # 1

The key uniquely identifies each record in a table

Choose an answer

Primary key

Key word

Field name

All above

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.

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

Which of the following data base object produce the final result to present.

Choose an answer

forms

Reports

Queries

Tables

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

The two form layout types will display multiple records at one time are tabular and.

Choose an answer

Columnar

Justified

Data sheet

Pivot table

A __ name must be unique within a data base.

Choose an answer

Table

Field

Record

Character

To duplicate a controls formatting you can use.

Choose an answer

Manager

Wizard

Painter

Control

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

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

The size of yes no field is always

Choose an answer

1 bit

1 byte

1 GB

1 Character

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

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

Choose an answer

Table

Box

cell

palette

What do you mean by one to many relationship between student and class table.

Choose an answer

One student can have many classes

One class may have many student

Many classes may have many student

Many students may have manu classes.

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

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

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