Fill in the blanks

Question 1.
A …………….. when appearing in another table, is known as ……………..

Answer

Answer: Primary key, Foreign key

---

Question 2.
A software using Database Management System without facility of ……………… is not complete.

Answer

Answer: Report generating

---

Question 3.
Tables can be created by using any of the three methods, namely ……………, ……………… and ……………….

Answer

Answer: Datasheet View, Table Wizard, Design View

---

Question 4.
…………….. query does not involve use of any query functions to produce a summary of data.

Answer

Answer: Simple

---

Question 5.
When saved as ………………… the contents of reports cannot be modified by the user.

Answer

Answer: Snapshots

---

Question 6.
The purpose of ………….. is to organise the information of report into categories whereas …………… average information into numerical or alphabetical order.

Answer

Answer: Sorting

---

Question 7.
…………….. clause is used to specify the field to display data or information.

Answer

Answer: SELECT

---

Question 8.
……………… query promotes the user to enter criteria for selecting a set of records.

Answer

Answer: Parameter

---

Question 9.
A unique identification given to an object is known as ………………….

Answer

Answer: Primary key

---

Question 10.
……………… are the reports that the system generates as programmed.

Answer

Answer: Programmed reports

---

State whether the following statements are True or False

Question 1.
The unique number given to an object is known as primary key.

Answer

Answer: True

---

Question 2.
In MS Access, forms are present and can also be designed according to the need.

Answer

Answer: True

---

Question 3.
A primary’ key appearing in another table is known as sub-primary key.

Answer

Answer: False

---

Question 4.
In MS Access, data entered can only be text data.

Answer

Answer: False

---

Question 5.
Select queries in Access help in generating information.

Answer

Answer: True

---

Question 6.
Every Accounting Report is prepared with a definite objective.

Answer

Answer: True

---

Question 7.
Ledger may be generated in Access by adhering to report generation process.

Answer

Answer: True

---

Question 8.
The forms created with wizard have unlimited visual appeal.

Answer

Answer: False

---

Question 9.
Enforcing data integrity constraints is not the capability of MS Access.

Answer

Answer: False

---

Question 10.
Domain integrity is implemented in Access by setting the properties of fields in the table.

Answer

Answer: True

---