PRESENTED BY:
JOY UPADHYAY
ANURAN SARKAR
SOHAM MUKHERJEE
ANIMESH JANA

---

[attachment=12119]
OBJECTIVE & SCOPE
• We are going to assemble two Data Base programs ( SQL & MS ACCESS) in a single program . It will make our database language fully workable each of this two programs and both also.
• This program is fully based on user - program interaction . This is the positive side of this program . This program can be defined as much more user friendly than the two other programs.
• This program guides in almost every cases so any non programmer person who has little bit idea of SQL query he/she can easily work with this program . So simplicity of this program is one of our objectives .
• The above mentioned objectives shows the strength of our program . People will accept this program for it’s facilities.
• In future following our program new more powerful software on Data Base handling , can be made.
THEORITICAL BACKGROUND
Maintaining the huge records of any large organization
is much difficult & complex full task . For that purpose
Data Base concept was created . The Data Base
Management System is for the techniques of record
Keeping and proper maintenance of them . The Structure
Query Language (S.Q.L) & MS. ACCESS are the tools by
which total Data Base Management System is implemented .
We are trying to create a new Data Base
Management programming tool using which Data Base
maintenance will be much more easy . We have
connected both SQL and MS. ACCESS in a single VB
program . We have connected them using the ADODC
tool of VB 6.0 . To maintenance purpose we have write
the SQL query for both SQL & MS. ACCESS .
SYSTEM ANALYSIS , PLAINNING & DESIGN
For any system creation we need to chock out some points about
the new system . They are like - Analysis , Planning , Design etc.
Analysis: Before starting planning or design we should make
thorough analysis on that system . We have selected this SQL
Editor topic after a deep analysis on Data Base system . We have
tried to identify the requirements of users , like - users want to make
the system user – system interactive , the requirements for developing
this total system like SQL Server , MS ACCESS , VB 6.0 etc .
Planning: After system analysis planning is an important
thing which is needed . In project planning stage we have
faced a lost of difficulties , like - how we can work with
both SQL & MS ACCESS , how to page link up them with visual basic
forms , what will be the proper design of the forms etc.
Design: It is the implementation part among the three stages -
Analysis , Planning , Design . We have designed the forms keeping in
mind the requirements . Here we have made the forms that user-system interactions can be done using the forms .
HARDWARE & SOFTWARE REQUIREMENTS
For any software developing project it is very necessary to
know the computer’s hardware requirements for that software
project .
For our project the hardware requirements of machines
are minimum 256 RAM , 40 GB Hard Disk etc .
The software requirements are Visual Basic 6.0 ,
SQL server ,Windows XP / 98 as the platform etc.
METHODLOGY ADOPTED
Our project is based on Data Base Management System .
So we have adopted the Data Base Access Object
methodology of Visual Basic 6.0 tool .

Presented by:
Joy Upadhyay
Anuran Sarkar
Soham Mukherjee
Animesh Jana

---

[attachment=12158]
SQL EDITOR
OBJECTIVES
 We are going to assemble two Data Base software ( MS SQL Server & MS ACCESS) in a single program . It will make our database language fully workable for both.
 This program is fully based on user - program interaction . This is the positive side of this program . This program can be defined as much more user friendly than the other programs.
 This program guides in almost every cases so any non programmer person who has little bit idea of SQL query he/she can easily work with this program . So simplicity of this program is one of our objectives .
 The above mentioned objectives shows the strength of our program . People will accept this program for it’s facilities.
 In future following our program new more powerful software on Data Base handling , can be made.
HARDWARE & SOFTWARE REQIREMENTS
Hardware Requirement
 256 MB RAM ( preferable 512 MB RAM)
 40 GB HARD DISK
Software Requirements
 Visual Basic 6.0
 MS ACCESS
 MS SQL Server
 Operating System –
Windows 98, XP
DATA FLOW DIAGRAM OF OUR SOFTWARE
SYSTEM IMPLIMENTATION
For MS ACCESS Connection:
 Firstly we have designed forms according to our planning . We have used VB tools like menu bar , textboxes , labels , command buttons , timer , ADODB (for database connection ) , Data Grid, AODC etc.
 We have created database tables using MS ACCESS .
 We have connected our form with database table using ADODB object and connection event .
 Using this ADODC we are accessing the data records .
For MS SQL Server Connection:
 For the SQL server connection we should have the software of SQL server installed in our machine .
 We have created a connection page link between SQL server and VB 6.0 form using the ADODB object operation in VB 6.0 tool .
 We wrote the code for accessing the data records from SQL tables under cmdConnect_ Click() and accessing the object we wrote the code under cmdExecute_Click() .
USER MANUAL
Here user manual is given for the users of our software .Kindly follow these guide .
 Open the SQLEditor folder first .
 Click on the project 1. vbp file.
 Now VB Project file will be loaded.
 Select the run button or select the Run option from the menu bar.
 After form 2 opened , go top menu bar and select database file name with it’s full path description from the File option of menu bar.
 Select database type & press connect button .
 Now write your SQL query in the mentioned place .
 Check the validity of your query by pressing Validity button .
 If query is valid press execute button and see the result and if message indicates invalid query rewrite your query and again check validity of it .
 Cut , Copy , Paste options can be found in Edit menu bar option .These tasks can be done by the shortcut keys which are assigned with each options.
[ N.B : As we have MS OFFICE installed in our machine , so we have not to install the MS ACCESS . But for accessing SQL database we have to install the SQL Server Express first to SQL query in our Software . ]
LIMITATIONS
 As we are working with two different types of database language in a single form , so this form is becoming clumsy.
 For accessing any record we have to write queries . So it is difficult use to a person who has no idea on Structured Query Language .
 Total Software system design is complex , so it is little bit tuff to understand.
 Too many objects are created , which are linked up complexly .So the coding is too much complex to understand .
 Our project is limited to use on Microsoft technology only.
SCOPE OF OUR PROJECT
 Their is scope that our software should be used for other types of Data Base Management System ( such as ORACLE , MySQL , SYBASE etc. ) .
 If the project is implemented using platform Independent language like JAVA , the software can be used in any Operating System ( Windows / Linux ) for various database connectivity .
 In place of Active Data Base Object & Data Control ( ADOBC) if we use Open Data Base Connectivity ( ODBC ) , our project will open various database connectivity .
 Instead of writing pure SQL queries, If we can manage to provide GUI based interface which will substitute SQL queries, then non-SQL knowledged person can use this software.