Question # 1

Which key is used to move form field to field in Table window of Datasheet view?

Choose an answer

Tab

Esc

Enter

Spacebar

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

Choose an answer

Datasheet

QBE

Relationship

Design

% f is used for

Choose an answer

Double

Float

Integer

Short

Which criteria can be used to find four-character name that starts with H?

Choose an answer

H*4

H?4

H???

H####

How many types of relationship can be used?

Choose an answer

2

3

4

5

Which of the following is true about a function call

Choose an answer

Stop the execution of the program

Transfer control to the called function

Transfer control to the main function

Resumes the execution of the program

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

The table columns describe the ?

Choose an answer

data type

actual data

unique name

all

Which does not improve data entry?

Choose an answer

Input masks

Validation rules

Indexing

Required fields

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

Choose an answer

row

field

table

data

A table with five fields has a degree of

Choose an answer

5

2

10

none

To select all records that begin with letters A through G

Choose an answer

<="G"

Like "G"

<> A

> A

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

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 data type can be used to define a field that consists on only numbers to be used in calculations?

Choose an answer

Text

Memo

Number

Date/Time

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

How many table views are available in Microsoft Access?

Choose an answer

4

3

2

1

Field properties are shown in :

Choose an answer

Design view

Datasheet view

A and B

None

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