CONCEPTS OF DATABASE –MS-ACCESS by owen213

VIEWS: 77 PAGES: 4

									                                     DCA (DIPLOMA IN COMPUTER APPLICATION)
                                                I-SEMESTRE
                                        Concepts of Database (MS-ACCESS)

Unit-1: Introduction to MS-ACCESS
    Introduction,The Database Window,Elements of an Access Database
    Creating a Database,Table, Records, Fields and Fields types in ACCESS,Build Database Table,Create a New Table in Design
    View,Add, Move, Insert, Delete a Field & Adding Key Fields,Creating the Relationship between Tables,Enter, View, Find and
    Sort Data,Open a Table in Datasheet View & Move through a Table
Unit-2: Working with Forms
    Introduction,Use Auto Forms and the Form Wizard,Understand the Auto Forms
    Creating an Auto Form,Show Data from two Tables with a Query,Create a Form with the Wizard,Show Selected Records with a
    form & Customize Forms,The Form Design View Window,Customize a Form’s Layout & Form Design View,Use a Tab
    Control, Sub Form & Form Templates
Unit-3: Create and Customize Reports & Charts
    Introduction,The New Report Option & AutoReports,The Label Wizard & The Report Wizard,Preview a Report & Print a
    report,Report Design View, Sort and Group Report Records,Add Calculated and Summary Fields to a report,Report on Selected
    Records,
Unit-4: Find Data with Filter and Queries
    Introduction,The Difference between Filters and Queries,Filter Records using One Filed and One Value,Filter Using Multiple
    Criteria,Formulate and Advance Filter,Apply, Remove or Save a Filter,Find records with a Selected Query & Run a Query
    Switch Back to Query Design View & Look for Special Criteria,AND Vs. OR Queries, Save and Change Queries,Query Linked
    Tables,Master Advance Queries,Add Remove from One table to Another

                                            Fundamental of Computers
Unit I: History and evolution of computers
    Computer:Definition, Merits of Computer.Computer System & Components: Hardware, Software.Classification of Computer : .
    Demerits of Computers,Working -: Digital, Analog, Hybrid b. Size : Mainframe, Mini, Micro.History & Generation Of
    Computers :Brief description of History of Computer, Generation of Computer
Unit2-Hardware concept of computer (Input /Output )
    Input & Output Devices:Input Devices : keyboard, Mouse, Joystick, Bar Coding, Omr, Ocr, Micr,Output Devices : VDU, Printer
    : Impact & Non Impact printer, Plotter
Unit 3- Memory organization of computer(Primary memory and secondary memory)
    Storage Devices,Units of Memory, Definition and use of memory & its types,Primary Memory : Ram, Rom & its
    types.Secondary Memory : Floppy, HDD, Magnetic optical disk
Unit 4-Software concept (Application and system software)
    Software : Definition, type,Computer Languages : High level, low level & middle level languages
Unit 5-- Data representation in computer and codes (Number System ,Conversion)
    Number System,BCD, ASCII, EDCDIC ii. Binary, Octal, Hexadecimal ,Conversion method,Arithmetic operation on binary
    digits
Unit 6-File and their organization in computer System
    File Organisation & Processing System,File content, types of file organisation.
Unit 8-Computer security and virus and ethics
    Security aspects of computer education,Threats to computer security,Site planning,Computer Virus : Definition, types,
    Characteristics & its prevention Administrative control
Unit 9-WINDOWS:
    Introduction to windows, overview of different of windows,
    Basic element of windows, customizing windows, working with windows, exploring control panel,managing files and folders,
    windows accessories.




                                                              1
                                                           MS -OFFICE

Unit- 1: Paint
     Tool box , Editing Color box, Changing color choice, Defining Custom color ,Resizing the drawing screen , Saving a drawing
Unit- 2: Word Pad
      Selecting text with keyboard and mouse , Moving and copying text Cut, paste and copy buttons,Finding and replacing text ,
Adding bullets, Changing page attributes ,Adding graphics Saving
     document
Unit- 3: Windows Explorer
      Working with Explorer tool bar , View menu , Creating a new folder , Recycle Bin , Retrieving a deleted file ,Miscellaneous
window features , Uses of My Computer icon
Unit- 4: Control Panel Adding new hardware,Add or Remove Programme ,Date/time,Display,Font Keyboard
,Modem,Mouse,Multimedia ,System,Users
Unit-5: MS-Word Introduction Working with Word,MS – Word Screen ,Opening or creating a document ,Working with a document
file,Opening or Creating a new file ,Saving a file,Closing a file,Text Editing,Text and background color ,Borders ,Space between
characters, Change case ,Moving text ,Copying text ,Undo, redo and repeat functions
Document Formatting
Introduction ,Paragraph Setting : Alignment, Line spacing, Paragraph spacing, Paragraph,Borders and Shading,Drop cap,Bullets and
numbering Tab setting,Find and Replace,Spelling and Grammar,Auto text and Auto Correct ,Word Count,Page break,Columns
 Inserting tables and objects
Introduction, Table : Inserting a table and moving around table, adding text in cells , selection of columns and rows, inserting a
deleting a row/columns, setting size of column/row, table border, merging cells., Inserting Objects : Date and time, symbols,
drawings and picture.
Printing and Mail Merge Introduction ,Page setup, Print preview,Printing the document ,Creating Main document ,Creating data
source, Editing data source, Mail Merging main document and data source
Views, Styles and Protecting document Views: normal, web layout and print layout ,Styles ,Templates,Protecting the document
Unit-6: MS- Excel
Excel Basics Introduction ,Starting with MS-Excel ,MS-Excel Worksheet Screen,Working with Cell Defining Formula
Functions & Operators Importance & Use of functions ,Mathematical & Statistical functions,Date and time functions Text
functions ,Logical functions,Importance & Use of Operators ,Arithmetic OperatorComparison Operators,Text & Reference Operators
,Formatting Cells, Handling Files & Range Names,Inserting Graphics and Charts ,Data Processing with Excel ,Data Processing with
Excel Printing, File Protection & Auditing
Unit-7: MS- PowerPoint
Basics of Power Point Introduction ,MS-Power Point Screen,Working with MS-Power Point – Standard Toolbar, Formatting
Toolbar& Drawing Palette Creating a Presentation Selecting & Changing slide Layouts,Editing a slide and working with
slides,Applying Templates,Power Point views Built-in Wizards
Inserting Objects
     Introduction ,Inserting Pictures,Slide Show & Slide Transitions,Text Build ,Graphs,Tables,Organizational Chart,Animation &
     Inserting Sounds
                                                  PROGRAMMING IN C
           Unit-1:PROGRAMMING WITH C (PART-A) : Introduction Charcterset, Indentifiers And Keywords, Variables,
           Displaying Variables, Reading Variables, Character And Character, String, Qualifiers, Type Define Statements, Value
           Inetialized Variables, Constants, Constant Qualifier, Operators And Expressions, Operator Precedence And Associativity,
           Basic Input Output, Single Character I/O General Outputs, Types Of Characters In Format String, Scanf With Specifier,
           Searchset Arrangements And Supression Character, Format Specifier For Scanf. Control Structure: If-Statement, If Else
           Statement, Multiway Decision, Compound Statement, Loops: For-Loop, While-Loop, Do-While Loop, Break Statement,
           Switch Accepting More Than One Parameter, User Defined And Library Function, Concept Associativity With Functions,
           Function Parameter, Return Value, Recursion Comparisons, Of Lteration And Recursion Variable Length Argument List.
           Unit-2: PROGRAMMING WITH C (PART-B) : Scope Rind Extent, Arrays, Strings, Multidimensional Arrays, Strings,
           Array Of Strings, I Function In String, Pointers: Definition, And Use Of Pointer, Address Operator, Pinter Variable,
           Referencing Pointer, Void Pointers, Pointer Arithmetic, Pointer To Pointer, Pointer And Arrays, Passing Arrays To
           Functions, Pointer And Functions, Accessing Array Inside Functions, Pointers And Two Dimmensial Arrays, Array Of
           Pointers, Pointer Constants, Pointer And Functions, Accesing Array Inside Functions, Gbinters And Two Dimensional
           Arrays, Array Of Pointers, Pointer Constants, Pointer And Strings.
           Unit-3: Programming With C (Part-C) : Structure And Union, Declaring And Using Structure, Structure, Structure
           Intialization, Structure Within Structure, Operations Of Structures, Array Of Structure, Array Within Structure Creating
           User Defined Data Type, Pointer To Structure And Function.Union, Difference Between Union And Structure, Operations
           On Union, Scope Of Union. Dynamic Memory Allocation. Library Function For Dynamic Memory Allocation, Dynamic
           Multi-Dimensional Arrays, Self-Rcferential Structure.
            Unit-4: File: Introduction, Structure, Filehandling, Functions File Types, Unbuffered And Buffered File “Error Handling.
           Low Level Five Input-Output.




                                                                 2
                                          DCA (DIPLOMA IN COMPUTER APPLICATION)
                                                          II SEMESTER
                                                     Desk Top Publishing (DTP)

Unit -1: PAGE MAKER
File:New, Open, Close, Save, Save as, Revert, Export, Place, Links, Books, Preference, Page Setup, Print, Exit.
Edit:Undo, Cut, Copy, Paste, Clear, Multiple Paste, Select all, Paste link, Paste Special, Insert Object, Edit Story, Edit Original,
Utilities:Find, Find Next, Change, Spelling, Index Entry, Show Index, Create Index, Create Doc,LayoutView all option, Guide &
rules all option, Column guide, Go to pages, Insert Pages, Remove Pages, Copy master guide, Auto flow
Type:Font, Leading, Set width, rack all option, Type style, Type Space, Paragraph Indents Tabs, Hyphenation, Alignment, Style,
Define Styles
Element:Line, Fill, Fill & Line, Bring to Front, Sent to back, Remove trans format, Text wrap, Image control Rounded Corners,
Define colors, store original color
Windows:Arrange Icons, Tile, Cascade, Toolbox, Style Palette, Color Palette,Control Palette, Library Palette

Unit-2: COREL DRAW
 Concept &Working :Tool Box,Pick tool, shape tool, Zoom tool all option, Freehand tool, Rectangle tool, Ellipse tool, Artistic text
tool, Out line tool all option, Fill tool all option
File:New, Open, Save, Save as, Import, Export, Mosaic Roll up, Print, Print Setup, Exit,
Edit:Undo, Redo, Repeat, Cut, Copy, Paste, Paste Special, Delete, Duplicate, Clone, Copy Attributes From, Select all, Insert Object
View:Rulers, Toolbox, Visible, Floating, Color Palette all option, Roll ups, Wire frame, Bitmaps, Color correction, Full screen
preview, Preview Selected only, Refresh, Window
Layout:Insert Page, Delete Page, Go to Page, Page setup, Layer Rollup, Styles Rollup, Grid & Scale Setup, Guidelines Setup, Snap to
grid, Snap to guidelines, Snap to Objects
Arrange, Align, Order all option, Group, Un group, Combine, Break Apart, Weld, Inter Section, Trim, Separate, Convert to curves
Effect:Transform Roll up, Clear Transformation, Add Perspective, Envelop Rollup, Blend Rollup, Contour Roll up, Power line
Rollup, Lens Rollup, Power clip all option, Clear effect, Copy all option, Clone all option
Text:Text Roll up, Character, Paragraph, Frame, Fit text to path, Align to baseline, Straighten text, Type Assist, Spell Checker,
Thesaurus, Find, Replace, Edit text,
Special:Preference, Symbols Rollup, Preset Rollup, Create Pattern, Create Arrow, Create Symbol,

                                               Object Oriented Programming C+

         Unit 1: Concepts of Object Oriented Programming             Software Crisis &Software Evolution ,A look at Procedure Oriented
         Programming ,Object Oriented Programming Paradigm ,Basic Concepts of Object Oriented Programming, Benefits of OOP’s &
         Applications of OOP’s ,Object Oriented Language
         An Overview of C++
                    What is C++ ,The Origins of C++ & Applications of C++ ,A simple C++ Program ,Creating, the source file, Compiling
                    and Linking, Running the Programme & Programming Style.
         Unit 2: Token, Expression, Control Structure and Functions in C++,Character Set & Keywords, Identifiers, Variables,
         Constants & Symbolic Constants, Basic Data Types & User Defined Data Types, Derived Data Types & Type Compatibility,
         While Space, Escape Sequence & Manipulators, Declaration & Dynamic Initialization of Variables, Reference Variables, Type
         Cast Operators and storage types, Operators in C++, Scope Resolution operators & Precedence of Operators, Member
         Dereferencing Operators & Memory Management Operators, Input & Output Statements, Arrays, Enumerated Data Types &
         Structures ,Decision making Statements ,Control Statements, Functions in C++, inline and friend functions.
         Classes, Objects, Constructors & Destructors
         Introduction, Specifying a class, Private, public and protected, Arrays of objects and objects as function arguments,
         Constructors and multiple constructors in a class, Parameterized, copy and dynamic constructors, Destructors and overloaded
         constructors.
         Unit 3: Operator, function overloading and Type conversion Introduction ,Defining operator overloading ,
         Overloading unary and binary operators.
                   Rules for operators overloading and multiple overloading ,Function overloading & Type conversion.
         Unit 4: Inheritance, pointers and graphics
              Introduction ,Derived Class and Base Class ,Single, Multilevel, Multiple, Hierarchical and Hybrid Inheritance ,Virtual
              base classes, abstract classes ,Constructors in derived classes and member classes ,Addresses and pointers
              ,Pointers to objects and “this pointers” ,Pointers to derived classes ,An array of pointer to objects ,Pointer to pointes and
              debugging pointers ,Linked lists for storing data ,Introduction to stags, queues and trees ,Graphics and C++ &
              Inheritance in Graphics
          Unit 5: Polymorphism, virtual functions, templates and exception handling
              Introduction, Polymorphism, Virtual and Pure virtual functions, Templates, Class Templates and function templates,
              Member function templates and template arguments, Exception handling




                                                                    3
                                                           DIGITAL ELECTRONICS

Unit-1: Number System And Codes:
Introduction, Number System (Binary Numbers, decimal-binary conversion, Octal Numbers, Octal-Binary Conversions, Hexadecimal Numbers,
Hexadecimal-Binary
conversions, Hexadecimal-octal conversions), Floating Point Representations of Numbers, Arithmetic Operations (Binary Arithmetic), 1’s and 2’s
Compliment (1’s
Compliment Subtraction, 2’s Compliment Subtraction , Addition in the 2’s compliment System, Subtraction in the 2’scompliment system,
Unit-2: Boolean Algebra:
Basic Laws of Boolean algebra (Boolean addition, Boolean Multiplication, Properties of Boolean Algebra, Demorgan theorems, Sum of Products and
Product of Sums, (Minterm Maxterm, Deriving Sum of Products(SOP) Expression from Truth Table, Deriving Product of Sum(POS) Expression from
Truth Table, Karnaugh Map (Two variable, Three variable).
Unit-3:Logic gates:
Logic gates (OR Gate, AND Gate, NOT Gate, NAND Gate, NOR Gate, Ex- OR Gate,Ex-NOR Gate).
Unit-4: Arithmetic Circuits:
Half Adder, Full Adder, Half-Subtractor, Full Subtractor, Combinational Circuits: Multiplixers, Basic four input multiplexer, Demultiplexers, 1 to 4
demultiplexer,
Decoders, Basic Binary decoder, 3 to 8 decoder, Encoders : Decimal to Binary Encoder.
Unit-5:Flip Flops:
Introduction, Flip Flops, Types of Flip-Flops, S-R Flip-Flop (NOR Based, NAND Based),Clocked S-R Flip-Flop, D Flip-Flop, J-K Flip-Flop
Unit-6: Memories:
Introduction, Classification of memories, Registers, Main Memories and Secondary Memory, Sequential Access Memory And Random Access
Memory, Static and Dynamic Memory, Volatile and Non Volatile Memory, Magnetic and Semiconductor Memory,
Basic Memory Structure. operations in dequeue



                                             INTERNET AND WEBSITE MANAGEMENT

     Unit-1: Introduction to INTERNET:Introduction,History of Internet,Communicating on the Internet
     Connection types,Internet Service Providers ,How does the Internet Works?What you can do with Internet,Internet Domains,Web Browsers

     Unit-2 Internet Protocols:How IP addressing came into existence,TCP/IP,Client IP Address,How client IP address are assigned,How ISP’s
     achieve this,Getting a temporary IP address,WWW,Telnet,FTP

     Unit-3 Search Engines
     Introduction,Functions Popular Search Engines

     Unit-4: Internet Relay Chat (IRC):Introduction,Chatting-code & Behaviour ,Safe Chatting Rules,Web Based Chatting
      Electronic Mail:Introduction,Advantages of e-mail,How e-mail works,E-mail options
     E-mail through ISP,Web based free e-mail,BBS based messaging ,E-mail tipsE-mail software
     Microsoft Outlook Express,Features,Steps to setup an e-mail accountsssSending and receiving an e-mail,Netscape
     messenger,Creating and Managing web based free e-mail
     Unit-5: Setting up Internet On a PC:Dialup Networking,Installing TCP/IP,Conferring TCP/IP parameters,Setting up new
     connecting,Testing Internet Connection
     Unit-6: An Introduction to HTML
     Introduction,History of HTML,SGML,Structure of HTML document,Switching between your Editor and Browser,HTML
     Tags,Paired Tags
     The structuring your web page,Document Head,Document Body,Commonly used HTML Commands,Titles and Footers,Adding
     Comments
     Text Formatting,Emphasizing Material in a web page,Text Style Others Text effects
     Unit-7: Lists
     Creating Lists,Types of Lists,Nesting Lists,Controlling how ordered lists are displayed,Creating multilevel outline,Controlling
     the display of unordered list,Creating Link Lists
     Linking Documents: Links,External Document References,Internal Document References,Images as Hyperlinks,Using a
     Background Image
     Tables: Introduction,Header,Data rows,The caption tag
     Frames & Forms: Introductions to Frames,The frameset tag,The frame tag,Targeting Named Frames,Forms.




                                                                         4

								
To top