Taxmann's IT Skills for Managers

Preface

It gives us great pride and pleasure to put before our readers this book titles “IT Skills for Managers” which aims at empowering the firm managers and management students with fundamental knowledge of IT tools and their business applications. Our other titles “Computer Applications in Business” and “Essential tools” received tremendous love and appreciation from both the instructors as well as students for which we are thankful from the core of our hearts. We further believe that this book will also meet the expectations of the readers.

Technology is a great enabler. The computers have become an essential part of decision making at all levels of management in taking informed decisions which have not only affected the profitability of the business but also helped organizations meet the challenges of changing business environment. As a student of commerce and management, it is imperative to learn how to use computers in the areas that require data analysis such as finance, accounting, costing, marketing, etc.

The Book has been divided into thirteen chapters. The book besides covering basic introduction level theoretical aspects, lays major emphasis on practical business applications like payroll, depreciation and loan & lease accounting and statistical analysis of data using MS Excel. A separate chapter is there in the book to illustrate how excel is useful in decision making emphasizing different data analysis tools that enable decision making. The basic database concepts have also been explained in this book Using MS Access. This book is expected to enable the managers process data to get their required business summaries that enable them taking informed and timely decisions.

We are extremely thankful to Dr. S.K. Sharma, Associate Professor, SGTB Khalsa College for contributing significant portion of Chapter DBMS Using MS Access 2010. His valuable suggestions and critical comments encouraged us to complete this book.

We thankfully acknowledge the contributions made by Mr. Surender Kumar, Associate Professor, PGDAV College; Mrs. Aruna Jain, Associate Professor, Bharti College; Ms. Sonal Thukral, Assistant Professor, Delhi Technical University; Ms. Anju Verma, Ms. Saumya Agarwal and Ms. Anuradha Agarwal, Assistant Professors, SRCC; Dr. Rajiv Middha, Associate Professor, SGND Khalsa College; Shweta Sharda and Ms. Rekha, Assistant Professors, IP College, Ms. Anjali Tuli, Assistant Professor, Hansraj College and Dr. Kalpana, Assistant Professor, Mata Sundari College in finalizing the book.

We extend our heartiest thanks to Professor C. P. Gupta , Department of Finance and Business Economics; Dr. P.C. Jain, (Former Principal, SRCC) and Professor Anil Kumar, SRCC for providing their constant encouragement and support throughout. We are also grateful to our publisher “Taxmann”, especially Mr. Mitrapal Yadav ji and Mr. Sumit Dwivedi for providing all the support and completing the book in time.

Feedback from the readers is solicited and would be thankfully acknowledged.

DR. HEM CHAND JAIN

HARENDRA NATH

Chapter-heads

Preface I-5

Contents I-9

CHAPTER 1 1

CHAPTER 2 55

CHAPTER 3 85

CHAPTER 4 101 CHAPTER 5 156

CHAPTER 6 177 CHAPTER 7 218 CHAPTER 8 282 CHAPTER 9 334 CHAPTER 10 418 CHAPTER 11 458

CHAPTER 12 578 CHAPTER 13 602

BASIC COMPUTER CONCEPTS AND NETWORKING

1.1 Introduction 1

1.2 Meaning of computers 2

1.3 A brief history 3

1.4 Hardware 5

1.5 Functional units of a computer 13

1.6 Characteristics of a computer 16

1.7 Advantages of the computers 17

1.8 Uses of computers 18

1.9 Limitations of computers 20

1.10 Concepts of computing, data and information 20

1.11 Some commonly used computing interfaces 22

1.12 Computer networks 23

1.13 Applications of networking 25

1.14 Basic networking terminology 26 1.15 Types of network 31 1.16 Network topologies 34

1.17 Distributed computing system 42 1.18 Wireless networking 48 1.19 Summary 51 1.20 Review questions 52

BASIC INTERNET TERMINOLOGIES

2.1 Introduction 55 2.2 Meaning of internet 56

2.3 A brief history 56

2.4 Basic internet terminologies 57

2.5 How to get connected to internet ? 70

2.6 Basic internet services 72

2.7 Internet protocols 74 2.8 Uses of internet to society 76 2.9 Search engine

2.10 Cyber security 2.11 Summary 81

2.12 Review questions 82

3.1 WORD

RECENT TRENDS IN COMPUTING EXCEL 2010

BASICS OF POWERPOINT

6.7 MAKING WITH EXCEL TO DATABASE SYSTEM

8.1 FUNCTIONS PROJECTS

10.6 Modern approach of database 426

10.7

10.8 Review questions

MANAGING DATABASES USING MS ACCESS

11.1 Introduction 458

11.2 in MS access 2010 459

11.3 Creating database 460

11.4 Understanding MS access window 461

11.5 Creating tables 462

11.6 Implementing relationship between the tables 477

11.7 Creating queries 480

11.8 Queries using SQL 497

11.9 Forms using form wizard 508

11.10 Preparing reports using report wizard 517

11.11 Application of MS access in the of accounting 536

11.12 Review questions 570

MAIL MERGE

12.1 Introduction 578 12.2 Steps to use mail merge 579 12.3 Mail merge using database of MS access 2010 590

12.4 Mail merge using database in MS excel 2010 597 12.5 Review questions 599

ESSENTIAL COMPONENTS OF COMPUTERS

13.1 Introduction 602 13.2 Essential Components of a Computer 603 between and Software 604

13.4 Types of Software 606 13.5 Multimedia and its 623 625 Review Questions 627

1.2 MEANING OF

FIGURE

Engine father of computers.

First Generation (1940-1956): Use of Vacuum Tubes

Second Generation (1957-1963): Use of Transistor

Third Generation (1964-1971): Use of Integrated Circuits

Non-Impact Printers

Character

Dot

PlottersPrinter

1.5 FUNCTIONAL UNITS OF A COMPUTER

Central Processing Unit (CPU)

CENTRAL PROCESSING UNIT (CPU)

FIGURE : DIAGRAM OF

The Unit Unit

Para

1.8 USES OF COMPUTERS

(i) Education.

(ii) Health.

(iii) Business.

Information Systems

(iv)

( )

(vi)

(

(