Follow Us:

DIT - Diploma in Information Technology

DIT - Diploma in Information Technology

Diploma in Information Technology is 1 year diploma program offered by Board of Technical Education (BTE) KPK.

  1. ICT-Information & Communication Technology
  2. Computer Programming C/C++
  3. CN-COMPUTER NETWORK
  4. O.A- Office Automation
  5. OS-Operating System
  1. Computer Hardware & Software
  2. Web Development (WordPress)
  3. Facebook Marketing
  4. Computer Typing
  5. Freelancing
  1. E-Commerce & Web Technology
  2. Introduction Database
  3. Microsoft Access
  4. Graphic Design
  5. Project
  1.  Six- Months Physical On House base job.

1St - Semester

ICT-Information & Communication Technology

Objective

This course provides an overview of computing and computer science, including such topics as the history of computers, computer application, and basic understanding of various hardware components. Hands-on experience in installation and configuration is included. Students learn how software interacts with and controls the computer’s hardware elements. Analytical logic and troubleshooting skills are emphasized. Basic networking concepts are introduced.

• Introduction with Students
• Introduction of ICT and IT
• Benefits of ICT
• What is Data
• What is Information
• Different Between Data and Information
• Types of Data
• Data Processing Cycle
• Classification of Data Processing System?
• Manual Data Processing
• Electronic Data Processing
• What is Information Technology? Discuss the Element of IT
• What is Computer
• Advantages of Computer and Disadvantages of Computer
• Types of Computers with respect to Internal Structure
• Types of Computers with respect to size
• Mainframe Computer
• Mini Computer
• Micro Computer
• Super Computer
• Types of Computers with respect to purpose
• General Purpose Computer
• Special Purpose Computer
• Generation of Computer

• Discuss Components of Computer
• Central Processing Unit
• Control Unit
• ALU Unit
• Input Unit
• Output Unit
• Storage Unit
• RAM
• ROM
• Define Input Devices (Divided into three Parts)
• Keyboard
• Pointing Device
• Mouse
• Track Ball
• Joystick
• Touch Screen Sensitive
• Pen Based Computer (Light Pen)
• Voice Recognition
• Microphone
• Video Camera
• Digital Camera
• Optical and Magnetic Recognition
• Optical Scanning
• Scanner
• Output Devices
• Monitor
• Monochrome Monitor
• Color Monitor
• Flat Panel or LCD Monitor
• Printer
• Impact Printer
• Dot-Matrix Printer
• Daisy Wheel Printer
• Non-Impact Printer
• Laser Printers
• Ink Jet
• Plotters
• Speaker and Headset
• Primary Memory
• Secondary Memory
• Magnetic Storage Device
• Floppy Disk
• Hard Disk

• Magnetic Tape Storage
• Optical Storage Device
• CD Room
• Digital Video Disk (DVD)
• Worm Disk
• Rewritable Optical Disk
• PC Card
• Smart Cards
• Software
• System Software
• Utility Program
• Language Translator
• Device Drive
• Application Software
• General Purpose Software
• Special Purpose Software
• Algorithm
• Algorithm Notation
• Flow Chart
• Types of Flow Chart
• System Flow Chart
• Program Flow Chart
• Word Processing Packages
• Difference Between Manual Word Processing and Electronic Word Processing
• Spreadsheet
• Database Management Packages

Introduction to Number System
• Types of Number System
• Decimal Number System
• Binary Number System
• Octal Number System
• Hexadecimal Number System
• Conversion from Number to another Number with examples
• Impact of Computer on Society
• Positive Impact
• Negative Impact
• Application of Computer (USES)
• Computer in Office
• Computer in Hospital
• Computer in Bank
• Computer in Education
• What is Artificial Intelligence
• What is CAM and CAD
• Robotics
• Expert System
• Virus
• Anti-Virus

CN-COMPUTER NETWORK

Objective

A computer network is defined as interconnected collection of autonomous computers. Computer are said to be interconnected, if they able to exchange information. Connection is physically established through cables, lasers, microwaves, fiber optics and communication satellite.

• What is Network & Networking?
• Advantages of Computer Network
• Disadvantages of Computer Network
• Explain Types of Networks
• What is LAN?
• What is WLAN
• What is MAN
• What is WAN
• Communication & Discuss the elements of Data Communication?
• Sender
• Message
• Medium
• Receiver
• Protocol
• What is Transmission Mode and Discuss the types of Transmission Mode
• Simplex Transmission Mode
• Half Duplex Transmission Mode
• Full Duplex Transmission Mode
• Basic Network Terminologies
• Data
• Data Rate
• Baud Rate
• Peak Data Rate
• Bursty Data

• What is Topologies Explain its types
• Bus Topology (Advantages and Disadvantage)
• Ring Topology (Advantages and Disadvantage)
• Start Topology (Advantages and Disadvantage)
• Mesh Topology (Advantages and Disadvantage)
• Hybrid Topology (Advantages and Disadvantage)
• Networking Device
• Node
• Network Interface Card (NIC)
• Modem
• Access Point
• HUB
• Active HUB
• Passive HUB
• Switch
• Bridge
• Router

• What is Transmission Media
• Bounded / Guided Media / Wire Media
• Twisted Pair Cable
• STP
• UTP
• Coaxial Cable
• Fiber Optic Cable
• Un Bounded / Un Guided Media / Logical Media
• Microwave Transmission
• Radio Transmission
• Infrared Transmission
• Types of Connectors
• RJ-45
• RJ-11
• BNC
• What is OSI Model
• Layers of OSI Model

• Application Layer
• Presentation Layer
• Session Layer
• Transport Layer
• Network Layer
• Data Link Layer
• Physical Layer
• What is IP address
• Types of IP
• IPV4
• IPV6
• Classes of IPV4
• Class – A
• Class- B
• Class-C
• Class-D
• Class-E
• Subnet Mask

OS-Operating System

Objective

We will begin this course with a high-level introduction to Operating Systems (OS). The Operating System acts as a platform of information exchange between your computer’s hardware and the applications running on it. Most people are familiar with the Windows Operating System family (like Windows 10, XP, or Vista) or Apple’s suite of Operating Systems (like Catalina, Mojave, or Sierra), but for the purposes of this course, we will focus on UNIX: the open-source OS deployed all over the world in both personal and commercial systems. First, we will start with a discussion on some of the earliest Operating Systems, including those which are considered precursors to the Operating Systems that we are familiar with today. Then, we will review the general OS structure and give a basic functional overview.

• Introduction to Operating System
• Function of Operating System
• Types of Operating System
• Single User Operating System
• Single User Single Task Operating System
• Single User Multi Task Operating System
• Multi User Operating System
• Types of Operating System Based on Interface
• Command Line Interface
• Graphical User Interface
• Menu Drive Interface
• Desktop Based Operating System
• Server Based Operating System
• Explain Popular Operating System
• DOS
• Windows 95,98, ME
• Windows XP
• MAC
• What is Scheduling
• Preemptive
• Non-Preemptive
• FIFO
• LIFO
• SJF
• SJN
• RR

• What is Deadlock
• Necessary Conditions
• Mutual Exclusion
• Hold and wait
• Circular wait
• Windows Seven
• Installation of windows Seven
• Disk Management tool in windows seven
• Create new partition on a windows 7 Hard disk
• Configure Device and Printer in windows 7
• Configure network connectivity
• Computer Network connecting to wireless networks with windows 7
• Secure windows 7 client computer
• Configure Remote Desktop Access on windows 7 Systems
• Requirements for windows server 2008
• Installation of windows server 2008

• What is Active Directory and Domain Serveries
• Installation of Active Directory and Domain Serveries
• Remove Active Directory and Domain Serveries
• What is DNS Server
• How to install DNS Server in windows server 2008
• How to Create a user in windows server 2008
• Introduction to Group
• Managing User Group
• What is Organizational Unit
• Create Organizational Unit
• What is Group Policy
• Create Group Policy
• Backup with windows server 2008
• What is Linux Operating System
• History of Linux Operating System
• Feature of Linux Operating System

• Installation of Linux Operating System
• Linux File System
• Create a user in Linux Operating System
• Installation of Application in Linux
• Basic Command
• MKDIR
• RM
• RMDIR
• Kill
• Head
• Tail
• Cat
• Echo
• Date
• Time
• IS
• Man
• Read
• Cal
• Wall
• Jobs
• Zip
• Unzip
• Mv
• Cd
• Pwd
• clear

Computer Programming C/C++

Objective

Hundreds of computer languages are in use today, C/C ++ is one of them. It is one of the most powerful, general-purpose high-level programming language. It is a versatile language. This language can be sued for almost any programming task. The purpose of including this subject in DIT course is to enable the students to develop application programs in various fields such as business, education, accounting, database management etc.

• What is Language
• Types of Language
• What is Programming Language
• What is C and C++ Language
• Advantages of C Language
• What is the weakness of C Language?
• History of C Language
• Difference between C and C++
• Structure of C/C++ Program
• Give an example of C and C++ Program
• What is Character Set in C/C++?
• What are Reserved words in C/C++

What is User defining Words
• What is Variable
• Types of Variables
• What is C/C++ Operator
• What is C/C++ Expressions
• What is C/C++ Statements
• What is C/C++ comments
• What is C/C++ Libraries
• What is C/C++ Data Type
• What is the Size of Operator?
• Declaring Variable and Constants
• Assignment and Multiple Assignment Operator
• How to Assign String data
• Priority of Operator
• Types of Casting Operator

• What is the Increment and Decrement Operator?
• Compound Assignment Operator
• Give an example of Increment and Decrement Operator
• What are the Puts () String Function?
• What is the Scanf () Function
• What is the gets () Function
• What is getchar (), getch () and getch () Function
• Input using Cin
• What is the Printf () Function
• What is clrser () Function
• What is cout () Function
• What is Putsch () and Putchar () Character Function
• What is Transfer of Control Protocol?
• Relational Operator
• Condition Operator
• Multiple Choice Statement (Switch / Case / Break / Default)

• What is Loop
• Types of loops
• For Loop
• While Loop
• Do while Loop
• Trigonometric Function
• Sin () cos () tan () etc
• Arithmetic Functions
• Abs () sqrt () log () exp () ceill () floor () pow () pow 10 () random () rand () etc
• String Functions
• Strlen () Strlwr () strupr () strrev () strncpy () strecat () strncat () etc

O.A- Office Automation

Objective

Video provides a powerful way to help you prove your point. When you click Online Video, you can paste in the embed code for the video you want to add. You can also type a keyword to search online for the video that best fits your document.
To make your document look professionally produced, Word provides header, footer, cover page, and text box designs that complement each other. For example, you can add a matching cover page, header, and sidebar. Click Insert and then choose the elements you want from the different galleries.

• Getting Started with Microsoft Word
• Creating a basic document
• Enter text
• Saving a new document
• Preview document
• Print document
• Online help
• Editing a Document
• Insert text
• Select text
• Create an auto text entry (using rand formula)
• Move and copy text
• Delete text
• Undo changes
• Find and replace text
• Formatting Text
• Apply font styles and effects
• Change text color
• Highlight text , Bulleting text
• Formatting Paragraphs
• Set tabs to align text
• Control paragraph layout
• Add borders and shading , Apply styles
• Adding Table
• Create a table
• Modify the table structure
• Format a table
• Table toolbar
• Header and Footer
• Understanding header and footer
• Creating / editing header and footer
• Insert page number / text on header & footnote and endnote option menu , Creating / editing
• Footnote and endnote
• Drawing Toolbar – Word Art
• Use of Drawing toolbar
• Use of auto shape
• Adding shadows and text to a shape
• Working with textbox object
• Create word art
• Advanced word art
• Create Word Macros
• What is a macro
• Create a macro
• Assign a macro to the keyboard, Delete your macro
• Proofing a Document
• Check spelling, grammar and word count
• Customize autocorrect options

• Microsoft Excel
• Getting Started With MS Excel
• Excel rows and columns
• Workbook & worksheet
• Enter text and numbers in a cell
• Edit text in a cell
• Cell formatting
• Font formatting
• Merge cells, Save your work
• Formulas and Functions
• Entering formulas
• Copying data and formulas
• Using AutoSum
• Understanding functions
• Using simple aggregate functions (Sum, Count, Average, Min, Max)
• Copying formulas
• Editing Features
• Using cut , copy, and paste operations
• Using paste special with values
• Selection techniques , Navigation techniques
• Working with the Large Workbooks
• Freezing and unfreezing panes , Splitting windows
• Inserting page breaks for printing- Working with Charts
• Creating charts using Chart Wizard , Creating different types of charts
• Including titles and values in charts , Formatting of charts
• Inserting Graphic Objects
• Insert and modify pictures and clipart
• Draw and modify shapes
• Illustrate workflow using SmartArt Graphics
• Previewing and Printing
• Previewing worksheets
• Page setup
• Printing of worksheets in multiple pages
• Repeating rows and columns for multiple pages, Printing multiple worksheets
• Simple Database Operation
• Sorting tables
• Filtering data with auto filter
• Referring data from other worksheets , Create hyperlinks
• Analyzing Data Using Pivot Tables and Pivot Charts
• Create a pivot table report
• Analyze data using pivot charts

Microsoft PowerPoint
• Getting Started
• Microsoft Office Toolbar
• Quick Access Toolbar
• Mini Toolbar
• Creating a Presentation
• New Presentation
• Save a Presentation
• Add Slides
• Theme
• Working with Content
• Enter Text
• Copy and Paste
• Cut and Paste
• Undo/Redo
• Spell Check
• Formatting Text
• Change Font Typeface and Size
• Font Styles and Effects
• Change Text Color
• WordArt
• Change Paragraph Alignment
• Indent Paragraphs
• Text Direction
• Adding Content
• Resize a Textbox
• Bulleted and Numbered Lists
• Nested Lists
• Formatting Lists
• Adding Video, Adding Audio
• Graphics
• Adding a Picture
• Adding ClipArt
• Editing Picture and ClipArt
• Adding Shapes, Adding SmartArt
• Tables
• Create a Table
• Enter Data in a Table
• Format a Table
• Insert a Table from Word or Excel
• Charts
• Create a Chart
• Edit Chart Data
• Modify a Chart
• Chart Tools, Paste a Chart from Excel
• Slide Effects
• Slide Transitions
• Slide Animation, Animation Preview
• Printing
• Print a Presentation

Projects
• CV Design
• Letter Head
• Reports
• Book Cover
• Time Table
• Datasheet
• Paper Composing
• Book Composing
• Job letter
• Application
• Certificate
• Resume Design
• Daily Plan
• Lesson Plan
• Organization Reports

2nd - Semester

E-Commerce & Web Technology

Objective

This course provides complete knowledge of E-commerce with an intensive survey of. Technologies used to support all aspects of electronic Commerce & E-business requirements. This course provides a complete training of Dream viewer tool that. Provides a platform to implement these practices and enables students to make a. complete website that will help the students to move in a marked confidently.

• Introduction to E-Commerce.
• The difference between e-commerce and e-business
• Unique features of e-commerce technology
• Types of e- commerce.
• Element of a business model
• Business- to consumer (B2C) business models
• Business-to- business (B2B) business models
• Introduction to web Technologies
• Fundamental of internet and www concepts.
• Protocols (HTTP, FTP, IP, TCP,)
• Domain Names (com, edu, org, net, mil, sip)

• Introduction to HTML
• Introduction
• A Text Editor
• A Web Browser
• Creating First HTML Document
• Html Tag, Head Tag, Title tag, Body Tag, Heading Paragraph Tag, Line Break Tag, Horizontal Rule Tag, Font Size
• Marking Stylish Pages
• Bold Tag, italic Tag, Underline Tag, Typewriter Tag, Big Tag, Small Tag, Emphasis Tag, Citation Tag, Strong Tag, Lists Unordered List, Order List
• Graphics in web page
• Image source Tag, Linking to local Files, to section of a page, Blink Tag, Marquee Tag,
• Address Fasters and Email Link
• Address Tag, Email Tag, Address and Email Link
• Sniffing up text
• Font Color Font Face Superscripts Subscripts Center Tag, Tables
• Mata Tags and Frames
• Mata Tag, Mate Refresh Tag, Meta Descriptor Tag, Frames Target Attribute No Frames Tag
• Forms
• Adding Forms to Web Pages Form Tag Menu Select, Text Input Element Password input. Element text Area Input Element Radio Buttons Checks, Boxes Submit & Reset Button.
• Introduction to DHTML
• Introduction to java script, form Validation, Basic, Languages Structure.
• Introduction to CSS 1 & CSS2.
• Introduction to XHTML.

• Introduction Dream Weaver
• Creating Web Project.
• Applying Html on Dream Waver.
• CSS and its Implementation on Dream waver.
• Creating Menus.
• Layouts.
• Slicing.
• Forms.
• Tables.
• Website Project.

GD-Graphic Designing

Objective

In Basic Graphic Design individual assignments are based on the elements and principles of design. Each assignment focuses on at least two elements. Students are made aware of their importance relative the each assignment and are quizzed accordingly. The course starts with a very simple black and white assignment and progresses into value, color theory and eventually covers all the elements and principles discussed in the syllabus. This course is based on the textbook used, David Lauer “Design Basics” as well as a “real world” approach to projects.

Photoshop

• Exploring the Photoshop Environment
• Explore the Photoshop interface
• Customize the Workspace
• Explore the Navigation Tools
• Working with Image Areas
• Select Image Areas
• Save a Selection
• Modify a Selection
• Setting Color Space
• Calibrate and Profile your Monitor
• Set a Working Color Space in Photoshop
• Convert Image from one Color Space to Another
• Manage Printing and Color
• Enhancing Image
• Print Strokes on an Image
• Apply Filter Effects
• Convert an Image to Black and White
• Blend Layers
• Merge Layers and Flatten Image
• Convert Color Images to Grayscale
• Working with Layers
• Create Layers
• Create Type Layers
• Transform Layers
• Alter T type Properties
• Apply Layer Styles
• Undo Previous Steps
• Arrange and Group Layers
• Saving Images for Web and Print
• Save Images for Use in Print Application
• Save Images for the Web
• Save Images as PDF
• Managing Assets with Adobe@ Bridge
• Explore Adobe Bridge
• Work with Adobe Bridge
• Work with Stacks and Filters in Adobe Bridge
• Apply Metadata and Keywords to Files
• Preparing Web Images
• Change Measurement Units
• Reduce File Size
• Creating Web Page Layouts
• Simulate a Web Page
• Create Web Page Background
• Draw Editable Vector Shapes
• Create Effects
• Export a Web Page
• Enhancing Photographs
• Retouch Photographs Using Photoshop Tools
• Create Patterns
• Create Swatches and Gradients
• Create a Custom Brush
• Create Custom Patterns
• Creating Special Effects
• Preview Text Effects Using Layer Comps
• Warp an Image
• Automating Tasks
• Create an Action
• Manage Action
• Adjusting RGB Color
• Meet Color Correction Objective
• Locate Highlights Shadows and Neutral Areas
• Make Automatic Color and Contrast Adjustment
• Make Basic Curve Adjustment
• Sharpening Images
• Apply Un-sharp Images
• Sharpen an Image

( COREL DRAW

• BASICS:
• Exploring the Corel DRAW Interface
• Setup Drawing Page
• Corel DRAW Basic
• Manage Workspaces
• Customizing the Command Bar
• Saving and Printing Drawing
• Overview of Course Covered
• Shapes and Lines
• Basic Shapes
• Working With Paths
• Modify Paths
• Adding Text to Objects
• Overview of Course Covered
• Colors
[7:46 PM, 8/9/2022] Arif Mashal: • Fills and Outline
• Custom File
• Custom Strokes
• Drop Shadows
• Modify Outline
• Transform Objects
• Overview of Course Covered
• Working with Text
• Format Artistic Text
• Fit Text to a Path
• Create Paragraph Text
• Wrap Paragraph Text
• Modify OCT Text
• Importing Image Text
• Insert Special Characters
• Text Effects
• Overview of Course Covered
• Working with Objects
• Modify Objects
• Add Graphics
• Add Clipart
• Spray Objects
• Overview of Course Covered
• Styles, Templates Symbols
• Working with text Styles
• Working with Templates
• Create Symbols
• Overview of Course Covered
• Layers
• New Layers
• Manipulate Layer
• Overview of Course Covered
• Bitmaps
• Import and Adjust Bitmaps
• Trace Bitmaps
• Overview of Course Covered
• Advanced Printing Options
• Edit a Print Style
• Merge Text with Drawing
• Overview of Course Covered

InPage

• Toggle English / Urdu
• Tools
• Ribbon
• Status Bar
• Rulers
• Document Area
• Scroll Bars
• Cursors
• Text Box
• Title Text Box
• Picture Box
• Graphic Box
• Line
• Guides
• Text Chain
• Master Page
• Entering Text
• Character Attributes
• Paragraph Attributes
• Hyphenation
• Borders
• Style sheets
• Text Wrap and Repel
• Inserting Page Number
• Inserting Inline Pictures
• Inserting Tables
• Importing unformatted and preformatted Text
• Exporting Text
• Find / Replace

• Poster Design
• ID Card Design
• Banner Design
• Logo Design
• Boucher Design
• Business card Design
• Wallpaper Design
• Menu Design
• Icon Design
• App Design
• Flyer Design
• Thumbnails Design
• T-Shirt Design
• Mockup Design
• Letter Head Design
• Stationery Design
• Book Cover Design
• CV Design
• File Cover Design
• Package Design
• Mug Design

Introduction to Data base

Objective

After the completion of this course the students will be quite familiar with the importance of databases, core concepts, database design and its refinement and moderate level of expertise in SQL. Students should be able to design the database schema for at least a small sized real-life application.

Introduction to Data base
What is data Base?
What is Data?
What is Information?
What is Meta Data?
Explain Advantages of Data Base?
Explain Data base Model?
What is Hierarchal Model?
Network Model
Relation Model
Introduction to DBMS
Function of DBMS
Entity Relationship Model
ERD
Elements of ERD Model
E-R Diagram
Relationships
Degree of Relationship
Attributes
Introduction to Attributes
Types of Attributes
Association
1:1
1:M
M:M
Normalization
Anomalies
Function Dependency
First Normal Form
Second Normal Form
Third Normal Form
MODULE-II
SQL (Using MS SQL Server / Oracle/ My SQL)
DDL (Data Definition Language)
CREATE Statement
ALTER Statement
DROP Statement
RENAME Statement
TRUNCATE Statement
DML ( Data Manipulation Language)
INSERT Statement
UPDATE Statement
DELETE Statement
DCL ( Data Control Language)
COMMIT Statement
ROLLBACK Statement
Data retrieval
SELECT Statement
WHERE Clause
GROUP BY
ORDER BY
HAVIING Clause
Function Constraint
Concept of Key
Primary Key, Secondary Key, Candidate Key, Alternate Key, Composite Key,
NOT NULL Constraint
UNIQUE Constraint
Primary Key Constraint
Foreign Key Constraint
Check Constraint
MODULE-III
Function
Character Function
UPPER
LOWER
INITCAP
CONCAT
SUBSTR
INSTR
LENGTH
LPAID
RPAID
LTRIM
RTRIM
Numeric Function
ROUND
TRUNC
MOD
COALESCE

SQL (Using MS SQL Server / Oracle/ My SQL)
DDL (Data Definition Language)
CREATE Statement
ALTER Statement
DROP Statement
RENAME Statement
TRUNCATE Statement
DML ( Data Manipulation Language)
INSERT Statement
UPDATE Statement
DELETE Statement
DCL ( Data Control Language)
COMMIT Statement
ROLLBACK Statement
Data retrieval
SELECT Statement
WHERE Clause
GROUP BY
ORDER BY
HAVIING Clause
Function Constraint
Concept of Key
Primary Key, Secondary Key, Candidate Key, Alternate Key, Composite Key,
NOT NULL Constraint
UNIQUE Constraint
Primary Key Constraint
Foreign Key Constraint
Check Constraint
MODULE-III
Function
Character Function
UPPER
LOWER
INITCAP
CONCAT
SUBSTR
INSTR
LENGTH
LPAID
RPAID
LTRIM
RTRIM
Numeric Function
ROUND
TRUNC
MOD
COALESCE

Function
Character Function
UPPER
LOWER
INITCAP
CONCAT
SUBSTR
INSTR
LENGTH
LPAID
RPAID
LTRIM
RTRIM
Numeric Function
ROUND
TRUNC
MOD
COALESCE
Group Function
Min
Max
AVG
SUM
COUNT
Conversion Function
TO-CHAR
TO-NUMBER
TO-DATE

Introduction Views and data dictionary
Cerate simple / complex view
Importance of view in multi user environment.
UNDERSTANDING/ Managing User Privileges and Roles
Introduction to Multi user environment
Definition of Role and privileges
CREATE USER
CREATE ROLE
DROP USER
CRANT PRIVILEGE (DBA, ALL, SELECT, UPDATE, DELETE, INSERT)
Revoking User Privileges and Roles.

Microsoft Access

Objective

This course provides complete knowledge of E-commerce with an intensive survey of. Technologies used to support all aspects of electronic Commerce & E-business requirements. This course provides a complete training of Dream viewer tool that. Provides a platform to implement these practices and enables students to make a. complete website that will help the students to move in a marked confidently.

• DATABASE CONCEPTS
• What is data and Database?
• Why use Electronic Database?
• Tables and Relationships
• One to One
• One to Many
• Many to many
• Database Features
• Attributes, Character Fielded
• Record, Tuples Files
• Key, Primary Key
• Foreign Key, Composite Key
• Referential Integrity
• Use of Wild Cards

• MS- Access (Database)
• MS-Access Use Access, Window
• Title Bar, Control Menu, Toolbar
• Status Bar
• Database Window
• Object button
• Data types
• Start Access
• Creating table, Table view
• Create Table using in
• Design View
• Setting Primary Key, Saving table
• Close, exit add, delete record filed
• Resizing row column
• Freezing Hiding Column, Finding Data
• Repl data, Auto content, Spell checking
• Create Tales using in Wizard
• Create relationship between Tables

• Create Queries, define query, use adv
• Types of queries
• Creating simple query
• Executing data
• Join, difference between relations and join
• Extracting data
• Use of query wizard
• Create Forms, what is form
• Types of form
• Create form by wizard
• Create form of Design View
• Add new record through form
• Edit record through form
• Editing option
• List Box, Combo Box
• Adding list Box and Combo Box
• Cheek Box and option button
• Command Button

• Create Reports
• What is report?
• Use of Report, Standard types report
• Auto report
• Saving and closing auto report
• Create single table report
• Create two table report
• Create Report in design view
• Print a report
• Database Security