computer Microsoft access MCQs For PPSC exams

computer Microsoft access MCQs For PPSC exams: Unlock your potential with our extensive collection of Microsoft Access MCQs tailored for PPSC exams. These carefully curated questions cover essential concepts and features of Microsoft Access, helping you reinforce your understanding and improve your skills. Whether you're a beginner or looking to refine your expertise, our MCQs are designed to challenge and prepare you for the exam. Our blog post not only provides a variety of multiple-choice questions but also includes detailed explanations for each answer. This approach ensures you grasp the underlying principles and logic behind Microsoft Access, boosting your confidence as you prepare. Dive into our resource today and take the first step toward acing your PPSC exams!

Below are the computer Microsoft access MCQs For PPSC exams:

 Computer Microsoft Access MCQs Part 3:

1➤ In one-to-many relationship the table in 'one' side is called ------and on 'many' side is called --------?

ⓐ Child, Parent
ⓑ Parent, Child
ⓒ Brother, Sister
ⓓ Father, Son

➤ Parent, Child

---

2➤ Referential integrity means

ⓐ Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
ⓑ Do not enter a value in the primary key field of chield table if that value does not exist in the primary key of the parent table
ⓒ Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table
ⓓ All of above

➤ Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table

---

3➤ Cascade delete option

ⓐ is used to delete all the records of all tables in a database
ⓑ will repeat the recent delete operation to all the records of current table
ⓒ is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from.parent table is deleted
ⓓ None

➤ will repeat the recent delete operation to all the records of current table

---

4➤ Cascade update option

ⓐ means do not change the value in the primary key field if that record has related records in another table
ⓑ means change all the related records in child tables if the record in parent table is changed
ⓒ Both of above
ⓓ None

➤ Both of above

---

5➤ You can set a controls border type to make the border invisible.

ⓐ Transparent
ⓑ Invisible
ⓒ Do not display
ⓓ No border

➤ Do not display

---

6➤ A name must be uniue within a database

ⓐ Table
ⓑ Field
ⓒ Record
ⓓ Character

➤ Table

---

7➤ The expression builder is an access tool that controls an expression for entering an expression

ⓐ Table
ⓑ Box
ⓒ Cell
ⓓ Palette

➤ Box

---

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

ⓐ datasheet view
ⓑ design view
ⓒ link table
ⓓ None of the above

➤ datasheet view

---

9➤ The key uniuely table. identifies each record in a

ⓐ primary key
ⓑ key word
ⓒ filed name
ⓓ All above

➤ primary key

---

10➤ This data type allows alphanumeric characters and special symbols.

ⓐ text
ⓑ memo
ⓒ auto number
ⓓ None of the above

➤ text

---

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

ⓐ memo
ⓑ data/time
ⓒ number
ⓓ All above

➤ memo

---

12➤ It is a database object to view, change, and analyze data in different ways

ⓐ uery
ⓑ form
ⓒ report
ⓓ None of the above

➤ uery

---

13➤ The expression builder is an access tool that controls an expression expression for entering an

ⓐ Table
ⓑ Box
ⓒ Cell
ⓓ Palette

➤ Box

---

14➤ It is most common type of uery. It retrieves records from one or more tables and then displays the

ⓐ Parameter
ⓑ Select
ⓒ crosstab
ⓓ All of above

➤ Select

---

15➤ It is a uery that when run displays its own dialog box prompting you for information, such as

ⓐ Select
ⓑ crosstab
ⓒ Parameter
ⓓ Append

➤ Parameter

---

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

ⓐ Parameter
ⓑ Select
ⓒ crosstab
ⓓ Append

➤ Select

---

17➤ It is a sign or symbol that specifies, operator, and values that produce a result

ⓐ operator
ⓑ uery
ⓒ expression
ⓓ None of the above

➤ operator

---

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

ⓐ Table
ⓑ Form
ⓒ Report
ⓓ uery

➤ Table

---

19➤ This type of database contains multiple tables that are connected to produce combined output from all tables.

ⓐ Bound
ⓑ Linked
ⓒ Relational
ⓓ Joined

➤ Relational

---

20➤ The 'Filter by selection' allows you to filter those records

ⓐ That match the selected field
ⓑ That match the criteria specified
ⓒ That meet any of several criteria specified
ⓓ All of above

➤ That match the selected field

---

Must Read: 50 important MCQs For Competition Exams 2024