Question

Q1 Access to stored data enables knowledge workers to:

Group of answer choices

copy, save, name and create files

move, delete, retrieve, update and display files

print, import and protect files

all of the above

Flag this question

Question 21 pts

Which of the following is an advantage of using a relational database rather than one large table?

Group of answer choices

Data redundancy is maximised

Only one user can access the information at a specific time

Data is often repeated

Data is easier to modify and update

Flag this question

Question 31 pts

A database takes:

Group of answer choices

Information as input and produces data as output

Information as input and produces knowledge as output

Data as input and produces knowledge as output

Data as input and produces information as output

Flag this question

Question 41 pts

Any text that is typed in the Description column in table design view is displayed on

Group of answer choices

The status bar when entering data

The description bar in forms

The report footer when printed

The title bar of MS Access while entering data

Flag this question

Question 51 pts

The picture below is an excerpt from an ‘Access’ database. With reference to this diagram which of the statements below is TRUE?

Group of answer choices

This picture shows a database subform

This picture shows a database query

Data about purchases is stored in this query

This form would be used as an interface to the Purchase table

Answer 1

1) The correct answer is "all of the above".

Access to stored data enables knowledge workers to copy, save, name and create files, move, delete, retrieve, update and display files, print, import and protect files.

Database is a collection of records which has the similar structure. The main advantage of database over excel is easier to perform complex calculations and queries. It is easier to retrive, update and manipulate data from database.

2) The correct answer is "Data is easier to modify and update".

Relational database is a collection of tables or two dimentional data. The main advantage of using relational database is it is easy to update and modify data. The data redundancy is reduced in the relational database.

3) A database takes "Information as input and produces knowledge as output".

The main goal of the infromation system is to convert the data into information in the sequence of producing knowledge.