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

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

Question # 2

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

Question # 3

Which of the field has width 8 bytes.

Question # 4

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

Question # 5

The default and maximum size of text field in access.

Question # 6

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

Question # 7

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

Question # 8

The size of yes no field is always

Question # 9

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

Question # 10

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

Question # 11

This is the stage in Data base design where one Gathers and list all the necessary field for the data base project.

Question # 12

Queries in Access can be sued as.

Question # 13

You can set a controls border type to make the border invisible

Question # 14

In access this displays the result of a calculation in query

Question # 15

If you write criteria values vertically it will mean

Question # 16

When creating an input mask this character does not require an entry but if an entry is made it must be a letter from A-Z

Question # 17

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

Question # 18

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

Question # 19

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.

Question # 20

In table design view what are the first column of buttons used for

Submit

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


Topic Test

00:00
Submit

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

PPSC ComputerScience Chapter 6 Important MCQ's

Sr.# Question Answer
1 Which of the following is Not A Data Base object.
A. Tables
B. Queries
C. Relationships
D. Reports
2 The default and maximum size of text field in access.
A. 50 and 255 characters
B. 8 and 1 GB
C. 266 Characters and 64000 characters.
D. None
3 It is used to calculate and restructure data for easier analysis of your data it calculates the sum.
A. Parameter
B. Select
C. cross tab
D. Append
4 A search value can be an exact value or it can be.
A. Logical operator
B. Relationship
C. Wild card character
D. Comparison operation
5 In one -to-many relationship the table in one side is called _____ and on many side is called.
A. Child , parent
B. Parent, child
C. Brother , sister
D. Father , son
6 The filter by selection allows you to filter those records
A. That match the selected field
B. That match the criteria specified
C. That meet any of several criteria specified
D. All of above
7 Which field type will you select when creating a new table if you require to enter long text in that field.
A. Text
B. Memo
C. currency
D. Hyper link
8 The ______ operator will cause record to be selected only if tow or more conditions are satisfied.
A. Or
B. If Or
C. Range
D. And
9 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.
10 This data type allows alphanumeric characters and special symbols
A. Text
B. Memo
C. Auto number
D. None of the above

Test Questions

Is this page helpful?