ICT Term 1 Exam

Question 1

The “doctor_code” in the table “doctor” should have the data type:

Answer 1

Autonumber

Question 2

A query that gathers its information from many tables called:

Answer 2

Complex query

Question 3

The result of a query appears on:

Answer 3

Screen

Question 4

Are the properties of each field:

Answer 4

Data type

Question 5

In order to change the printing page orientation, click on the menu:

Answer 5

Page setup

Question 6

The _______ data type to make a list of options or values

Answer 6

Lookup wizard

Question 7

To modify the layout and the properties of a report click on:

Answer 7

view-design view

Question 8

When the data type is the text:

Answer 8

Any data is accepted

Question 9

Once created the _________’s structure cannot be modified

Answer 9

Table

Question 10

A query gathers its information from a database.

Answer 10

True

Question 11

If the relationship between the tables is not well established, you will not obtain a good result.

Answer 11

True

Question 12

A database that contains one table is called a simple database.

Answer 12

True

Question 13

In the database, the creation of the table precedes the analysis phase.

Answer 13

False (The analysis phases precedes the creation of the table)

Question 14

A report can include information from a table or query.

Answer 14

True

Question 15

A query cannot include a condition

Answer 15

False

Question 15

It is impossible to add a calculation field to a report

Answer 15

False (Possible)

Question 16

It is not possible to apply several conditional formatting’s to different columns in the report.

Answer 16

False (Possible)

Question 17

The query should contain all the information concerning the current subject.

Answer 17

False (May contain)

Question 18

A primary key is used to relate a table to foreign keys in other tables.

Answer 18

True