Point of Sale (POS) System

•Learn how to use a database for creating the Customer Database - POS Point of Sale System
3.6 (16 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
77 students enrolled
Instructed by Hemn Barzan Development / Databases
$19
$20
5% off
Take This Course
  • Lectures 26
  • Length 4.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2015 English

Course Description

•Inventory software programs now on the market let you track usage, enter Users for using The Point of Sale system with input any change and add records under User ID, calculate when you need to reorder and analyze inventory levels on an item-by-item basis. You can even control inventory right at the cash register with point-of-sale (POS) software systems. POS software records each sale when it happens, so your inventory records are always up-to-date. Better still, you get much more information about the sale than you could gather with a manual system. By running reports based on this information, you can make better decisions about ordering and merchandising.

•Learn how to use a database for creating the Customer Database - POS Point of Sale Software with Inventory Control and Integrated Accounting.

•Learn how Connection to our Point of sale with the SQL Server Database, for saving our data details in SQL Server.

• Learn how to Connecting PCs by using Ethernet cable for transferring data between Cashier and Server.

• Learn how to connecting between Client and Server.

What are the requirements?

  • Some Basic Information about SQL Server With VBA.
  • Instal SQL Server With complete Instal MS Office.
  • Have Some Informations about whats is mean (Table, Query, Form, Report)

What am I going to get from this course?

  • You can analyze sales data, figure out how well all the items on your shelves sell, and adjust purchasing levels accordingly.
  • Keep track of your daily cash flow, Monitor all cash register adjustments and staff changes throughout the day.
  • You can maintain a sales history to help adjust your buying decisions for seasonal purchasing trends.
  • The Retail Package makes it easier to sell in-store. Inventory management, efficiently manage.
  • You can improve pricing accuracy by integrating bar-code scanners and credit card authorization ability with the POS system.
  • Be used as part of a more sophisticated IT system, linked to back-office stock control, ordering, and customer relationship management applications.

What is the target audience?

  • This course is for everyone, Who have a basic knowledge about The Database.
  • This course is for who have a basic knowledge about The Database.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
01:55
The point of sale (POS) is the time and place where a retail transaction is completed. It is the point at which a customer makes a payment to the merchant in exchange for goods or after provision of a service. At the point of sale, the merchant would prepare an invoice for the customer (which may be a cash register printout) or otherwise calculate the amount owed by the customer and provide options for the customer to make payment. After receiving payment, the merchant will also normally issue a receipt for the transaction. Usually the receipt is printed, but it is increasingly being dispensed electronically.
Section 2: Ways to Open The Database
How to open and find The Database
Preview
02:39
Section 3: Create Tables for The Point Of Sale
Create Tables For The Registration Items
Preview
16:00
Create Tables For The Customer Order
04:16
Create Table for Expenses with Table Profit
06:23
Section 4: Create Queries for The Point Of Sale
Create Apend Query for The Profit
09:59
Create Queries For Total Quantity
03:33
Section 5: Create Forms for The Point Of Sale
Create Forms For The Registration Items(Sec.1)
19:58
Create Forms For The Registration Items(Sec.2)
17:19
Create Forms For The Customer Order(Sec.1)
10:45
Create Forms For The Customer Order(Sec.2)
16:12
Create Previous Balance For The Customer Order(Sec.3)
10:42
Create The Key Pad in Form The Customer order by using VBA
20:01
Create Fkey for using a KeyBoard In The Customer Order by using VBA
10:55
Create Forms For (Expenses & User Information)
11:29
Create Forms For The Main menu with Startup(POS)
Preview
11:11
Section 6: Create Reports For The point of sale
Create Report For Print Invoice The Customer Order
16:40
Create Report For The profit by (Date & Invoice)
14:32
Create Report For The Amount Items by (Date & Item Code)
14:33
Create Report For Buy Item With Daily Sell
12:16
(See Daily Sell buy The User)
02:42
Section 7: Connecting Between The Point of Sale(POS) Database With SQL Server
How to create The bridge between POS Database with SQL Server
14:30
PDF File : Connecting POS with SQL server
9 pages
Section 8: Network Configration
Connecting Between (Client and Server)
08:38
PDF File: Network Configration
8 pages
Section 9: Course Review
Review & Resource Code
05:02

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Hemn Barzan, Softewar Architect, Developer, Database, NoSQL, SQL Server

Experiment: I have 8 years experience of Database development, created more than 75 database projects for (Government healthy center, Company, Pharmacy, Supermarket, etc..).

Degree : received the master degree in computer science from Huazhong University of Science and Technology, in 2014. Currently, he is a Ph.D student at Chongqing University of Posts and Telecommunication (CQUPT).

Ready to start learning?
Take This Course