Question # 1

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.

When creating an input mask this character does not require an entry but if an entry is made it must be a letter from A-Z

Choose an answer

?

!

\@

To duplicate a controls formatting you can use.

Choose an answer

Manager

Wizard

Painter

Control

The size of yes no field is always

Choose an answer

1 bit

1 byte

1 GB

1 Character

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

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

Choose an answer

Form

Query

Macro

Report

Queries in Access can be sued as.

Choose an answer

View, change and analyze data indifferent ways

A source of records for forms and reports

Only A

Both A and B

You can set a controls border type to make the border invisible

Choose an answer

Transparent

Invisible

Dot not display

No border

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

Choose an answer

forms

Reports

Queries

Tables

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 ______ operator will cause record to be selected only if tow or more conditions are satisfied.

Choose an answer

Or

If Or

Range

And

What it is called to present information in a particular order based on numeric or alphabetical value.

Choose an answer

Sorting

Searching

Arranging

cropping

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

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

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

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

Following is not A data base model

Choose an answer

Network Data base model

Relational Data base model

Object oriented data base model

None

This data type allows alphanumeric characters and special symbols

Choose an answer

Text

Memo

Auto number

None of the above

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 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 size of the field with number data type can not be.

Choose an answer

2

4

8

16

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