Question # 1

Which of the following view in MS Access is used to define the structure of table?

Choose an answer

Datasheet

QBE

Relationship

Design

How many types of relationship can be used?

Choose an answer

2

3

4

5

Which of the following is NOT suitable for an input mask?

Choose an answer

Street address

Telephone number

A date

Social security number

Which of the following methods are used for creating a table in Access?

Choose an answer

Creating table in Design view

Creating table by using wizard

Creating table by entering data

All

All numbers greater than 0 and less than 100

Choose an answer

< 0 and > = 100

> 0 and < = 100

< > 100

> = 1

Field properties are shown in :

Choose an answer

Design view

Datasheet view

A and B

None

In C program two functions can have

Choose an answer

Same name

Same parameters

Same name & parameters

Same name but different parameters

Which of the following is logical data type in MS Access?

Choose an answer

Boolean

Yes/No

True/false

Log

Every field in a table has:

Choose an answer

Field name and data type

field name and a field number

Field number and a data type

Field name, field number, and data type

Which of the following is NOT displayed in Design view?

Choose an answer

The data type of each field

The components of each filed

The properties of the selected field

The field names

Each of the following is an example of a valid Access data type EXCEPT:

Choose an answer

Memo

Currency

Name

Text

Which of the following looks for the prototypes of functions used in a program

Choose an answer

Linker

Loader

Compiler

Parser

Which data type can be used to define a field that consists of a maximum of 255 numbers or letters?

Choose an answer

Text

Memo

Number

Currency

A record is a ------------------- in table

Choose an answer

row

field

table

data

If for each entity in B there is only one related entity in A then the relationship between the entities is

Choose an answer

One to one

One to many

Many to many

None

What symbol indicates that you are editing a record?

Choose an answer

Pencil

Black arrow

Key

Asterisk

Which format property displays text in uppercase?

Choose an answer

Greater than sign

Less than sign

TEXT

Upper

Which of the following menus is used to switch between table views?

Choose an answer

Edit

File

Tools

View

Which data type is the default type?

Choose an answer

Memo

Number

Text

Autonumber

The name cannot exceed characters in length

Choose an answer

64

50

56

70

How many table views are available in Microsoft Access?

Choose an answer

4

3

2

1

To select all records that begin with letters A through G

Choose an answer

<="G"

Like "G"

<> A

> A

Which of the following is New record button in MS Access?

Choose an answer

*

$

#

|

More Classes

Other Links

ICS Part 2 Computer Science Chapter 6 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

Choose an answer

Choose an answer