Certified Database Processing Operator

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

Write a review