Give the function of each of the following queries.
-Make table query
-Delete query
-Append query
-Update query; (Answered)
Name four types of Action Queries. (Answered)
State three disadvantages of traditional file management system over electronic file management system. (Answered)
Explain three categories of database controls. (Answered)
Define the term control as used in database forms. (Answered)
A form two student wishes to create a field named ADM. No in a table. This field will be used to store admission numbers of students in a class. Outline the steps to follow to achieve this. (Answered)
State two qualities of a primary key field. (Answered)
Differentiate between the term entity and attribute in a database. (Answered)
Name any two examples of a database package. (Answered)
List any six general field properties that can be set on a field in a table. (Answered)
List two types of form layout available in a database form wizard dialog box. (Answered)
Differentiate between a report and a form. (Answered)
Mention three objectives of normalisation. (Answered)
Differentiate between an index and a primary key. (Answered)
Define the term normalisation as used in a database. (Answered)
State three ways in which a primary key field can be used in a database. (Answered)
Give three functions of a database management system. (Answered)
State one disadvantages of flat file database model. (Answered)
Explain these database models:
a)Network model
b)Flat file (Answered)
Differentiate between database and database management software. (Answered)
List four features of database software. (Answered)
Define the term dynaset as used in database. (Answered)
Distinguish between relational database and flat file model. (Answered)
Explain these database models:
a)Relational
b)Hierarchical (Answered)
List three database management system objects. (Answered)
Define the term database management system (DBMS). (Answered)
List three types of relationships that can be used to link tables in a database. (Answered)
State one function of each of these objects in a database.
a)Table
b)Query
c)Forms
d)Reports (Answered)
Define the following terms as used in database:
a)Record
b)File
c)Database (Answered)
Mention two advantages of entering data into a database using a form. (Answered)
Differentiate between a foreign key and primary in a relational database. (Answered)
For each of the following. State the type of cell referencing that has been used in: (i)A6 (ii) $F$7 (Answered)
List any two data management tools in spreadsheets. (Answered)
Give the function of the following types of charts: bar graph, line graph, pie chart and scatter chart. (Answered)
Define the term cell as used in spreadsheet. (Answered)
Name any two types of charts in a spreadsheet. (Answered)
Explain how spreadsheets can be used in these areas:
i)statistical analysis
ii)Accounting
iii)Data management
iv) Forecasting (Answered)
Describe the following components of spreadsheet:
i)Worksheet
ii)Database
iii)Graphs (Answered)
Explain three types of cell referencing techniques. (Answered)
Define the term cell reference. (Answered)
Describe four cell data types as used in spreadsheets. (Answered)
Mention two types of cell referencing. (Answered)
Differentiate between sorting and filtering of data as applied in spreadsheets. (Answered)
Consider the data in the cells below entered in a worksheet.
a)Name the data types in the cells i)D13 ii)E20 iii)E21
b)Give the values in cells
i)E20 ii)E22. (Answered)
List three sections of a functions (Answered)
Differentiate between a label and a value used in spreadsheets. (Answered)
Define the term data filtering as used in spreadsheets. (Answered)
Differentiate between sum and sumIf functions. (Answered)
Define the following terms as used in spreadsheet graphs.
a)Legend
b)Data series (Answered)
Give three components of a worksheet. (Answered)