Question # 1

In A data base table The category of information is called _______

Choose an answer

Tuple

Field

Record

All above

It is used to calculate and restructure data for easier analysis of your data it calculates the sum.

Choose an answer

Parameter

Select

cross tab

Append

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 Data base language that allow you to access or maintain data in Data base.

Choose an answer

DCL

DML

DDL

None

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

Choose an answer

Sorting

Searching

Arranging

cropping

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

Choose an answer

Or

If Or

Range

And

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

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

Data base access levels are specified so as to define who can access what ina data base it is identified through.

Choose an answer

User ID

Passwords

Status

None

Which of the following is Not A Data Base object.

Choose an answer

Tables

Queries

Relationships

Reports

Which of the following creates A drop down list of values to choose from.

Choose an answer

Ole object

Hyper link

Memo

Lockup Wizard

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

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

Choose an answer

Table

Box

cell

palette

The key uniquely identifies each record in a table

Choose an answer

Primary key

Key word

Field name

All above

A collection of related records in data base is known as a.

Choose an answer

Table

Data base

File

None

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

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.

A small button with three dots usually displayed at the right of field properties box.

Choose an answer

Make button

Expression button

Build button

None

The size of yes no field is always

Choose an answer

1 bit

1 byte

1 GB

1 Character

The filter by selection allows you to filter those records

Choose an answer

That match the selected field

That match the criteria specified

That meet any of several criteria specified

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

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