Question # 1

A __ name must be unique within a data base.

Choose an answer

Table

Field

Record

Character

The expression builder is an access tool that controls an expression ____ for entering an expression.

Choose an answer

Table

Box

cell

palette

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

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

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

Which of the following data base object hold data.

Choose an answer

Forms

Report

Queries

Tables

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

Choose an answer

DCL

DML

DDL

None

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

Choose an answer

Transparent

Invisible

Dot not display

No border

The default and maximum size of text field in access.

Choose an answer

50 and 255 characters

8 and 1 GB

266 Characters and 64000 characters.

None

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

Name of the fields field type and size

Choose an answer

Tables with fields and relationships between tables

Criteria

Sorting check boxes

It is most common type of query it retrieves records from one or more tables and then displays the.

Choose an answer

Parameter

Select

Crosstab

All of above

To sort records in a table.

Choose an answer

Open table click on the field on which the sorting is to be done then click sort button on data base toolbar.

Open table click sort button on data base tool bar, choose field based on which to sort click ok

Click the field heading to sort it ascending or descending

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

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

The ______ operator will cause record to be selected only if tow or more conditions are satisfied.

Choose an answer

Or

If Or

Range

And

Which of the field has width 8 bytes.

Choose an answer

Memo

Number

Date/time

Hyper link

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.

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

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