Question # 1

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

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

What is the maximum length A text field Can be.

Choose an answer

120

255

265

75

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

Choose an answer

Sorting

Searching

Arranging

cropping

It is used to calculate and restructure data for easier analysis of your data it calculates the sum.

Choose an answer

Parameter

Select

cross tab

Append

Name of the fields field type and size

Choose an answer

Tables with fields and relationships between tables

Criteria

Sorting check boxes

The button on the tool box display data from a related table

Choose an answer

Sub form sub report

Relationships

Select objects

More control

It is an association established between common

Choose an answer

Line

Relationship

Primary key

Record

Which of the following data base object produce the final result to present.

Choose an answer

forms

Reports

Queries

Tables

In access this displays the result of a calculation in query

Choose an answer

Lookup field

Calculated field

Source field

child field

In A data base table The category of information is called _______

Choose an answer

Tuple

Field

Record

All above

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

Choose an answer

Ole object

Hyper link

Memo

Lockup Wizard

What is the columns n Microsoft access table called.

Choose an answer

Rows

Record

Fields

Columns

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

The ______ operator will cause record to be selected only if tow or more conditions are satisfied.

Choose an answer

Or

If Or

Range

And

Microsoft Access is A

Choose an answer

RDBMS

OODBMS

ORDBMS

Network Data base Model

What are the different views to display A table.

Choose an answer

Datasheet view

Design view

Pivote table and pivot chart view

All of above

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

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.

This form displays data in a table layout with field name labels across the top of the page and the core spending data in rows and columns under each heading.

Choose an answer

Comumnar

Justified

Data sheet

Tabular

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

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