Question # 1

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 field tye can store phots.

Choose an answer

Hyper link

Ole

Both of these can be used

Access tables can't store photos

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

This form display the field name labels down the left side of the column with the data for each field just to the right of its corresponding label.

Choose an answer

Tabular

Justified

Columnar

Data sheet

When entering fields Name How many characters you can type in maximum.

Choose an answer

60

64

68

Any number of character

What is the maximum length A text field Can be.

Choose an answer

120

255

265

75

The key uniquely identifies each record in a table

Choose an answer

Primary key

Key word

Field name

All above

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

DCL provides commands to perform actions like

Choose an answer

Change the structure of tables

Insert update or delete records and data values

Authorizing access and other control over data base

None

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.

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

In access this displays the result of a calculation in query

Choose an answer

Lookup field

Calculated field

Source field

child field

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

Which of the following is Not A type of Microsoft access Data base object.

Choose an answer

Table

Form

Worksheets

Modules

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 of the following database object is created first before any other created

Choose an answer

Table

Form

Report

Query

Which of the following data base object hold data.

Choose an answer

Forms

Report

Queries

Tables

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

In access this operation copies a backup file from the storage medium back on to the computer.

Choose an answer

Recreate

Restore

Copy

Structure

Which of the following is not a type or relationship that can be applied in Access data base.

Choose an answer

One to one

One to many

Many to Many

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