ICT Term 1 Exam (Written)

Question 1

Explain Why The “customer_ID” in the customer table has the data type autonumber, while the “customer_ID” in the appointment table has the data type number?

Answer 1

Because each customer should have a unique ID in order not to have confusion
Because each customer can take many appointments his ID should be repeated many times.

Question 2

Explain the difference between the information in the page header and the detail section.

Answer 2

The information in the page header is displayed only on the top of the page.
The information in the detail section will be repeated many times ion the page.

Question 3

Why do we use a condition in MS Access?

Answer 3

A condition is used in a query to display only the records that meet specific conditions.

Question 4

Why do we use a database?

Answer 4

It is widely used for storing data and solving database problems.

Question 5

What is a relationship in access.

Answer 5

Connection Between tables in access.

Question 6

What are the functions of modules?

Answer 6

Data stored in tables, results in queries, forms, and reports.

Question 7

Describe the utility of the module “Report”

Answer 7

Generate on a paper a selection of data according to a condition set.

Question 8

Describe the utility of the following module:
Table
Report
Query

Answer 8

Table: Saves important information
Query: Generates on the screen a selection of data according to a condition set
Report: Generates on a paper a selection of data according to a condition set