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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- getroman com reviews
- acurafinancialservices.com account management
- acurafinancialservices.com account ma
- getroman.com tv
- http cashier.95516.com bing
- http cashier.95516.com bingprivacy notice.pdf
- connected mcgraw hill com lausd
- education.com games play
- rushmorelm.com one time payment
- autotrader.com used cars
- b com 2nd year syllabus
- gmail.com sign in