Question # 1

Data base access levels are specified so as to define who can access what ina data base it is identified through.

Choose an answer

User ID

Passwords

Status

None

Unlike text data type this can store up to maximum of 65,535, characters.

Choose an answer

Query

Form

Report

None of the above

Which of the following is not a field type in access

Choose an answer

Memo

Hyper link

Oie object

Look up Wizard

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

The expression builder is an access tool that controls an expression ____ for entering an expression.

Choose an answer

Table

Box

cell

palette

Which of the following database object can be used if you need to mail the invoice to customers.

Choose an answer

A form

A query

A report

A table

Which of the following creates A drop down list of values to choose from.

Choose an answer

Ole object

Hyper link

Memo

Lockup Wizard

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

Following is not A data base model

Choose an answer

Network Data base model

Relational Data base model

Object oriented data base model

None

Which of the following statement is true.

Choose an answer

Foreign key field don't allow duplicate values.

In primary key field you can enter duplicate value

In an indexed field you may or may not enter duplicate value depending upon setting.

All statements are true

The command center of access file that appears when you create or open the MS access database file.

Choose an answer

Database window

Query Window

Design view window

Switch board

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

To create this you enter an expression in the design grid that instructs access to perform a calculation using the current field values.

Choose an answer

formulated field

Numeric field

Formula field

Calculated field

What it is called to present information in a particular order based on numeric or alphabetical value.

Choose an answer

Sorting

Searching

Arranging

cropping

The form displays multiple records one per row in the form window

Choose an answer

Data sheet

Tabular

Columnar

Justified

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

Choose an answer

Table

Data base

File

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

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

The filter by selection allows you to filter those records

Choose an answer

That match the selected field

That match the criteria specified

That meet any of several criteria specified

All of 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

DCL provides commands to perform actions like

Choose an answer

Change the structure of tables

Insert update or delete records and data values

Authorizing access and other control over data base

None

To duplicate a controls formatting you can use.

Choose an answer

Manager

Wizard

Painter

Control

This data type allows alphanumeric characters and special symbols

Choose an answer

Text

Memo

Auto number

None of the 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

The size of the field with number data type can not be.

Choose an answer

2

4

8

16

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