- •Unit 1 computer applications
- •Computers
- •What can computers do?
- •Unit 2 computer essentials
- •What is a computer?
- •Unit 3 inside the system
- •What’s inside a pc system?
- •Structure of the processor
- •Unit 4 bits and bites
- •Units of memory
- •Unit 5 magnetic drives
- •Technical details
- •Unit 6 optical breakthrough
- •Optical disks and drives
- •Iomega's removable drives
- •Unit 7 input / output devices
- •Voice recording device h. Keyboard
- •Unit 8 capture your favourite image
- •Vivid easy-to-use faster fashionable wide shots
- •Unit 9 viewing the output
- •The monitor
- •Unit 10 choosing a printer
- •Types of printers
- •Unit 11 operating systems Exercise 1.Look at the diagram below. What is the function of the operating system?
- •Exercise 4. Language work
- •Unit 12 the graphical user interface
- •Unit 13 a walk through word processing
- •Word-processing facilities
- •Unit 14 spreadsheets
- •Unit 15 databases
- •Basic features of database programs
- •Exercise 6. Writing
- •Unit 16 faces of the internet
- •Exercise 2. Maybe we can find it on the Internet.
- •Exercise 3. Reading.
- •Internet software
- •Irc, audio and video chatting
- •MIrc for Windows is a typical Internet relay chat program. You can get it at http://www.Mirc.Co.Uk/
- •Unit 17 programming and languages
- •Programs and programming languages
- •Exercise 3. These are answers to questions about the text. Write the questions.
- •Variables and the Declaration Statement
- •Unit 18 computer networks
- •Computer networks
- •Network configurations
- •4 Bus/Ethernet
- •Unit 19 computer viruses
- •How computer viruses work
- •Unit 20 computers in the office
- •Information systems
- •Using Computers
- •Information Technology (it)
- •Exercise 5. Link each statement (1-) with a purpose (a-j).
- •Exercise 6. Match the words from the box with their definitions.
- •The future? We’re virtually there!
Unit 15 databases
Exercise 1. Companies often use databases to store information about customers, suppliers and their own personnel. Study the illustrations and then try to answer these questions.
What is а database?
Which tasks can be performed by using а database? Make а list of possible applications.
What do the terms mean in your language:file, record, field?
Record from an Employee file in a database. This record holds ten fields (the illustration is one)
A database file stores information in fields grouped on records
Exercise 2. Reading.
A Here is part of an article about databases. First, read all the way through and underline the basic features of а database.
Basic features of database programs
With а database you can store, organize and retrieve а large collection of related information on computer. If you like, it is the electronic equivalent of an indexed filing cabinet. Let us look at some features and applications.
Information is entered on а database via fields. Each field holds а separate piece of information, and the fields are collected together into records. For example, а record about an employee might consist of several fields which give their name, address, telephone number, age, salary and length of employment with the company. Records are grouped together into files which hold large amounts of information. Files can easily be updated: you can always change fields, add new records or delete old ones. With the right database software, you are able to keep track of stock, sales, market trends, orders, invoices and many more details that can make your company successful.
Another feature of database programs is that you can automatically look up and find records containing particular information. You can also search on more than one field at а time. For example, if а managing director wanted tо know all the customers that spend more than $7,000 per month, the program would search on the name field and the money field simultaneously.
А computer database is much faster to consult and update than а card index system. It occupies а lot less space, and records can be automatically sorted into numerical or alphabetical order using any field.
The best packages also include networking facilities, which add а new dimension of productivity to businesses. For example, managers of different departments can have direct access to а common database, which represents an enormous advantage. Thanks tо security devices, you can share part of your files on а network and control who sees the information. Most aspects of the program can be protected by user-defined passwords. For example, if you wanted to share an employee's personal details, but not their commission, you could protect the commission field.
In short, а database manager helps you control the data you have at home, in the library or in your business.
B Now make а list of the words you don't understand. Can you guess their meaning? Compare your ideas with other students.
C Using the information in the text, complete these statements.
А database is used tо _____.
Information is entered on а database via _____.
Each field holds _____.
'Updating' а file means _____.
The advantages of а database program over а manual filing system are ___.
Access to а common database can be protected by using _____.
Exercise 3. Puzzle
Complete the sentences by using а term from the list. Then write the words in the crossword to find the hidden message.
database field layout merging record sorted updated |
In order to personalize а standard letter you can use “mail _____” (а technique which consists of combining а database with а document made with а word processor).
Records can be automatically _____ into any order.
You can decide how many fields you want to have on а _____.
Files can easily be _____ by adding new information or deleting the old one.
А _____ program can be used to store, organize and retrieve information of any kind.
The _____ of the records can be designed by the user.
Each piece of information is given in а separate _____.
Exercise 4. Plurals.
А Look at the HELP box and then write the plural of these words:
slot 5 fax
key 6 mouse
directory 7 floppy
businessman 8 virus
В Look at the text in Exercise 2 again and find 5 plurals pronounced /iz/.
HELP box Plurals •
record – records
address – addresses; bох – boxes
man – men child – children analysis – analyses formula – formulae/formulas
|
Exercise 5. Look at the illustration of mail merging and identify the three types of documents involved in this example of mail merging.
|
A |
B |
C |
D |
E |
F |
1 |
Title |
First name |
Last name |
Street |
City |
Postcode |
2 |
Mr |
Fred |
Jones |
15 The Calls |
Leeds |
LS2 6JU |
3 |
Mrs |
Diana |
Read |
18 Union Street |
Glasgow |
G1 3TA |
4 |
Ms |
Carol |
Taylor |
75 Windmill Str. |
London |
W1P 1H |
5 |
Mr |
Jack |
Gordon |
7 Piccadily Str. |
York |
YO1 1PN |
The data document contains the fields and the information that is different in each version of the letter.