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

PPSC Computer Science Topic 6 Microsoft Access

00:00
Question # 1

Which of the following database object is created first before any other created

Question # 2

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

Question # 3

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.

Question # 4

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

Question # 5

A__ enables you to view Data Base A table based on a specific criterion

Question # 6

The third stage in Designing A database is when We analyze our tables more closely and create a _________ between tables.

Question # 7

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

Question # 8

The option allows you to build a new table by entering data directly into the datasheet.

Question # 9

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

Question # 10

In access this displays the result of a calculation in query

Question # 11

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

Question # 12

Which of the following is Not A type of Microsoft access Data base object.

Question # 13

It is an association established between common

Question # 14

The filter by selection allows you to filter those records

Question # 15

What does the show check box in query design windows indicate.

Question # 16

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

Question # 17

What is a form in MS Access

Question # 18

Queries in Access can be sued as.

Question # 19

In table design view which key can be used to switch between the field names and properties panels.

Question # 20

Name of the fields field type and size

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


Topic Test

00:00

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 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.
2 In access this displays the result of a calculation in query
A. Lookup field
B. Calculated field
C. Source field
D. child field
3 Which of the following is Not A type of Microsoft access Data base object.
A. Table
B. Form
C. Worksheets
D. Modules
4 How can you define a field so that when entering data for that field it will display instead of actual typed text.
A. input Mask
B. Validation rule
C. Indexed
D. IME mode
5 To create this you enter an expression in the design grid that instructs access to perform a calculation using the current field values.
A. formulated field
B. Numeric field
C. Formula field
D. Calculated field
6 In A data base table The category of information is called _______
A. Tuple
B. Field
C. Record
D. All above
7 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
8 The key uniquely identifies each record in a table
A. Primary key
B. Key word
C. Field name
D. All above
9 Which field tye can store phots.
A. Hyper link
B. Ole
C. Both of these can be used
D. Access tables can't store photos
10 To sort records in a table.
A. Open table click on the field on which the sorting is to be done then click sort button on data base toolbar.
B. Open table click sort button on data base tool bar, choose field based on which to sort click ok
C. Click the field heading to sort it ascending or descending
D. All of above

Test Questions

Is this page helpful?