1. DESCRIPTION:
The project is entitled as “BOUTIQUE MANAGEMENT SYSTEM” is developed by Visual Basic as front end and MS-Access as the back end. This project is designed to provide the easy access to maintain the reports of boutique service. This project is very useful to the all type of boutique service. By using this project we can maintain the reports of placing-order and delivery details, customer details, details, branch office details and working staff details. This project is developed with the help of visual basic 6.
0. Boutique service is necessary and important for the society. A boutique is a small-scale to medium-scale shop employed to order raw dress materials, customized tailoring and delivered by the given date.
Boutiques are distinguished from ordinary to expensive studio by features such as advanced techniques of perfect fashion tailoring, specialization and individualization of services, and committed delivery time, which are optional for most everyday services. As a special service, boutiques are usually expensive than usual boutique services, and their use is typically restricted to type of orders where one or more of these features are considered important enough to warrant the cost.
Different boutique services operate on all scales, from within specific towns or cities, to regional, national and global services. In cities, there are often many boutique for various specialities. Owner operate alone or in small groups.. Here we design the project which involves the following data base.
* Placing-Order and delivery details
* Delivery Status
* Customer details
* Branch office details
* Employee details
The placing-order and delivery database contain the information about the cloth tailoring booking dates and customer name, delivery date, and delivery report. The delivery report has information such as the receiving person sign and whether the goods are delivered with good condition or not, the date and time of delivery. The customer database contains information about regular customer details such as customer name, address and their accounts details. Usually the boutique shops may or may not have branches across the cities and country so the branch office’s profit and booking, delivery details are maintained in the different database. The employee data base contain the personal details of staff such as employee name, address, data of joining, salary per month, mobile number, blood group.
SYSTEM STUDY
System analysis is a process of gathering the facts concerning the system breaking them into elements and relationship between elements. It provides a framework for visualizing the organizational and environmental factors that operate on a system. The quality of work performed by a machine is usually uniform, neat and more reliable when compared to doing the same operations manually.
2.1 EXISTING SYSTEM
The Placing-Order details, the customer details and the Delivery Details are maintained manually. The study of the existing system revealed that the system has several drawbacks.
DRAWBACKS
* The existing system has no security measure against logging in and no checks are made for authorized users. * The end user has to remember a lot of command to make efficient use of the system. * The system does not have any descriptive reports and thus did not help management in decision-making. * The Delivery information per day is sometimes unable to find. * Enormous amount of time is consumed
PROPOSED SYSTEM
The proposed system is been developed to maintain the Boutique Management for customers to maintain the Placing-Order details, Customer details, Delivery details, etc.,
BENEFITS
* The user can enter only if the username and the password are correct.
* The process of planning will be easy since every process is computerized.
* Time Saving.
* The Delivery information per day and per month can be known.
* The details of the all saved information can be viewed.
* The data can be accessed easily whenever needed and so the manual work can be reduced
SYSTEM ENVIRONMENT:
HARDWARE CONFIGURATION:
PROCESSOR: PENTIUM IV
HARD DISK CAPACITY: 40 GB
MONITOR: 14 “SAMTRON MONITOR
FLOPPY DISK DRIVE: 1.44 MB
PRINTER: TVS 80 COLOR
INTERNAL MEMORY CAPACITY: 128 MB
KEYBOARD: LOGITECH OF 104 KEYS
CPU CLOCK: 1.08 GHz
MOUSE: LOGITECH MOUSE
SOFTWARE CONFIGURATION:
OPERATING SYSTEM: WINDOWS XP
FRONT END : VISUAL BASIC6.0 BACK END : MS-Access 2003
Software Details
Front End
Visual Basic (VB) is a computer programming language. VB is the third-generation event-driven programming language an Intregrated Development Environment (IDE) from Microsoft for its COM programming model. VB is also considered a relatively easy to learn and use programming language, because of its graphical development features and BASIC heritage.
Visual Basic was derived from BASIC and enables the rapid application development (RAD) of graphical user interface (GUI) applications, access to databases using Data Access Objects, Remote Data Objects, or ActiveX Data Objects, and creation of ActiveX controls and objects. Scripting languages such as VBA and VBScript are syntactically similar to Visual Basic, but perform differently. A programmer can put together an application using the components provided with Visual Basic itself. Programs written in Visual Basic can also use the Windows API, but doing so requires external function declarations.
Back End
Microsoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is a member of the 2007 Microsoft Office system. Access can use data stored in Access/Jet, Microsoft SQL Server, Oracle, or any ODBC-compliant data container (including MySQL and PostgreSQL). Skilled software developers and data architects use it to develop application software. Relatively unskilled programmers and non-programmer “power users” can use it to build simple applications. It supports some object-oriented techniques but falls short of being a fully object-oriented development tool. Access was also the name of a communications program from Microsoft, meant to compete with ProComm and other programs. This proved a failure and was dropped.
Years later Microsoft reused the name for its database software. Access version 1.0 was released in November 1992. Since that time, the following versions have been released: 2.0, 95, 97, 2000, 2002 (also called XP), 2003, and the latest, 2007. Microsoft specified the minimum operating system for Version 2.0 as Microsoft Windows v3.0 with 4 MB of RAM. 6 MB RAM was recommended along with a minimum of 8 MB of available hard disk space (14 MB hard disk space recommended). The product was shipped on seven 1.44 MB diskettes. The manual shows a 1993 copyright date. The software worked well with very large records sets but testing showed some circumstances caused data corruption.
For example, file sizes over 700 MB were problematic (note that most hard disks were smaller than 700 MB at the time this was in wide use). The Getting Started manual warns about a number of circumstances where obsolete device drivers or incorrect configurations can cause data loss. Access’s initial codename was Cirrus; the forms engine was called Ruby. This was before Visual Basic – Bill Gates saw the prototypes and decided that the BASIC language component should be co-developed as a separate expandable application, a project called Thunder. The two projects were developed separately as the underlying forms engines were incompatible with each other; however, these were merged together again after VBA.