Point of Sale (POS) System
4.0 (19 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.
108 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Point of Sale (POS) System to your Wishlist.

Add to Wishlist

Point of Sale (POS) System

•Learn how to use a database for creating the Customer Database - POS Point of Sale System
4.0 (19 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.
108 students enrolled
Last updated 8/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
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)
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.

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
26 Lectures
04:39:10
+
Introduction
1 Lecture 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.
Preview 01:55
+
Ways to Open The Database
1 Lecture 02:39
+
Create Tables for The Point Of Sale
3 Lectures 26:39

Create Tables For The Customer Order
04:16

Create Table for Expenses with Table Profit
06:23
+
Create Queries for The Point Of Sale
2 Lectures 13:32
Create Apend Query for The Profit
09:59

Create Queries For Total Quantity
03:33
+
Create Forms for The Point Of Sale
9 Lectures 02:08:32
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 Reports For The point of sale
5 Lectures 01:00:43
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
+
Connecting Between The Point of Sale(POS) Database With SQL Server
2 Lectures 14:30
How to create The bridge between POS Database with SQL Server
14:30

PDF File : Connecting POS with SQL server
9 pages
+
Network Configration
2 Lectures 08:38
Connecting Between (Client and Server)
08:38

PDF File: Network Configration
8 pages
+
Course Review
1 Lecture 05:02
Review & Resource Code
05:02
About the Instructor
Hemn Barzan Abdalla
4.0 Average rating
19 Reviews
108 Students
1 Course
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. Also received Ph.D degreein Communication and Information Engineering from CQUPT University, in 2017.