Point of Sale Tutorial Part 1 - Introduction

PROJECT INTRODUCTION

This is my first post for the year 2016, in my previous tutorial, I covered several topics related to visual basic 6.0, despite the fact that it is an old school it is useful to all the beginners out there. This time Im going to create a Point of Sale System and I will do this in a step by step basis. Lets get started.

The topics that we are going to cover are the following:

• Creating access database and setting of data tables
• Setting of Database Connection
• Creating User Account relating to CRUD concept 
•  Creating Supplier Accounts 
• Creating Product Entry and Stocks 
• Creating list of product items 
•  Making the product category 
•  Login Account validation

CREATING DATABASE AND TABLES

The first step is we are going start on how to create database and setup tables needed. You have to install MS Access(Im going to use the Access 2007 Version) in your computer and create a database with a name “POS” with .mdb extension. After that, create the following tables and fields:

Table Name: UserAccount

In the Password and Confirm fields, if you want to mask the value of passwords just go to General Tab and click the button with a dot caption in Input Mask then select Password and click Finish.

Table Name: Supplier

Table Name: StockIn

 

Table Name: Category

Table Name: Designation

Table Name:Transaction

 

My next tutorial will cover up on how to set up and establish the connection of the database.

Enjoy!

Point of Sale Tutorial Part 2 – Setting Up Database Connection