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

You can automatically include all of the field in a table in a query by_____ a strike that appear list box in query design view.

Choose an answer

Clicking

Right clicking

Double clicking

None of above

The key uniquely identifies each record in a table

Choose an answer

Primary key

Key word

Field name

All above

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

Choose an answer

Tuple

Field

Record

All above

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

Choose an answer

forms

Reports

Queries

Tables

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

Choose an answer

60

64

68

Any number of character

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

A search value can be an exact value or it can be.

Choose an answer

Logical operator

Relationship

Wild card character

Comparison operation

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

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

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

Choose an answer

Hyper link

Ole

Both of these can be used

Access tables can't store photos

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

Which of the following is not a field type in access

Choose an answer

Memo

Hyper link

Oie object

Look up Wizard

How can you define a field so that when entering data for that field it will display instead of actual typed text.

Choose an answer

input Mask

Validation rule

Indexed

IME mode

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

Choose an answer

Table

Data base

File

None

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

Which of the field has width 8 bytes.

Choose an answer

Memo

Number

Date/time

Hyper link

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

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

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

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