ms access tutorial sinhala | replace.me

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

De Silva B. Colombo ; M. Facilitators Mrs. Dewagiri Mrs. Ariyarathna Mrs. Senthilkumaran Mr. All rights reserved. No part of this course book may be reproduced or transmitted in any from or by any means, electronic or mechanical, including photocopying and recording or from any information stored in a retrieval system, without permission in writing from the Open University of Sri Lanka.

It is a 3 credits course which will require about 75 hours of study. Course outline This course is designed for the students to improve their skills on ICT Information and Communications Technology enabling them to manage their tasks effectively and efficiently in their working environment. The knowledge of the office package, the Internet, e-mail, e- commerce, etc.

Structure of course This course consists of one book. The Course material will be given with the Practical Guide and the Multimedia CD, and in order to get the best from this course be sure to use these three materials simultaneously.

And also you will be supported from the Learner Management System Moodle in an interactive manner. There will be six day schools during which you will be able to sort out any problems you may encounter.

All the topics of this course will be covered within six day schools. In order to gain more from the day schools you are advised to work through the sessions including all activities before you come. The time table issued to you at the time of your registration will indicate the dates of these day schools. Assessments You will have two closed book tests as means of continuous assessment of your progress in the course. Your scores will be used to determine your eligibility to sit for your final examination.

Your performance on the course as a whole will be determined from your continuous assessment and final examination scores, according to the formula given in your course information sheet more details on the course will be provided via the information sheet. We hope that you will find the course material interesting and that you will enjoy your learning experience with the Department of Mathematics and Computer Science. Describe what IT is. Before moving onto the topic of ICT Skills let us have a look at the different terms such as IT, ICT, and Computer Science related to this course unit and let us identify the differences among these terms.

The term Information Technology refers to an entire field that uses computers, networking, software, and other equipment to manage information electronically in a digital form. Consider an IT department in an organization. They are equipped with computers, database Management Systems, servers, and security mechanisms for storing, processing, retrieving, and protecting information available with the organization.

You might have heard about the professionals working in such department of a company like system administrators, database administrators, programmers, IT managers, network engineers. If it is a business organization, they all work together to provide services such as providing information, providing tools to improve the productivity, automating the business processes, and providing means for connect with customers. Therefore, in the modern world, IT is an essential part of all of business operations.

UNESCO considered Information Technology as Scientific, technological and engineering disciplines and management techniques used in information handling and processing, their application, computers and their interaction with men and machines, and associated social, economic and cultural matters.

Accordingly, a fair knowledge in IT has become an essential qualification to work successfully in almost all organizations in the country. The term Information and Communication Technology can be considered as an extended version of the term IT as it involves a C that represents the communication of data by electronic means, usually over some distance.

This integration has provided large savings of costs due to the elimination of telephone networks. Simply, ICT can be seen as the integration of information technology with communication technology.

But it is a more specific term that stresses the role of unified communications and the integration of telecommunications telephone lines and wireless signals , computers as well as necessary enterprise software, middleware, storage, and audio-visual systems, which enable users to access, store, transmit, and manipulate information.

The term ICT is more inclined and widely used in the educational sector. Some have simplified ICT as using audiovisual equipment for learning at school and the use of networks that help transmit information across schools. IT was limited only to the textual mode of transmission of information with ease and fast. But the information not only in textual form but in audio, video or any other media is also to be transmitted to the users. It has opened new avenues, like, Online learning, e-learning, Virtual University, e-coaching, e-education, e-journal, etc.

Mobile is being used in imparting information fast and cost effective. It provides e-mail facility also. One can access it anywhere. It will be cost effective. The ICT brings more rich material in the classrooms and libraries for the teachers and students. It has provided opportunity for the learner to use maximum senses to get the information. It has broken the monotony and provided variety in the teaching learning situation.

As already mentioned above, by the technology of communication we process transfer digital data from one device to another. These technologies related to the communications are usually complex. Though you are not going to study about them in this material, there are some aspects of digital communication that you need to study such as the types of networks and the mechanism of getting connected with the internet.

These topics are discussed within this course material in coming sessions. In simple words, Computer Science is all about computers. In contrast with IT, CS is the science of computing with in depth knowledge of working principles of computers whereas information technology is the science designed to make best use of information systems to make work easier in business environments.

According to the Wikipedia, CS is the scientific and practical approach to computation and its applications. A computer scientist specializes in the theory. So, a computer scientist is obviously thorough in Physics, Mathematics, electrical engineering, and forms of languages. CS is a field related to research work and thus its evolving with the innovations of the research outcomes.

Now you may have some idea that the ones who can afford to be in touch with the information and communication technology can be updated with evolving knowledge while the ones who fail or have less chances may remain in the pre-knowledge stage. It is clear that you require some skills ranging from basic to advanced, that are needed to be able to work with computer based information systems.

Simply, you will require the capability of using computers and computer software in order to deal with information and communication technologies. So, now you can understand that the computer skills are necessary and highly related to ICT. Imagine that you have followed this course unit. Let us take very simple examples to brief the above six terms related to information to understand the necessary computer skills for ICT. You can sing a song and record your voice using a microphone and save it in your computer as a digital file which you can open and play later.

Here the voice input has been converted into a digital media file and stored it in your computer for future reference. You may save store it in a CD and give it to your friend to listen. Imagine that you have very confidential documents saved in a folder of your computer.

In order to avoid others accessing those documents you may lock protect the folder accessibility by applying a password on the folder. Simply, when someone tries to open that folder, the computer will ask for a password which is only known to you.

If you are working in the salary division of your company you may use a simple computer program which gives the monthly salary of employees when the data such as basic salary, salary advance taken, allowances to be given, no.

Here the data given has been processed into the monthly salary which is important information. The salary particulars of all employees of Matara branch of your company may be processed at the Colombo Head office and the salary file may be sent to Matara branch through the company intranet a network built among the branches of your company. Otherwise the salary file may be e-mailed to the branch manager at Matara.

Here, using. You may be asked by your manager to give a list of employees who work in the Sales division who have exceeded a total of OT hours during the last six months. It will be just a matter of calling retrieving the existing data saved in the central database to generate the report in the required format. From the next session onwards, you will get familiar with computers and will acquire the necessary skills step by step.

You will able to get the skills related to some of the key applications of ICT such as text editors, spreadsheets, databases, and presentations.

This ICT Skills course is planned to do more, than teaching basic computer literacy skills on current packages. It provides a combination of theoretical knowledge and practical skills that together comprise a mental framework that will enable the student to get familiar and learn new IT packages as they change, to solve new IT problems and use additional package features that are not explicitly taught in this course.

However, the course has a strong practical focus with the intention of enabling students to use ICTs as tools for productivity and problem solving in your lives which is the aim and objective of this course unit. So it is a must to do practicals based on the content of this material to achieve the above aims and objectives.

ICT c. Education b. Health c. Business 1. Introduction to Computers Aim: This lesson aims to provide students with an understanding the basics and the role of computation. Describe what a computer is Identify the characteristics as well as the limitations of computers Identify different types of computers from the ancient ones to modern ones Explain what a computer system is as well as its parts. A computer is a general purpose device which can be programmed to carry out a finite set of arithmetic or logical operations.

Since a sequence of operations can be readily changed, the computer can solve more than one kind of problem. A computer is an electronic device which is capable of receiving the inputs data from the user , storing it for a desired period of time, manipulating it according to the set of instructions called program and producing the output to the user in desired form. It performs a variety of operations in accordance to the set of instructions. The above three descriptions are some standard definitions extracted from different information resources available in the World Wide Web, including Wikipedia, the largest free encyclopedia.

Meanwhile, a computer can be defined as follows in terms of basic usage of the computer which is more readable for a layman. A computer is an electronic device that manipulates information, or “data”.

It has the ability to store, retrieve, and process data. You can use a computer to type documents, send email, and browse the internet. You can also use it to handle spreadsheets, accounting, database management, presentations, games, and more.

 
 

 

Download MS Access Tutorial (PDF Version) Download ( Pages | Free )

 
Clear instructions. Course covers the types of queries, creating Select queries, criteria, joins, and intermediate tables. This course covers the types of relationships and how to build each one. Design and build tables for a database Access basics, part 1. Parameters are a powerful way to filter your query results.