PPSC Computer Science Topic 6 MCQ's Test Preparation

Microsoft Access is a powerful database management system that is included in the popular Office suite provided by Microsoft. Using this application, both novices and professionals can create databases and handle them with the seamless Graphical User Interface. Professionals need to have a complete grasp of Microsoft access to perform well in the office environment. However, the importance of this application is even great for the candidates who are applying in the PPSC exams. Microsoft Access is present in the outline of the PPSC Computer Science paper. By taking our free PPSC online test, you can study and prepare yourself for Microsoft Access in no time.

Why Choose Free PPSC MCQ's Test by IlmKiDunya

Our team at IlmKiDunya is working hard to create PPSC Online tests that help candidates prepare efficiently without paying any fees at all. Start your learning process right now by starting the free PPSC online test and get ready for the upcoming exams!

MCQ's Test For PPSC Computer Science Topic 6 Microsoft Access

Try The MCQ's Test For PPSC Computer Science Topic 6 Microsoft Access

  • Total Questions20

  • Time Allowed20

Start Test Download PDF

PPSC Computer Science Topic 6 Microsoft Access

00:00
Question # 1

It is sign or symbol that specifies operator and values that product a result.

Question # 2

To sort records in a table.

Question # 3

What is the maximum length A text field Can be.

Question # 4

Both condition display on the same row in the design grid when ____ operator is in use.

Question # 5

How can you define a field so that when entering data for that field it will display instead of actual typed text.

Question # 6

What is a form in MS Access

Question # 7

In one -to-many relationship the table in one side is called _____ and on many side is called.

Question # 8

If you write criteria values vertically it will mean

Question # 9

Which of the following is not a field type in access

Question # 10

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

Question # 11

It is a query that when run displays its own dialog box prompting you for information such as.

Question # 12

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

Question # 13

To create a new table in which method you don't need to specify the field type and size.

Question # 14

A small button with three dots usually displayed at the right of field properties box.

Question # 15

Following is not A data base model

Question # 16

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

Question # 17

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

Question # 18

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.

Question # 19

Which of the following statement is true.

Question # 20

To duplicate a controls formatting you can use.

Submit

Prepare Complete Set Wise PPSC Computer Science Topic 6 Microsoft Access MCQs Online With Answers


Top Scorers Of PPSC Computer Science Topic 6 Microsoft Access MCQ`s Test

  • A
    Arshad Mehmood 21 - Jun - 2024 04 Min 39 Sec 18/20
  • S
    Sana Rasheed 28 - Jan - 2022 05 Min 53 Sec 15/20
  • P
    palace dream 21 - Jan - 2022 03 Min 02 Sec 14/20
  • A
    Aisha Tariq khan 29 - Dec - 2021 03 Min 14 Sec 13/20
  • Y
    younis masih 31 - May - 2024 04 Min 11 Sec 13/20
  • A
    Abdur Rehman Riaz 03 - Sep - 2024 08 Min 45 Sec 13/20
  • R
    Rimsha Habib 12 - Dec - 2021 02 Min 21 Sec 12/20
  • Z
    Zunera Ameen 23 - Dec - 2021 06 Min 02 Sec 12/20
  • W
    Waqar Ahmed 26 - Jun - 2024 06 Min 19 Sec 12/20
  • G
    ggdc kk 24 - May - 2024 10 Min 09 Sec 12/20
  • A
    ars 06 - Jan - 2021 10 Min 22 Sec 11/20
  • A
    Arooj Safdar 16 - Jun - 2022 03 Min 49 Sec 10/20
  • Z
    Zunaisha Khan 23 - Jun - 2024 04 Min 41 Sec 9/20
  • S
    Shaista Naseem 27 - Jun - 2024 07 Min 43 Sec 9/20
  • K
    Kasur City 18 - Apr - 2024 08 Min 04 Sec 9/20
Sr. # Question Answer
1 This key Uniquely identifies each record.

A. Primary key

B. Key Record

C.Unique key

D. Field name

2 DCL provides commands to perform actions like

A. Change the structure of tables

B. Insert update or delete records and data values

C.Authorizing access and other control over data base

D. None

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

A. A doctor's sign

B. Thin + Sign

C.Outline rectangle

D. None

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

A. One student can have many classes

B. One class may have many student

C.Many classes may have many student

D. Many students may have manu classes.

5 Which of the following is not a field type in access

A. Memo

B. Hyper link

C.Oie object

D. Look up Wizard

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

A. Table

B. Data base

C.File

D. None

7 What is the columns n Microsoft access table called.

A. Rows

B. Record

C.Fields

D. Columns

8 Following is not A data base model

A. Network Data base model

B. Relational Data base model

C.Object oriented data base model

D. None

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

A. Database window

B. Query Window

C.Design view window

D. Switch board

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

A. Columnar

B. Justified

C.Data sheet

D. Pivot table

11 This form display the field name labels down the left side of the column with the data for each field just to the right of its corresponding label.

A. Tabular

B. Justified

C.Columnar

D. Data sheet

12 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.

A. Text eooro

B. Validation error

C.Literal error

D. Entry error

13 Which of the following statement is true.

A. Reports can be used to return data from tables and calculate

B. Queries can be printed in well formatted manner any presented as the information

C.Queries can include calculated fields that do not exist in table.

D. Reports and form are similar but forms are use to print the report to display on screen only.

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

A. Sorting

B. Searching

C.Arranging

D. cropping

15 Which of the following data base object hold data.

A. Forms

B. Report

C.Queries

D. Tables

16 To create a new table in which method you don't need to specify the field type and size.

A. Create table in design view

B. Create table using wizard

C.Create table by entering data

D. All of above

17 Some rules are set in databases to check and permit only correct values What is the feature called.

A. Data verification

B. Auditing

C.Data filtering

D. Data validation

18 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.

A. Comumnar

B. Justified

C.Data sheet

D. Tabular

19 The Data base language concerned with the definition of the whole Data base structure and scheme is

A. DCL

B. DDL

C.DML

D. All above

20 Name of the fields field type and size

A. Tables with fields and relationships between tables

B. Criteria

C.Sorting check boxes

Test Questions

Is this page helpful?