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

To duplicate a controls formatting you can use.

Question # 2

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

Question # 3

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

Question # 4

Which of the following data base object hold data.

Question # 5

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

Question # 6

Which of the following is method is create a new table in MS Access.

Question # 7

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

Question # 8

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

Question # 9

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

Question # 10

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

Question # 11

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

Question # 12

Which of the following statement is true.

Question # 13

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

Question # 14

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

Question # 15

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

Question # 16

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

Question # 17

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

Question # 18

What is a form in MS Access

Question # 19

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

Question # 20

It is most common type of query it retrieves records from one or more tables and then displays the.

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 What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table.
A. A relationship is created
B. Edit relationship dialog box appears
C. Error occurs
D. Nothing happens
2 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
3 You can set a controls border type to make the border invisible
A. Transparent
B. Invisible
C.
Dot not display
D. No border
4 This type of data base contains multiple tables that are connected to produce combined output from all tables.
A. Bound
B. Relational
C. Linked
D. Joined
5 A small button with three dots usually displayed at the right of field properties box.
A. Make button
B. Expression button
C. Build button
D. None
6 What is a form in MS Access
A. It is a printed page where users will write their data to fill it up
B. It is an input screen designed to make the viewing and entering Data easier
C. This is an important part of Data Base used by analysis to draw conclusions
D. All of above
7 The button on the tool box display data from a related table
A. Sub form sub report
B. Relationships
C. Select objects
D. More control
8 Which of the following statement is true.
A. Foreign key field don't allow duplicate values.
B. In primary key field you can enter duplicate value
C. In an indexed field you may or may not enter duplicate value depending upon setting.
D. All statements are true
9 To create queries in Access
A. You can drag and drop fields on query builders.
B. You can type the Sl command in Sl view
C. You can query wizard or design view
D. All above
10 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?

Share your comments & questions here

Guest

  • No comments yet. Be the first to comment!