watch shop management system

[

1. INTRODUCTION

1.1. About the project

Computer technology makes a dramatic break with the past:

Most companies are designed and use their applications that which the application runs

on the user access a maintained manage file or database.

The concept of computerized report has important in the industry, which needs

information to retrieve in the fast and efficient way.

Objectives of the system

Increased end-user productivity because of flexible data access.

Graphical oriented, highly interactive user interface.

Increased developer productivity through usage of easy to use tools.

Improved access to information because of computerizing.

Easier maintenance of application and data.

Every organization has a system generating and monitoring various kinds of data and

report that are very relavant for the smooth functioning of that organization. Effective decisions

are to be taken by the management based on the current data information which provides

accurate and help the management.

The main aim of this project is to maintain all the records by computerized the watch

showroom.This existing system is a manual system.so there is a lot of limitation like large

number of man power. On using this project customer could view and purchase the product

directly.It gives computerization helps the supplier to reduce the paperwork.

1

Sonata

Sonata is the Value for Money watch brand from Titan Industries Ltd. It is targeted at

consumers seeking durability and value, with a clear positioning of " No compromise watch".

Sonata comes with the backing of being a Tata product with five clear functional attributes,

Affordability, looks, 1 Year Guarantee, Waterproof (up to 30m water resistant) and Durability. It

is therefore known as " 5 Ghadi ke barabar" an equivalent for no-compromise watch. It is India's

largest selling watch brand with a sale of over 30 Lakh watches in 2003-04.

Sonata has a wide range of over 400 watches in different traditional designs for gents and

ladies. The range starts from Rs 395 and goes up to Rs 1250. The exclusive designs are made

with best quality material, undergoing several stringent tests. Primarily, Sonata is known for

being a brand that is strong in gold plated watches, and it also has a very good collection of steel

watches.

Classic

Classic is the renowned brand of horological products in India. The company was started

as a trading house in 1978 and got appointed as distributor for many leading brands for northern

India, graduated to become the pioneers in manufacturing and marketing a range of fancy wall

and table clocks in 1986. Our's was the first company to give high priced clocks to the trade.

In 1993 the company saw an opportunity to manufacture and market Quartz wrist

watches and decided to enter this segment with one goal in mind to give the consumer real value

for money.

Classic watches offers an astonishing range of gents and ladies watches and has become

one of the best selling brands in the country because of the quality, design and most important

it's price range of MRP Rs. 395/- onwards. The watches are gold plated to 3 microns to provide

enduring plating and are fitted with matching genuine leather or metal straps. Most of the

watches are 3 ATM water resistant and are guaranteed for one year including gold plating.

2

Recently, the company has introduced a new range named CYBER for so planned the

young and trendy consumer in analogue and digital watches with alarm, chronograph and

multifunction features, starting at a price point of Rs. 295/- onwards.

3

1.2. Organization Profile

Kanagaraj Watch showroom is one of the famous watch showroom in Avinashi.The

showroom was establishing in the year of 1999.It is located at Avinashi.

It deals with all kinds of alarms, wallclocks and wristwatches.

This watch showroom purchased from company dealers and sold to the customers.This

showroom provides one year guarantee to all the products the have.All the latest and valuable

kinds of alarms,wallclocks and wristwatches are available they also provide service to the

watches.

The main objectives of this shop are

Quality Maintenance

Reasonable Price

Regular Customer

New Varieties

Discount Sale

Kanagaraj Watch showroom runs according to satisfaction of the customer. It has

customer from various places.This showroom runs with four employees.

4

2. SYSTEM ANALYSIS

2.1. Existing System

The study of existing system deals with the work needed to carry out preliminary

investigation.The study of system can be performed only on the existing system.

Previously the account maintained manually. It take long time, It invokes highest cost

If account books are missed it is difficult to retrieve the data.

In existing system the data are maintained manually.So the retreiving the information is

very slow and also it requires lot of manpower to the organize the data and to consolidate the

report.

Drawbacks of existing system

Waste of time for manual operations.

Sometimes the operations done manually will prone to unsecured access.

Unauthenticated accessing.

Required information cannot be retrieved easily.

Manual processes will take time.

So the desire for the development of the proposed system had become essential.

5

2.2. Proposed System

The previous section highlights the limitation of the existing system. In the proposed

system the daily sales of purchase transaction are stored in the tables and retrieval of data is also

easy.The proposed system have been designed to overcome these facilities.

Advantages Proposed System

Minimize the workload

Easy to enter the data

It is the user friendly

It contains many input screen

Quick retrieval of data.

2.2.1 Objectives of the proposed system

The study of existing system is the exact nature of problem manual system.Also if has

been decided that problem in the existing system can be solved only through computerization.

The existing system has been studied by initial investigation through observation and

interviewing. Reference Number, Pay Date, Invoice Number, Invoice Date, Company Code,

Company Name, Amount, Payment, Cheque DD No, Cheque DD Date.

2.3 Feasibility Study

Feasibility study is the evaluation of system regarding is workability, impact on the

organization, ability to meet the user needs and effective use of resources. It is both necessary

and prudent to evaluate the feasibility of a project at the earliest possible time. Months or Years

of effort, thousands and millions of dollars, and untold professional embarrassment can be

averted if an ill-conceived system is recognized early in the definition of phase. The project

mainly deals with the storing all details. Storing details obtained by ”watch” different types of

report are produced by the database tables.

6

Technical Feasibility

Technical Feasibility is the need of hardware and software ,which are needed to

implement the proposed system in the organization. Technical requirements are to be fulfilled to

make the proposed system work. This should be necessarily predetermined so as to make the

system more components.

It is the study that determines whether the work for the project can be done with current

equipment, existing software technologies, and available personnel.

Technical feasibility is the most difficult area to assess at the stage of the system

development process. Because objectives, functions and performance are somewhat hazy,

anything seems possible if the right assumptions are made.

Technical feasibility centers on the existing computer system (hardware, software,

etc……) and to what extent it can support the proposed addition .For example, if the current

computer is operating at 80% capacity. This involves, additional hardware (RAM and

PROCESSOR) will increase the speed of the process.

Operational Feasibility

During feasibility analysis operational study is must. Because according to software

engineering principles operational feasibility or in the other words usability should be very high.

A through analysis is done and found that system is operational. Managing the time and work

system is possible to develop operationally.

Behavioral Feasibility

Behavioral feasibility speaks about how strong a reaction the programmer is likely to

have toward or against the development of system. Since the programmers are well exposed to

the system, it will be feasible for them to work on. Therefore, the system to be computerized is

also behaviorally feasible.

Economical Feasibility

Economical Feasibility deals with the analysis of cost against benefits i.e. whether the

benefits to be enjoyed due to the new system are worthy, when compared to the costs to be spent

on the system.

7

Economics justification is generally the “bottom-line” consideration fo r most system,

long-term corporate income strategies, impact on other profit centers or products, cost of the

resources needed for development, and potential market growth. Hence this project was

economically justified for development in this organization.

Especially in the present scenario, where the objective is towards compatibility, reduced

cost is weighed against the ultimate income or benefit derived from the developed system.

This system has been implemented such that it can be used to analysis the traffic. So it

does not require any extra equipment or hardware to implement. So it is economically feasible to

use.

Legal Feasibility

Legal Feasibility encompasses a broad range of concern that includes contacts, liability,

infringement and myriad other taps frequently unknown to the technical staff. A determination of

any infringement, violation or liability that could result from the development of the system.

8

3. SYSTEM SPECIFICATION

3.1 Hardware Specification

Processor : Celeron 733 MHz

Clock speed : 733 MHz.

RAM : 128 MB

Hard Disk : 20 GB

Monitor : SAMSUNG, SAMATRON 14” COLOR

Key board : 105 KEYS

Mouse : HCL 3 BUTTON

3.2. Software Specification

Operating system : Windows 98

Front end : Visual Basic 6.0

Back end : MS Access

9

Language Description

Visual Basic is an ideal programming language for developing sophisticated

professional applications for Microsoft Windows.

It makes use of graphical user interface (GUI) for creating robust and powerful

applications, which enables the user to interact easily with an application.

It provides many aspects such as easier comprehensions user friendliness and faster

applications development, which help the developer to design the application more

effectively.

MDI forms allow having a relation between parent and child forms.

Various types of reports can be generated.

More number of master tables can be stored under database in MS-Access help to

store data for Visual Basic. This facility provides an easy and efficient retrieval

database.

More database applications comprise a ‘Front-end and Back-end’. The Front-end part of

the application is the one which takes care of processing the data via user defined forms. The

Back-end part of the application is the one which takes care of storing and retrieving the data.

VISUAL BASIC 6.0

The software used for developing this project is powerful front-end-tool Microsoft

VisualBasic6.0 it is the integrated development environment, which is a Multi Document

Interface (MDI). It is uses three types of records, they are dynast, snap short and table. Dynaset

is an object that returns a dynamic set of pointers to live a database data. It returns data in records

and fields. It can be the result of a query that joints two or more tables. It is used to perform the

action like adding, modifying and jet-computed data source can be updated. Objects can be

created from a base_table a query or another record set. Table stores the data in records and

fields.

10

The user interface is the part of the program that responds to key press and mouse clicks.

The action is referred to as events of the form and controls in the form. The form is a visual

object where a set of object controls are placed to communicate with back-end database and

validation checks. Visual Basic provides vast properties and method for each control, which

helps to utilize all the functions for record manipulations.

Data manager in visual basic provides easy way to create database and build interface

using data control or data access the database tables. A database is a collection of information

stored in one or more tables. Database tables just like tables in word processing are made up of

columns/fields in each row is usually referred to as record. A database object has properties that

define such things as the name of database, the connect string used to open the database,

collating order indicating the sort method to be used, whether or not the database is up datable,

and whether or not is supports transactions.

Each database objects can be accessed through data access object of any type such as

record set. This record set contains record collection which can be efficiently manipulated using

different record set methods such as add, new and edit. Report generation is prepared using data

report designer which can be used to bring different types of reports such as tabular report, query

report and group report.

MS-ACCESS

A database is a collection of data and objects related to a particular topic or purpose. MS-

Access is a relational database management program or RDBMS. RDBMS is a set of two-

dimensional tables in which the tables can be build between the tables and fields from different

tables can be combined together to form the report. In this manner only the data required is

displayed. An Access database consist of object such as tables which contains the data forms,

queries and reports. These objects are used to manage the data in the database.

11

Access is a relational database management system that can be used to store and

manipulate large amount of data.

The tools of access are user friendly and provide a powerful development

environment for large amount of data.

Object are modules which the user can directly apply to create application.

MS-Access adheres to industrial accepted standard for the data

12

4. SYSTEM DESIGN

An operating system is a collection of services that form foundation upon which

application run. Here Windows is an operating system. The system peer networking services,

Internet client server service and a board range of utilities. Some reasons why windows is

becoming popular around the world? It is an easy to use consistent GUI vertically all programs.

It is capable of multitasking. Graphics programs and character-based programs can be run

concurrently.

4.1 Fundamentals of Design Concepts

Software design is both process and model. The design process is a set of iterative steps

that enable the designer to describe all aspects of the software to be built. A set of fundamental

design concepts have been evaluated each of which provides the software designer with a

foundation from which more sophisticated design methods can be applied. The following design

concepts can be regarded as criteria for an efficient system.

Abstraction

Considering a modular solution to a problem, many levels of abstraction can be posed. At

lower level of abstraction, a more procedural orientation is taken. Problem oriented terminology

in an effort to state in a manner that can be directly implemented.

Refinement

The architecture of a program is developed by successively refining levels of procedural

detail. The process of program refinement is analogous to the process of refinement and

partitioning that is used during required analysis. Refinement is the process of elaboration.

Refinement causes the designer to elaborate on the original statement, providing more and more

detail as each successive refinement occurs.

13

Modularity

Modularity is a single attribute of software that allows the program to be intellectually

manageable. The software is divided into separately named and addressable components, called

modules which are integrated to satisfy problem required.

Software architecture

Software architecture is a hierarchical structure of the program components or modular

the manner in which these components interact and the structure of the data used by the

components. Software design can be aimed to drive on architectural rendering of a system. A set

OS architectural pattern enables a software engineer to reuse design-level concepts.

Control hierarchy

Control hierarchy also called program structure represents the organization of program

components or modules and implies a hierarchy of control. The tree-like diagram is the most

common diagram used to represent control hierarchy.

Structural partitioning

The program structure can be partitioned both horizontally and vertically partitioning

defines separate branches of the modular hierarchy for each major program function. Vertical

partitioning or factoring suggest that control or decision-making the work should be distributed

top-down in the program architecture.

Data structure

Data structure is a representation of a logical relationship among individual elements of

data. Data structure dictates the organization methods of access, degree of associatively, and

processing alternatives for information. It can be represented at different levels of abstraction.

Software procedure

14

Software procedure focuses on the processing details of each machine individually.

Procedure must provide a precise specification of processing, including sequence of events, exact

decision points, repetitive operations and data organization or structure.

Information hiding

Modules should be specified and designed so that information contained within a module

is inaccessible to other modules that have no need for such information. Hiding defines and

enforces access constraints to both procedural detail within a module and any local data structure

used by the module.

4.2 Data Flow Diagram

Data flow oriented techniques advocate that the major data items handled by a

system must be first identified and then the processing required on these data items to

produce the desired outputs should be determined. The DFD (also called as bubble

chart) is a simple graphical formalism that can be used to represent a system in terms of

input data to the system, various processing carried out on these data, and the output

generated by the system. It was introduced by De Macro (1978), Gane and Sarson

(1979).The primitive symbols used for constructing DFD’s are:

Symbols used in DFD

.

A circle represents a process

A rectangle represents external entity

An arrow identifies dataflow.

15

Double line with one end closed indicates data store

[

Data Flow Diagram

16

System Flow Diagram

17

4.3 Database Design

4.3.1Table Structure

Table Name : Login Table

Primary Key : Usr

Field Name Data Type Size Description

Usr Varchar 50 User Name

Pwd Varchar 50 Password

18

Table Name : Employee_Details

Primary Key : Emp_Id

19


Emp_Id Integer 2 Employee Identification

Emp_Name Text 50 Employee Name

Sex Text 50 Sex

Qualification Text 50 Qualification

Mobile_No Double 8 Mobile Number

Phone_No Double 8 Phone Number

Address Text 50 Address

Salary Double 8 Salary

Table Name : Watch Details

Primary Key : Emp_Id


Product_Ref_No Integer 2 Product Reference Number

Make Text 50 Company Name

Category Text 50 Category

MRP Double 8 Market Retail Price

20

Table Name : Company_Information

Primary Key : Company_Id

21


Company_Id Integer 2 Company Identification

Company_Name Text 50 Company Name

Contact_Person Text 50 Contact Person

Designation Text 50 Designation

Mobile_No Double 8 Mobile Number

Address Text 50 Address

Contact_No Double 8 Contact Number

Fax Double 8 Fax

Table Name : Purchase_Information

Primary Key : Invoice_No

22


Invoice_Type Text 50 Invoice Type

Invoice_No Integer 2 Invoice Number

Invoice_Date Date/Time 8 Invoice Date

Company_Id Integer 2 Company Identification


Product_Ref_No Integer 2 Product_Reference Number


Purchase_Qty Integer 2 Purchase Quantity

Rate_Qty Integer 2 Rate Per Quantity

Tax Single 4 Tax

Table Name : Purchase _Payment _Details

Primary Key : Pay_ref_No


Pay_Ref_No Integer 2 Payment Reference Number

Pay_Date Date/Time 8 Payment Date

Company_Code Integer 2 Company Code


Invoice_No Integer 2 Invoice Number

Invoice_Date Date/Time 8 Invoice Date

Amount Double 8 Amount

Payment Text 50 Payment

Cheque_DD_No Long 4 Cheque Demand Draft Number

Cheque_DD_Date Date/Time 8 Cheque Demand Draft Date

23

Table Name : Sales_Information

Primary Key : Bill_no

24


Bill_type Text 50 Bill Type

Bill_No Integer 2 Bill Number

Bill_Date Date/Time 8 Bill Date

Sales_to Text 50 Sales To

Product_code Integer 2 Product Code


Qty Double 8 Quantity

Amount Double 8 Amount

4.4 Input Design

Input design is the process of converting user-originated inputs to a computer based

format. Input design is one of the most expensive phases of the operation of computerized

system and is often a major problem of a system.

In the project, the input design is made in various forms with various methods. During

each of input data, guidelines are provided to the user to avoid incorrect and inaccurate entry.

The input screen should be user- friendly, so that everyone can access the option without having

the computer system knowledge. In the project, each and every option has its input screen. The

option can be selected using menus given.

4.5 Output Design

Output design generally refers to the results and information that are generated by the

system for many end-users; output is the main reason for developing the system and the basis on

which they evaluate the usefulness of the applications. An effective output design would attract

the user more.

The output information must be provided in such a format that the customer can

understand. After analyzing the operations, output information required for each job are

determined. In addition to this outputs may be in the format suited to input for subsequent

processing. In this project, the purchases details, the sales details etc. are the reports in which the

output is available.

4.6 System Study

Older system of watch shop management is made of C language which is slow and it is not

Graphic user Interface and it is not speed comparing with Graphical Interface. The accessing of

database is also slow and has a chance for duplicate record. The proposed system has Visual Basic as

Front end and MS-Access as back end which uses the Graphical User Interface. It was very user

25

friendly to work and the data are called accurately and quickly. And working of our project is easy to

handle.

4.7 Development approach

Architectural Design involves identifying the software components, decoupling and

decomposing them into processing modules and conceptual data structure and specifying the

interconnection among components.

System architecture is the design or set of a relations between the parts of a system. There

is no strict definition of which an aspect constitute system architecture, and various organizations

define it in different ways.

System architecture is primarily concerned with the internal interfaces among the system

components or subsystem, and the interface between the system and its external environment,

especially the user.

The internal structure of the software product and tests that attempt to break the system

are open during implementation. The architectural design is also called as internal design. The

goal of this design is to specify the internal structure and processing details, to record design

decisions.

26

5. SYSTEM DEVELOPEMENT

5.1 Module description

Employee Details

Employee Details Contains Employee id, Employee Name, Sex, Qualification, Mobile

No, Phone No, Address, and Salary

Company Information

Company Information contains Company Id, Company Name, Contact Person,

Designation, Mobile No, address, Contact No, Fax.

Watch Information

Watch Information contains product Reference number, make, Category, MRP.

Purchase Information

Purchase Information contains Invoice Type,Invoice Number,Invoice Date, Product

reference Number,Category,Purchase Quantity,Rate Per Quantity,Tax,Net Amount.

Purchase Payment Details

Purchase Payment Details contains Pay Ref.

Feasibility and risk analysis are related in many ways. If project risk is great, the

feasibility of producing quality software is reduced. During product engineering, however, we

concentrate our attention on primary areas of interest.

Sales Information

27

Sales information contains Bill Type, Bill Number, and Bill Date, Sales To, Product

Code, Category, Quantity, and Amount

6. SYSTEM TESTING AND IMPLEMENTATION

6.1 System Testing

Once the physical system has been designed in detail, the next stage is to turn the design

into a working system and then to monitor the operation of the system to ensure that it continues

to work efficiently and effectively. The major tasks involved in implementation are Computer

system testing Training the personal Full system testing and making necessary changes as

designed by the user

Change-over

Maintenance

For implementation, purchase and sales management system, as the system testing is

successful the next steps involved are:

Educate users about the new system, train them how to use it and help them to learn all the

facilities provided in the system, although it wouldn’t be necessary, as it has been developed in

very user friendly fashion. Update the entire database to current level. Proper maintenance of the

system must be done in case of improvement of operations of the system.

6.2 System Implementation

Implementation denotes the process of converting a new or a revised

System design in to an operational one. There are three types of implementation.

Implementation of a computer system to replace a manual system

Implementation of a new computer system to replace an existing one

Implementation of a modified application to replace an existing one

28

In this project impose the first method is imposed where one can replace a manual system

with that of a computerized one. This system is found to be satisfactory running under the real

environment. The system is tested for its functionality and appreciated for its efficiency,

flexibility, and accuracy and user friendliness.

The system has been tested with sample data and adequate corrections were made as per

user requirements. The user has very little chances of making data entry errors. Since enough

validation checks and validation error messages are provided in the system. The end user even

with minimum amount of computer knowledge will be able to key in the data and understand the

error messages. All reports have been found satisfy their requirements.

6.3 System Maintenance

Visual Basic 6.0 is a very popular Microsoft product developed by Microsoft

Corporation. This front-end tool is mainly used for developing both Client Server Application

and Desktop Application . This software works under Windows 95, Windows 98 and Windows

NT platforms. This is one of efficient language improved from the Basic language. Visual Basic

includes varieties of open active controls for user interface to design application forms.

29

7. CONCLUSION

This project entitled Watch Shop Management System mainly contributes to provide

information about the activities of a Show Room. This project provides easy retrieval of

information about the Products available. The system helps the user to change his/her

requirements in future. Thus it enables us to carry out the process in an effective way. This

system also provides a user-friendly operating environment and also provides the platform to

serve the needs of emerging information technology trends and needs.

30

8. SCOPE FOR FUTURE ENHANCEMENT

This system is very flexible so the maintenance and future enhancements based on the

changing environment and requirements can be incorporate easily. Any changes that are likely

cause system failures are presented with security measures.

In order to make modifications effectively, there should be good communication between

customer and the organization. Thus valuable suggestion supplied can be included in the

system .Since Visual Basic and Access are flexible tools, we can easily incorporate any modular

program into the application. Thus even after the development phase, design and development of

new application and their integration with the existing one can be carried out with least effort.

Addition reports can be added with the system to show the growth of the particular field

or for the whole company.

31

BIBLIOGRAPHY

Books Referred

Curtis L. Smith, Database Programming with Visual Basic 6.0, Sam’s Publication,

1998, I edition

Gary cornell, Visual Basic 6.0 from the ground up, TATA MCGRAW Hill Publication,

1991, I edition.

Ron Mansfield, Working with Access, TATA McGraw Hill Publication, 1997 I edition

Websites Referred

www.titanworld.com/

www.britishwatchcompany.com/

www.rado.com/en/watch-shop.html

www.thelittlewatchshop.com/

32

http://www.rado.com/en/watch-shop.html

Screen shorts

Login Form

33

Employee Details

35

Watch Information

36

Company Information

37

Purchase Information

39

Purchase Payment Details

40

Sales Informtion

41

Reports

Employee Details

43

Watch Information

44

Company Information

45

Purchase Details

46

Purchase Payment

47

Sales Information

48

SAMPLE CODING

Employee Details

Dim db As Database

Dim rs As Recordset

Private Sub cboqualification_KeyPress(KeyAscii As Integer)

If KeyAscii = 13 Then

txtmobileno.SetFocus

End If

End Sub

Private Sub cmdadd_Click()

Text_clear

txtemployeeid.SetFocus

rs.AddNew

End Sub

Private Sub cmddelete_Click()

If rs.RecordCount = 0 Then

50

MsgBox " There is No Record ", vbSystemModal, "Watch Shop"

Else

rs.Delete

Text_clear

MsgBox " Record Is Deleted Successfully ", vbSystemModal, " Watch Shop"

rs.MoveFirst

Text_Load

End If

End Sub

Private Sub cmdexit_Click()

Unload Me

End Sub

Private Sub cmdfirst_Click()



Else

rs.MoveFirst

Text_Load

End If

End Sub

Private Sub cmdlast_Click()

51



Else

rs.MoveLast

Text_Load

End If

End Sub

Private Sub cmdmodify_Click()



Else

Text_Load

If MsgBox(" You Want To Modify This Record ", vbYesNo + vbQuestion) = vbYes Then

rs.Edit

Text_Load

End If

End If

End Sub

Private Sub cmdprevious_Click()


52


Else

rs.MovePrevious

End If

If rs.RecordCount > 0 Then

If rs.BOF = True Then

rs.MoveFirst

MsgBox " This is The First Record ", vbSystemModal, "Watch Shop"

End If

End If

Text_Load

End Sub

Private Sub cmdsave_click()

rs.Fields(0) = txtemployeeid.Text

rs.Fields(1) = txtempname.Text

rs.Fields(2) = txtsex.Text

rs.Fields(3) = cboqualification.Text

rs.Fields(4) = txtmobileno.Text

rs.Fields(5) = txtphone.Text

rs.Fields(6) = txtaddress.Text

rs.Fields(7) = txtasalary.Text

rs.Update

53

MsgBox " Record Is Saved Successfully ", vbSystemModal, "Watch Shop"

End Sub

Private Sub Form_Load()

frmEmployeedetails.BackColor = RGB(253, 204, 153)

Set db = OpenDatabase("C:\Watch\Watch.mdb")

Set rs = db.OpenRecordset("Employee_Details")

End Sub

Private Sub Text_Load()

txtemployeeid.Text = rs.Fields(0)

txtempname.Text = rs.Fields(1)

txtsex.Text = rs.Fields(2)

cboqualification.Text = rs.Fields(3)

txtmobileno.Text = rs.Fields(4)

txtphone.Text = rs.Fields(5)

txtaddress.Text = rs.Fields(6)

txtasalary.Text = rs.Fields(7)

End Sub

Private Sub Text_clear()

txtemployeeid.Text = ""

54

txtempname.Text = ""

txtsex.Text = ""

cboqualification.Text = ""

txtmobileno.Text = ""

txtphone.Text = ""

txtaddress.Text = ""

txtasalary.Text = ""

End Sub

Private Sub cmdnext_Click()



Else

rs.MoveNext

End If

If rs.RecordCount > 0 Then

If rs.EOF = True Then

rs.MoveLast

MsgBox " This is The Last Record ", vbSystemModal, "Watch Shop"

End If

End If

Text_Load

End Sub

55

Private Sub optfemale_Click()

txtsex.Text = optfemale.Caption

End Sub

Private Sub optmale_Click()

txtsex.Text = optmale.Caption

End Sub

Private Sub txtaddress_KeyPress(KeyAscii As Integer)


txtasalary.SetFocus

End If

End Sub

Private Sub txtasalary_KeyPress(KeyAscii As Integer)


cmdsave.SetFocus

End If

End Sub

Private Sub txtemployeeid_KeyPress(KeyAscii As Integer)


txtempname.SetFocus

56

End If

End Sub

Private Sub txtempname_KeyPress(KeyAscii As Integer)


txtsex.SetFocus

End If

End Sub

Private Sub txtmobileno_KeyPress(KeyAscii As Integer)


txtphone.SetFocus

End If

End Sub

Private Sub txtphone_KeyPress(KeyAscii As Integer)


txtaddress.SetFocus

End If

End Sub

Private Sub txtsex_KeyPress(KeyAscii As Integer)


cboqualification.SetFocus

57

End If

End Sub

MDI FORM

Private Sub mascompanyinformation_Click()

frmCompanyinf.Show

End Sub

Private Sub masemployee_Click()

frmEmployeedetails.Show

End Sub

Private Sub maswatchinformation_Click()

frmWatchinformation.Show

End Sub

Private Sub mnuclose_Click()

End

End Sub

Private Sub rptcompany_Click()

rptcompanyinformation.Show

58

End Sub

Private Sub rptemployee_Click()

rptemployeedetails.Show

End Sub

Private Sub rptpurchase_Click()

rptpurchaseinformation.Show

End Sub

Private Sub rptpurchasepayment_Click()

rptpurchasepaymentdetails.Show

End Sub

Private Sub rptsales_Click()

rptsalesinformation.Show

End Sub

Private Sub rptwatch_Click()

rptwatchinformation.Show

End Sub

59

Private Sub trapurchaseinformation_Click()

frmPurchaseinf.Show

End Sub

Private Sub traPurchasepaymentdetails_Click()

frmPurchasepaymentdetails.Show

End Sub

Private Sub trasalesinformation_Click()

frmSalesinformation.Show

End Sub

60

watch shop management system

Documents

ladies watches

classic watches

lakh watches

money watch brand

compromise watch

gold plated watches

watch showroom

wide range