Table of Content
 

Basic structure of Computer & its essential parts

  • HISTORY
  • The Abacus
  • Algorithm
  • Boolean algebra
  • Babbage’s engines
  • Turing’s Universal Machine
  • Vacuum tube
  • ENIAC
  • Transistors
  • Integrated circuits
  • Micro computers
  • Mini computers
  • Mainframes
  • Super computers
  • BASIC OF COMPUTER
  • Types of  Computers
  • The system unit (CPU)
  • Input devices
  • Multimedia Keyboard
  • Optical mice
  • Output devices
  • TFT monitor
  • Printer
  • Other Input and Output devices
  • Optical Scanner
  • Digital Audio Tape (DAT)
  • Zip drive
  • USB Flash drive
  • Modem
  • UPS (Un-interrupted Power Supply)
  • Familiarizing with disk drives
  • Secondary memory devices
  • Floppy Disk
  • Floppy Diskette Drive
  • Tips for removing the Floppy diskette drive
  • Floppy Drive Troubleshooting
  • Hard disk Trouble  shooting
  • CD ROM
  • Advantages of Secondary Storage Devices
  • Limitations of Secondary Storage Device
  • CD ROM Drive
  • CD drive troubleshooting
  • Video Compact Disc (VCD)
  • VCD Hardware and Software Requirements
  • Digital Video Disc (DVD)

Motherboard, Cables and Connectors of a PC system

  • Basic Computer
  • Cables and connectors
  • Connector/converters
  • Basics of Mother Board
  • Processor Sockets
  • Memory packaging
  • Need for expansion slots
  • Types of IO buses
  • AGP Accelerated Graphic Port
  • Bus speeds
  • Interrupts
  • Chip sets
  • BIOS
  • POST
  • Cooling system in a PC
  • Memory
  • Dynamic RAM (DRAM)
  • Static RAM (SRAM)
  • Main memory
  • Cache Memory

Computers and Operating system

  • Introduction to PC Family
  • PC
  • PC / XT
  • PC / AT
  • LAPTOP
  • PALMTOP
  • DESKTOP
  • Introduction to Operating Systems
  • DOS
  • The command interpreter (COMMAND. COM)
  • The Basic input/output System (BIOS)
  • The DOS utilities
  • WINDOWS
  • Introduction
  • Windows XP Professional
  • BOOTING PROCESS
  • Booting sequence
  • Booting from A Floppy Disk
  • Booting from A Hard Disk
  • Warm and Cold Boot
  • System Date and Time
  • COMMAND
  • Syntax
  • DOS Command, Syntax, switches and examples
  • Important Notes
  • 2 TIME
  • Important notes
  • 3 CLS
  • 4 PROMPT
  • Meta-string

Creating Subdirectories, changing directories, listing & searching files

  • Hierarchical Directory System
  • ROOT
  • Path
  • DOS COMMANDS

Methods to display the contents of a text file

  • TYPE
  • Renaming of file(S)
  • Copying files
  • Switches
  • Copy concatenating

File operations using DOS Commands

  • Creating a new file using copy con command
  • Comparing Files: FC
  • Search Specific Lines in a File
  • Graphically Display Structure of a directory
  • Copy Group of Directories and Sub-Directories
  • Remove Directory

I/O operations

  • I / O re-direction
  • Print screen
  • Character echoing
  • File printing
  • FORMAT message
  • Safe Formatting
  • Using one drive for copying                                              

Attrib and simple batch file

  • ATTRIUTES
  • Using Scandisk

Invoking \ Closing Application(s) from Window XP desktop

  • Starting window XP
  • Components of windows DESKTOP

Creating and working with folder and text file

  • Creating a new folder
  • Working with folder shortcuts and customizing icons
  • Create and Edit ASC II Text files using Notepad
  • Creating a new document
  • Editing an Existing Text Document
  • Moving around the text
  • Selecting text
  • Cut, Copy and Paste
  • Deleting the text

Working with files, folders and drives

  • Viewing contents of My Computer
  • Understanding contents of My Computer
  • Invoking windows explorer application
  • Changing the working folder
  • Changing the working drive
  • Scrolling the window
  • Changing the icon viewing arrangement
  • Tiles
  • Icon
  • List
  • Details
  • Thumbnails
  • Filmstrip
  • Show in Groups
  • Copy files \ folders to floppy diskette
  • Format Floppy Diskette
  • Format options

Working with system setting (control panel ) -1

  • Accessibility options
  • Display
  • Fonts
  • Keyboard
  • Modems
  • Multimedia
  • Networks
  • Ports
  • Printers
  • Regional setting
  • SCSI Adapters
  • Server
  • Service
  • Sounds
  • System
  • Tape Devices
  • Telephony
  • UPS
  • Date and Time properties
  • Changing the wall paper and screen savers
  • Screen saver setting
  • Appearance of window
  • Working with keyboard
  • Working with mouse
  • Selecting Cursors and pointers
  • Controlling the motion of the mouse
  • Regional setting

An Introduction to MS – ACCESS

  • What is Microsoft Access?
  • Access XP vs. Access 2000
  • What are tables?
  • Getting stared
  • Blank Access database
  • Open an existing database
  • Database window
  • Create a table in design view  
  • Field properties
  • Primary key

Datasheet Records - I

  • Adding records
  • Moving Around in a Table
  • Editing records
  • Deleting records

Datasheet Records – II

  • Resizing Rows and Columns
  • Hiding Columns
  • Freeing Columns
  • Finding data in a table
  • Replace
  • Check spelling and AutoCorrect
  • Print Data sheet
  • Creating table & table wizard
  • Access offers 2 methods for creating a table
  • Sorting

Data validation

  • Indexes
  • Validation Rules
  • Validation Rules for field
  • Validation Rules for table
  • When to use validation rules
  • Field’s validation rule
  • Table’s validation rule
  • Limitations
  • Input Masks

Filters

  • Saving a Filter             

Forms

  • Views in the Form window
  • Creating new forms
  • Form Wizards
  • Creating forms from scratch
  • The Toolbox
  • Reviewing controls
  • The controls most often used in Access are
  • The properties window
  • Form window
  • The field list
  • Form selections
  • Form controls
  • What are controls?
  • Basic types of controls
  • The Toolbox
  • The properties Window
  • Individual controls
  • Text Boxes and Labels
  • Yes \ No options
  • Drop – Down Boxes
  • Graphics objects and Sub forms
  • Layout Enhancement Controls
  • The field list
  • Selecting, Moving, and Sizing Controls
  • Aligning Controls
  • On-The-Fly Control Switching

Reports

  • The report wizards
  • WORKING WITH REPORTS
  • Sections
  • Controls
  • The Toolbox
  • The Properties window
  • Types of control
  • Combo box
  • Selecting, moving and sizing controls

Query

  • What is query?
  • Common types of queries
  • Select query
  • Parameter query
  • Action query
  • Crosstab query
  • View in query window
  • Query wizard
  • The bob villa method
  • To create  a query without query wizards
  • Avoid the Cartesian product
  • Using the query design window
  • Query by example grid
  • Adding fields to the QBE grid
  • Rearranging, inserting and deleting fields
  • To move a field or fields
  • To insert a field
  • To delete a field
  • Renaming  a field
  • Specifying criteria
  • Entering expressions
  • Using the expressions builder
  • Common types of expressions
  • Using” Or”
  • Using “And”
  • Using wildcards
  • Blank field searches
  • Ranges of records
  • Creating calculated fields
  • Using the totals button
  • Query properties
  • Parameter Queries
  • To create a parameter query
  • Viewing a dynast

Relationship

  • Creating a relationship
  • Referential integrity
  • Cascading update \ delete operations
  • Types of relationships
  • Join types

Integrated Development Environment

  • Menu bar
  • Tool bar
  • Project Explorer
  • Properties window
  • Object Browser
  • Object naming conversions of controls
  • Modules
  • Data types in visual basic
  • Numeric
  • String
  • Date
  • Boolean
  • Variant
  • New project window
  • Toolbar
  • Visual basic-Definitions
  • Tool box
  • ADODS
  • ADD-INS
  • Visual Data Manager
  • Dynaset
  • Record source
  • Microsoft jet database engine
  • Importing and linking

Data base backup and Recovery

  • Database Backup
  • Database Backup and recovery needs
  • Backup and recovery and database failure
  • Backup and recovery and disaster

Apply for Certification

https://www.vskills.in/certification/Vskills-Certified-Database-Processing-Operator