Get premium membership and access questions with answers, video lessons as well as revision papers.
(i) Date/ Time: Is a data type used for a field that will either hold date or time values. It stores 8 bytes.
(ii) Currency: Is a data type used for a field that will hold currency values and to prevent rounding off during calculations. It stores 8 bytes.
(iii) Text: Is a data type used for fields that will either hold text or combinations and numbers as well as numbers that do not require calculations, such as phone numbers.
(iv) Memo: Is a data type used for fields that will hold lengthy text or combinations of text and numbers such as notes or descriptions.
A memo filed stores a maximum of 65 535 characters.
(v) Number: Is a data type used for fields that will store / hold numeric values to be used in mathematical calculations.
(vi) AutoNumber: Is a data type chosen for fields that will store numbers that will be automatically incremented by 1 in a sequential order whenever a new record is added.
(vii) Yes/ No: Is a data type chosen for fields that will take a boolean expression data having two possible values but only one will be chosen such as Yes/ No values, True/ False values, or On/ Off.
(viii) OLE Object: Is a kind of a data type chosen when that field is to hold embedded objects such as pictures, sounds or programs like Microsoft Excel and Microsoft Word document, which are linked or embedded to a database table.
(ix) Hyperlink: Is a data type chosen when that field is to store a URL (Website address) or a path to a file in a remote computer either on the intranet or internet.
(x) Lookup Wizard: Is a data type used when looking for fields that will allow the user to choose a value from list of values using a combo box or from another table.
maurice.mutuku answered the question on April 11, 2018 at 09:06
- What is a "data type" as used in databases?(Solved)
Define what a "data type" is as used in databases.
Date posted: April 11, 2018. Answers (1)
- What guidelines should a database designer consider before setting up a good database?(Solved)
Give the main guidelines that a database designer should consider before setting up a good database.
Date posted: April 11, 2018. Answers (1)
- What are the steps needed to open an existing database and entering a new record?(Solved)
Outline the steps needed to open an existing database and to enter a new record.
Date posted: April 11, 2018. Answers (1)
- What is a "Field" in relation to databases?(Solved)
Define a "Field" in relation to databases.
Date posted: April 11, 2018. Answers (1)
- What is a "File" in relation to databases?(Solved)
Define a "File" in relation to databases.
Date posted: April 11, 2018. Answers (1)
- What is a "Record" in relation to databases?(Solved)
Define a "Record" in relation to databases.
Date posted: April 11, 2018. Answers (1)
- What are the major features of a database management software objects acting as a means to manipulation of data contained in the database?(Solved)
Discuss the major features of database management software objects which act as a means to manipulation of data contained in the database.
Date posted: April 11, 2018. Answers (1)
- What is SQL?(Solved)
Define SQL.
Date posted: April 11, 2018. Answers (1)
- What are the main components of a database system?(Solved)
Explain the main components of a database system.
Date posted: April 11, 2018. Answers (1)
- What is the difference between database application and database system?(Solved)
Distinguish between database application and database system.
Date posted: April 11, 2018. Answers (1)
- What are the major functions of DBMS in a computerized information processing?(Solved)
Give the major functions of DBMS in a computerized information processing.
Date posted: April 11, 2018. Answers (1)
- What are the examples of DBMS software?(Solved)
Highlight the examples of DBMS software.
Date posted: April 11, 2018. Answers (1)
- What is "Database Management System" (DBMS)?(Solved)
Define the term "Database Management System" (DBMS)
Date posted: April 11, 2018. Answers (1)
- What are the advantages of modern database systems over paper-based systems?(Solved)
Discuss the advantages modern database systems have over paper-based systems.
Date posted: April 11, 2018. Answers (1)
- In what areas may databases be used in a business enterprise?(Solved)
Highlight areas where databases may be used in a business enterprise.
Date posted: April 11, 2018. Answers (1)
- What is a Database?(Solved)
Define a Database.
Date posted: April 11, 2018. Answers (1)
- What is the procedure for printing a group of worksheets at the same time in Ms Excel?(Solved)
Describe the procedure for printing a group of worksheets at the same time in Ms Excel.
Date posted: April 11, 2018. Answers (1)
- What is "collating copy printing" and how can you control it?(Solved)
Define "collating copy printing" and show how to control it.
Date posted: April 10, 2018. Answers (1)
- What are the types of page orientation?(Solved)
Give the main types of page orientation.
Date posted: April 10, 2018. Answers (1)
- What is "Page orientation?"(Solved)
Define "Page orientation"
Date posted: April 10, 2018. Answers (1)