Question # 1

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

If you make an invalid entry in the input mask wizard dialog box the will display to advise you that the entry is not coorect.

Choose an answer

Text eooro

Validation error

Literal error

Entry error

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.

If you write criteria values vertically it will mean

Choose an answer

OR Conditions

AND Conditions

NOT condition

None

To sort records in a table.

Choose an answer

Open table click on the field on which the sorting is to be done then click sort button on data base toolbar.

Open table click sort button on data base tool bar, choose field based on which to sort click ok

Click the field heading to sort it ascending or descending

All of above

The two form layout types will display multiple records at one time are tabular and.

Choose an answer

Columnar

Justified

Data sheet

Pivot table

To create queries in Access

Choose an answer

You can drag and drop fields on query builders.

You can type the Sl command in Sl view

You can query wizard or design view

All above

The option allows you to build a new table by entering data directly into the datasheet.

Choose an answer

Data sheet view

Design view

Link table

None of the above

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

What is the columns n Microsoft access table called.

Choose an answer

Rows

Record

Fields

Columns

This data type allows alphanumeric characters and special symbols

Choose an answer

Text

Memo

Auto number

None of the above

What is the maximum length A text field Can be.

Choose an answer

120

255

265

75

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

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

Choose an answer

Data verification

Data validation

Cross check

Data control

The Data base language that allow you to access or maintain data in Data base.

Choose an answer

DCL

DML

DDL

None

Name of the fields field type and size

Choose an answer

Tables with fields and relationships between tables

Criteria

Sorting check boxes

Which of the following data base object hold data.

Choose an answer

Forms

Report

Queries

Tables

The third stage in Designing A database is when We analyze our tables more closely and create a _________ between tables.

Choose an answer

Relationship

Join

Query

None

What do you mean by one to many relationship between student and class table.

Choose an answer

One student can have many classes

One class may have many student

Many classes may have many student

Many students may have manu classes.

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

Choose an answer

60

64

68

Any number of character

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

In table design view which key can be used to switch between the field names and properties panels.

Choose an answer

F3

F4

F5

F6

While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into.

Choose an answer

A doctor's sign

Thin + Sign

Outline rectangle

None

When creating a new able which method can be used to choose field from standard data bases and tables.

Choose an answer

Create table in design view

Create table using wizard

Create table by entering data

None

This type of data base contains multiple tables that are connected to produce combined output from all tables.

Choose an answer

Bound

Relational

Linked

Joined

Which of the field has width 8 bytes.

Choose an answer

Memo

Number

Date/time

Hyper link

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

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer