Question # 1

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

Which of the following is Not A Data Base object.

Choose an answer

Tables

Queries

Relationships

Reports

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

Which of the following is not a field type in access

Choose an answer

Memo

Hyper link

Oie object

Look up Wizard

The button on the tool box display data from a related table

Choose an answer

Sub form sub report

Relationships

Select objects

More control

In access this displays the result of a calculation in query

Choose an answer

Lookup field

Calculated field

Source field

child field

The operation of checking input data against specified criteria is known as.

Choose an answer

Data verification

Data validation

Cross check

Data control

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

This key Uniquely identifies each record.

Choose an answer

Primary key

Key Record

Unique key

Field name

It is sign or symbol that specifies operator and values that product a result.

Choose an answer

Operator

Query

Expression

None of the above

The key uniquely identifies each record in a table

Choose an answer

Primary key

Key word

Field name

All above

The size of yes no field is always

Choose an answer

1 bit

1 byte

1 GB

1 Character

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

Which of the following data base object hold data.

Choose an answer

Forms

Report

Queries

Tables

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

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.

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

Name of the fields field type and size

Choose an answer

Tables with fields and relationships between tables

Criteria

Sorting check boxes

To duplicate a controls formatting you can use.

Choose an answer

Manager

Wizard

Painter

Control

It is an association established between common

Choose an answer

Line

Relationship

Primary key

Record

Which of the following database object can be used if you need to mail the invoice to customers.

Choose an answer

A form

A query

A report

A table

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