It Tools and Business Systems

Cover
Half Title
Title Page
Copyright
The ISRD Group
Contents at a Glance
Contents
Preface
Acknowledgements
Feedback
Syllabus
Chapter 1 Getting to Know Computers
	Computers — An Introduction
	Characteristics of Computers
	Limitations of Computers
	Applications of Computers
	The Computer System
	Components of Computer System
	Number System —An Introduction
	Memory Addressing
	Coding Schemes
	Conversion of Numbers
Chapter 2 Processing and Memory
	Introduction
	CPU
	Processor Speed
	Main Memory Unit
	Random Access Memory (RAM)
	Read Only Memory (ROM)
	Cache Memory
Chapter 3 Peripheral Devices
	Peripheral Devices — An Introduction
	Input Devices
	Output Devices
Chapter 4 Secondary Storage Devices
	Secondary Storage Devices — An Introduction
	Magnetic Disks
	Optical Disks
	Mass Storage Devices
Chapter 5 Software Concepts
	Introduction
	Relationship between Hardware and Software
	Categories of Software
	Public Domain Software
	Software Licensing
	Computer Languages
	Generations of Programming Languages
	Types of Programming Languages
	Introduction to Some High-Level Languages
Chapter 6 Multimedia
	Multimedia : Definition
	Categorization of Multimedia
	Major Characteristics of Multimedia
	Why is Multimedia Important?
	Multimedia Development System
	Multimedia Building Blocks
	Multimedia Applications
	Common Multimedia File Formats
Chapter 7 An Introduction to Microsoft Windows
	An Overview of Different Versions of Windows
	Introduction to Windows XP
	Getting Started with Windows
Chapter 8 Windows Accessories and File Management
	Windows Accessories
	Windows Explorer
	Command Prompt
	Files, Directories and Drives
	Installing Applications
	Uninstalling Applications
Chapter 9 The Linux OS
	An Overview of Linux
	Features of Linux
	Structure of Linux Operating System
	Installation of Linux
	Linux File System
	Starting Linux Session (Logging in)
Chapter 10 Microsoft Word Basics
	Introduction to Word Processing
	Introduction to Microsoft Word 2003
	The Word 2003 Environment
	Creating a Document
	Word's Document Views
	Opening a Document
	Saving a Document
	Printing Documents
	Exiting Word
	Typing in a Document
	Selecting Text
	Editing Text
	The Clipboard
	Moving and Copying Text
Chapter 11 Proofing Documents
	Proofing Documents
	Correcting Spelling Errors
	Quick Spelling Checking
	Using Automatic Spell-Check
	Using the Grammar Command
	Using the Thesaurus
	Using AutoCorrect and AutoText
	Using the AutoComplete
	Hyphenating Documents
Chapter 12 Document Enhancement
	Formatting Text
	Character Formatting
	Paragraph Formatting
	Section Formatting
	Page Formatting
Chapter 13 Mail Merge
	Mail Merge — An Introduction
	Introducing Main Documents and Data Sources
	Writing Form Letters
	Creating the Data Source Document
	Merging Specific Records
	Setting the Record Order
	Creating Envelopes and Mailing Labels
Chapter 14 Working with Wizards and Templates
	Word's Wizards
	Introducing Templates
	Handling Graphics
Chapter 15 Creating Tables and HTML Documents
	Word Tables
	Creating Tables
	Modifying the Table Layout
	Sorting Table Data
	Calculating in a Table
	Creating a Web Page
	Converting an Existing Document to HTML
	Inserting Hyperlinks
	Previewing Web Page
Chapter 16 Microsoft Excel Basics
	Introduction to Excel 2003
	Starting Excel
	Excel's Parts
	Navigating through Cells
	Essential Workbook File Operations
	Workspace Files
	Types of Worksheet Data
	Entering Data into a Cell
	Editing a Worksheet
	Selecting Cells, Rows and Columns
	Copying and Moving Cells
	Deleting Cells, Rows and Columns
	Inserting Cells, Rows and Columns
	Changing Column Widths
	Changing Row Heights
	The Formatting Toolbar
	Number Formats
	Using AutoFormats
	Essential Spreadsheet Operations
	Printing Your Work
Chapter 17 Working with Formulae and Cell Referencing
	Introducing Formulae
	Understanding Cell References
	Excel Error Values
	Linking Workbooks
	Excel Functions
Chapter 18 Charts and Data Sharing
	Overview of Charts
	Chart Types
	Creating Charts
	Formatting Chart Elements
	Printing Charts
	Hyperlinks
	Using Excel with Office Applications
Chapter 19 Microsoft Powerpoint
	Introduction to PowerPoint
	Starting PowerPoint
	The PowerPoint Window
	Creating a Presentation
	Saving a Presentation
	PowerPoint Views
	Outlining the Presentation
	Customizing a Presentation
	Creating Slide Shows
	Printing Presentations
Chapter 20 Database Fundamentals
	Database Management Systems
	Data Models
	Database System Architecture
	Relational Database Management System
	Candidate Key and Primary Key in Relation
	Foreign Keys
	Relationships
	Referential Integrity
Chapter 21 Microsoft Access Basics
	Introduction
	Creating a New Table
	Creating Relationships
	Editing a Table Structure
	Add or Edit Data
	Move between Records or Fields
	About Finding or Replacing Data
	Deleting Records
	Sorting Records
Chapter 22 Access Objects
	Forms
	Creating a Form using Form Wizard
	Queries
	Creating a Query
	Setting Special Criteria
	Relating Multiple Tables in a Query
	Creating a Totals Query
	Summary Query
	Reports
	Creating a Report using Report Wizard
Chapter 23 Information Technology and Society
	Introduction
	Indian IT Act
	Intellectual Property Rights - Issues
	Applications of Information Technology
Index