Question # 1

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

Choose an answer

Memo

Currency

Name

Text

Why are validation rules used in a database?

Choose an answer

Ensure correct data is entered

To avoid typing errors

Both A and B

Neither A nor B

Which of the following view in MS Access looks like an electronic spreadsheet?

Choose an answer

Datasheet

QBE

Relationship

Design

The data in tables is entered in:

Choose an answer

Design view

Normal view

Datasheet view

Layout view

The name of actual and formal parameters

Choose an answer

May or may not be same

Must be same

Must be different

Must be in lowercase

How many table views are available in Microsoft Access?

Choose an answer

4

3

2

1

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

To select all records that begin with letters A through G

Choose an answer

<="G"

Like "G"

<> A

> A

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

Choose an answer

row

field

table

data

Dummy question 2

Choose an answer

a

2

b

f

All numbers greater than 0 and less than 100

Choose an answer

< 0 and > = 100

> 0 and < = 100

< > 100

> = 1

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

Choose an answer

Street address

Telephone number

A date

Social security number

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

The table columns describe the ?

Choose an answer

data type

actual data

unique name

all

Which view is used to add, edit or delete records form a table?

Choose an answer

Record view

Datasheet view

Design view

Edit view

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

Field properties are shown in :

Choose an answer

Design view

Datasheet view

A and B

None

Which of the following can be found in an MS Access database file?

Choose an answer

Tables

Forms

Queries

All

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

Choose an answer

Edit

File

Tools

View

Which rule states that a record form a table cannot be deleted if its associated record exists in related table?

Choose an answer

Referential integrity

Entity relationship

Normalization

All

What symbol indicates that you are editing a record?

Choose an answer

Pencil

Black arrow

Key

Asterisk

The name cannot exceed characters in length

Choose an answer

64

50

56

70

What is the default field size of a text data type field?

Choose an answer

2

5

20

50

More Classes

Other Links

Computer Science Ics Part 2 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