Computerdynamics.weebly.com



MULTIPLE CHOICE:

1. Which of the following types of information can be stored in an electronic database?

A. Text

B. Alphanumeric

C. Date

D. All of the above

Answer: D

2. All of the following are problems associated with manual databases except:

A. Easy and fast retrieval of information

B. Easily misplaced folders

C. Large amounts of space required for storage of data

D. Accessing information from another location is difficult

Answer: A

3. Which of the following are not objects found in a computerized database?

A. Form

B. Table

C. Spreadsheet

D. Report

Answer: C

4. An organized collection of related records is a:

A. Cell

B. Field

C. Table

D. Record

Answer: C

5. A group of related fields pertaining to a single person is a:

A. Record

B. Query

C. Table

D. Report

Answer: A

6. In a record containing these fields:

FIRSTNAME, SURNAME, DOB, PHONENO, the DOB is considered a _________ data type.

A. Number

B. Text

C. Date/Time

D. None of the above

Answer: C

7. A primary key can:

A. Speed up data retrieval

B. Sort records according to values in fields

C. Enable you to establish relationships between tables

D. All of the above

Answer: D

8. Which of the following fields can be used as a primary key?

A. Surname

B. First Name

C. Phone Number

D. Student Number

Answer: D

9. Which database object allows you to enter, view and print information in a table or query other than in rows and columns?

A. Report

B. Form

C. Table

D. Query

Answer: A

QUESTIONS 10 to 13 is based on the following:

A list of equipment used in a school includes the following three items. These are shown entered into a database.

|ITEM |SIZE |LOCATION |QUANTITY |

|Desk |2 seater |Room 5 |15 |

|Chair |1 seater |Library |30 |

|Chalk |1 box of 1 00 sticks |Room 1 |500 |

10. What are the columns and rows called in a database?

A. Fields and Records

B. Records and Fields

C. Fields and Strings

D. Strings and Fields

Answer: A

11. The item column is sorted in a descending alphabetical order. In what order will the items now be listed?

A. Desk, Chair, Chalk

B. Chalk, Chair, Desk

C. Desk, Chalk, Chair

D. Chair, Chalk, Desk

Answer: A

12. Why is a database used in this situation instead of a spreadsheet?

A. Because the spelling checker can check the date

B. Because calculating with the data is the greatest priority

C. Because processing non-numeric data is the greatest priority

D. Because it requires less time to enter the information into a database.

Answer: C

13. What type of data is entered into the quantity column in the database?

A. Text

B. Numeric

C. Calculation

D. Alphanumeric

Answer: B

14. When you want to create a file on the computer to organize your CD collection, you will use a

A. word processor

B. database

C. spreadsheet

D. desktop publishing package

Answer: B

15. When creating a table with the ability to enter specific field sizes and changing data types, the user should be in ___________________ view.

A. Table

B. Report

C. Design

D. Form

Answer: C

True or False Questions

1. You can only have one (1) table in a database. T ☐ F ☐

2. You can generate a report if you want to display information on a table or query. T ☐ F ☐

3. You can build a query to extract information from tables to answer a particular question.T ☐ F ☐

4. The Table Wizard is the fastest way of creating a table. T ☐ F ☐

5. A primary key is a unique record identifier. T ☐ F ☐

6. A primary key can allow you to run a query faster. T ☐ F ☐

ANSWERS:

1. F

2. T

3. T

4. T

5. T

6. T

Crossword

PRINT OUT THE CROSSWORD FOR YOURSELF AND TRY TO COMPLETE IT.

[pic]

Short / Longer Assessment questions

1. Explain how an electronic database can help you to find information.

Answer: (just one of a wide possibility of answers)

By performing queries and reports

2. The database table DENTAL PATIENTS has the following fields:

Field Name Data Type Field Sizes

PatientNo ………………. …………………

FirstName ………………. …………………

Surname ………………. …………………

DateofLastVisit ………………. …………………

DOB ………………. …………………

Address ………………. …………………

PhoneNo ………………. …………………

NoofFillings ………………. …………………

NoofExtractions ………………. …………………

(a) Copy and fill in the grid with suitable data types and field sizes for the fields listed.

Answer:

Field Name Data Type Field Sizes

PatientNo ………NUM. …INTEGER

FirstName ……TEXT…. …25.…………

Surname …TEXT……. …25…………

DateofLastVisit …DATE/TIME. …SHORT DATE (or any option you want to use)

DOB …DATE/TIME. DATE(SHORT)

Address …TEXT………. …10…………

PhoneNo …NUMBER. …INTEGER

NoofFillings …NUMBER. …INTEGER

NoofExtractions …NUMBER. …INTEGER

(b) Describe two (2) queries that you may want to perform on the database above.

Answer: Search the patients who visited between certain dates; search for the address of a patient etc.

(c) List two (2) additional fields that you could add to the database table above.

Answer: Allergies, medication, illnesses, procedure done on last visit, data of next visit

(d) What field in this database table would you use as the primary key?

Answer: Patient No

3. You have decided to create a computerized database for your club house. List the fields you would include in your table.

Answer: Name, Address, Phone no, role in club, member fee, joining date etc

4. Suppose we have a database of Students with records as follows:

A:

B:

4.1. What type of view is used in Screen A.

Answer: DESIGN VIEW

4.2 What type of view is used in Screen B

Answer: DATA SHEET or LIST VIEW

4.3 Write down the name of the table used in Screen A & B?

Answer: STUDENT INFORMATION

4.4. The Data Type of the DOB(Date of Birth) Field, is called ?

Answer: DATE / TIME

4.5. Define the term

(i) Record :

Answer: COLLECTION OF FIELDS

(ii) Field :

Answer: LOCATION IN A RECORD IN WHICH A PARTICULAR TYPE OF DATA IS STORED (iii) Primary Key :

Answer: UNIQUE FIELD THAT LINK TABLES or IDENTIFY RECORD

4.6. Provide the Field Name of the Primary Key field used in this table

Answer: STUD_ID

4.7. Provide two means to extract information from a Database

Answer: QUERY // REPORT

5. Look at the following database document and answer the questions that follow.

| |SURNAME |FIRST NAME |ADDRESS |TOWN/CITY |CODE |

|1 |Green |Keith |9 Jeffrey Ave |Windhoek |OX167NW |

|2 |Kauaria |Jane |16 Rabecca Rd |Oshakati |OX156TE |

|3 |Cheung |John |3 Hope Str |Rundu |OX125LT |

|4 |Aleksic |Rudy |7 Nepean Ave |Okahandja |OX153MF |

|5 |Walters |Cathy |23 Roan Str |Windhoek |OX168PV |

|6 |Cruzic |Joe |150 Victoria Rd |Mariental |OX124RT |

| | | | | | |

a) How many fields in this database?

Answer: 5

b) Why is it important to back-up a database?

Answer: To prevent the loss of data // have a duplicate for in case system

failure or original get lost

c) What is a key field in a database?

Answer: Unique key field//Field used to link tables together// Identify a specific record

d) Which field could be used as key field in this database?

Answer: CODE

e) Mention the steps to output the records of those who stay in Windhoek only?

Answer: Create a query

Use fields [surname][name][town] ALL THREE MUST BE PRESENT

Criteria to be typed = Windhoek

f) Name two (2) types of data that can be used to set-up a table like this one.

Answer: Text // Number//

g) Name one method of creating a printout of the data above.

Answer: Create a report // print out the entire table

-----------------------

Across

4 A unique field (two words) (10)

6 A collection of related data (8)

hjnrwƒˆŒ‘¡¢¬­®¯²üýþº Â Å Æ Ç È É Ë ø üøüðëðüçüçüçüçüðëðüß×Ïëç×Ç뿯Ÿ?¯wk\h"&^h"&^@ˆúÿB*[pic]\?phhT_¶@ˆúÿB*[pic]\?phh>h"&^5?h>h"&^5?@ˆþÿB*[pic]\?phh>h~;p5?@ˆûÿB*[pic]\?phh>hT_¶5?@ˆûÿB*[pic]\?phh>h"&^5?@ˆûÿB*[pic]\?7 A group of fields relating to a particular person, place or

thing (6)

Down

1 Each database can have a number of these (7)

2 Displays information from tables and queries in a

customized format (6)

3 An item of data on a particular person, place or thing (5)

5 A collection of related data about a specific subject (5)

PR IMARY KEY

PR I MARY KEY

P R I M A R Y K E Y

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download