Inventory System in Visual Basic 6

System’s Mechanics

The following are the mechanics of the system with its corresponding description.

Log-in/out Menu. Log-in menu enables the users to access the system depending on the type of account the user has. Log-out menu enables the users to exit or close the application.

Users Main Menu.  Where the current user navigates the program menu, this menu could only be access with (3) accounts type. The Back Up account, where the user used unprivileged or limited  type of account, the Sample User account, same to the Back UP account where the user use limited and the System account it is equivalent to the Administrator account where the user use the privilege account. Through this account the selected user can access all the menu of the system.

Product Menu.  Products menu where the current user can add, edit, delete, and search the products information within the system.

Cashiering and Student Account System

Cashiering and Student Account System in Visual Basic 6

Features:

1. Process Payment Payment and Assessment of students.

2. Preview the payment history of students.

3. Real time balance of students.

4. View the income of every departments

5. Monitor User’s Log.

6. Back-up and Restore Option.

Dictionary Program in Visual Basic 6.0

Dictionary Program in Visual Basic 6.0

Features:

1. Display words based on search query.

2. Display the meaning of selected word.

3. CRUD (Create, Update, Delete) word info and meaning.

4. Capable of speaking/pronouncing the word selected.

Automated Student Council Election System in Visual Basic

Automated Student Council Election System in Visual Basic 6.0

Features:

1.  Encode Party List

2. Encode Candidates

3. Generate Voting Codes

Water Billing System in Visual Basic 6.0

Water Billing System in Visual Basic 6.0

Features:

1.  Client Information

2. Connection/Disconnection Module

3. Create Billing

4. Payment of Bills

5. Service Record Form

6. Statement of Accounts

7. Monthly Report

Student Information System in Visual Basic 6

Student Information System in Visual Basic 6

Sample Student Information System using Visual Basic 6.0 and MS Access

Features:

1. Add, Update, Delete student information

2. Back-up and Restore Database

3. Print student list and individual report

Electronic Booking System in Visual Basic 6.0

Electronic Booking Check-in Check-out System - It enhances the system to provide faster services in order to increase the business productivity.  This system electronically accepts information of the customers and generates automatically its transaction details such as billing, receipts and income statements.

MySQL Tutorial – Using BETWEEN condition

Using BETWEEN condition

BETWEEN condition is used to retrieve records with in the given range.

The syntax of BETWEEN condition:

SELECT column_name(s)
FROM table_name
Where column_name
BETWEEN value1 AND value2;

MySQL Tutorial – Using the IN function

The IN function can be used to replace the OR condition. It is also used to specify multiple value together with the WHERE clause.

The syntax of IN function:

SELECT column_name(s)
FROM table_name
Where column_name IN (value1,value2,etc…);

MySQL Tutorial – Using HAVING clause

Using HAVING clause

HAVING clause is somewhat similar to WHERE clause and it is used together with the GROUP BY clause. It was added to SQL to combine with the aggregate functions because the WHERE clause doesn’t allow aggregates.

The syntax of HAVING clause:

SELECT column_name, aggregate_function(column_name)
FROM table_name
GROUP BY column_name
HAVING aggregate_function(column_name) operator value;