Account Management System In Python With Source Code

The Account Management System In Python is a fully functional desktop application developed in Python that covers all of the features that IT students and computer-related courses will require for their college projects or assignments.

This Account Management System is a simple system that has the ability to control and manage the entire data of every account.

This can be one of the most important systems for well-organized account management.

This Account Management System Project In Python is quite useful, and the concept and logic of the project are simple to grasp.

The source code is open source and free to use. Simply scroll down and click the download option.

Account Management System In Python: Project Output

What Is Accounts Management

This Account Management System Using Python is the activity of providing consumers with service, support, and improvement opportunities in order to boost their consumption of a product or service while also increasing customer retention, cross-sell, and upsell chances.

Benefits Of Account Management System

• Improve your sales resource allocation – By understanding customers’ expectations through a proactive feedback system, account management can identify clients who are most likely to create better sales and profits. This helps the company to concentrate its sales efforts on clients who are a good fit for its target market.
• Increase the chance of growth – Customer-company relationships are strengthened through proactive account management methods. This enables the company to turn large accounts into loyal clients that deliver consistent revenue streams over time.
• Improve customer happiness – Account managers use the information from their clients’ accounts to make sure that the products and services they provide meet all of their needs and expectations and solve their problems. It improves the customer experience in terms of on-time delivery, quick response, good after-sales support, and quick resolution of disputes.
• Boost customer loyalty – Account management enables you to meet customer expectations and establish long-term relationships based on trust and added value. This can assist you in retaining highly profitable consumers over time. Larger accounts will generally stay with you if you can devote time and effort to understanding their individual demands. Long-term relationships are preferred by large accounts because they provide their business with trust, reliability, and stability.
• Referrals – Although winning new clients isn’t one of account managers’ core responsibilities, they can assist their organization in gaining new customers by referring them. If you have significant accounts that are pleased with your work, your company can benefit from a regular influx of new clients. If someone needs the service or products you supply, they will almost certainly refer your organization.

Available Features!

• Add Accounts
• Update Accounts
• Search Accounts
• View All Accounts
• Delete Accounts
• Clear All Data

About the Project: Account Management System In Python With Source Code

The Account Management System In Python is a desktop application written and designed in the Python programming language.

The project is open source, and it was made for novices who wish to learn Python.

This Account Management System In Python With Source Code is a simple project for storing and managing all your accounts.

The system comes with all of the necessary capabilities, such as the ability to add, view, delete, update, search, and look at a person’s account listings.

When a person’s account information is included, he or she must include their first and last name, username, password, position, and date.

Project Details and Technology: Account Management System In Python

The code given below is the full source code on Account Management System In Python

DATABASE_ACCOUNT.PY

import sqlite3
def create():
    con = sqlite3.connect("accountdb.db")
    cur = con.cursor()
    cur.execute("CREATE TABLE IF NOT EXISTS tableAccount(id INTEGER PRIMARY KEY,firstname TEXT, lastname TEXT, username TEXT, password TEXT,position TEXT, date TEXT)")
    con.commit()
    con.close()
def viewall():
    con = sqlite3.connect("accountdb.db")
    cur = con.cursor()
    cur.execute("SELECT * FROM tableAccount")
    rows = cur.fetchall()
    con.close()
    return rows

def search(firstname="", lastname="", username="", password="", position=""):
    con = sqlite3.connect("accountdb.db")
    cur = con.cursor()
    cur.execute("SELECT * FROM tableAccount WHERE firstname=? or lastname=? OR username=? OR password=? OR position=?", (firstname, lastname, username, password, position))
    rows = cur.fetchall()
    con.close()
    return rows
def add(firstname,lastname, username, password, position, date):
    con = sqlite3.connect("accountdb.db")
    cur = con.cursor()
    cur.execute("INSERT INTO tableAccount VALUES(NULL,?,?,?,?,?,?)", (firstname, lastname, username, password, position, date))
    con.commit()
    con.close()
def update(id, firstname, lastname, username, password, position, date):
    con = sqlite3.connect("accountdb.db")
    cur = con.cursor()
    cur.execute("UPDATE tableAccount SET firstname=?,lastname=?, username=?,password=?,position=?,date=? WHERE id=?", (firstname, lastname, username, password, position, date, id))
    con.commit()
    con.close()
def delete(id):
    con = sqlite3.connect("accountdb.db")
    cur = con.cursor()
    cur.execute("DELETE FROM tableAccount WHERE id=?",(id,))
    con.commit()
    con.close()
create()

MAIN.PY

from tkinter import *
from tkinter import messagebox
import database_account

window = Tk()
window.title("Account Management System")
window.config(bg="navajo white")
window.geometry('1350x750')

def view():
    lb.delete(0,END)
    for row in database_account.viewall():
        lb.insert(END, row)

def search():
    lb.delete(0, END)
    for row in database_account.search(firstname=firstname.get(), lastname=lastname.get(), username=username.get(), password=password.get(), position=position.get()):
        lb.insert(END, row)

def add():
    database_account.add(firstname.get(), lastname.get(), username.get(), password.get(), position.get(), date.get())
    messagebox.showinfo("Add", "New Account Added Successfully")
    lb.delete(0, END)
    lb.insert(END, firstname.get(), lastname.get(), username.get(), password.get(), position.get(), date.get())

def get_selected_row(event):
    try:
        global selected_tuple
        index = lb.curselection()[0]
        selected_tuple = lb.get(index)
        EntryFirstName.delete(0,END)
        EntryFirstName.insert(END,selected_tuple[1])

        EntryLastName.delete(0,END)
        EntryLastName.insert(END,selected_tuple[2])

        EntryUsername.delete(0,END)
        EntryUsername.insert(END,selected_tuple[3])

        EntryPassword.delete(0,END)
        EntryPassword.insert(END,selected_tuple[4])

        EntryPosition.delete(0,END)
        EntryPosition.insert(END,selected_tuple[5])

        EntryDate.delete(0, END)
        EntryDate.insert(END, selected_tuple[6])
    except IndexError:
        pass

def update():
    database_account.update(selected_tuple[0], firstname.get(), lastname.get(), username.get(), password.get(), position.get(), date.get())
    messagebox.showinfo("Update", "Account Has Been Updated Successfully")
    view()

def delete():
    database_account.delete(selected_tuple[0])
    messagebox.showinfo("Delete Account", 'Account Has Been Deleted Successfully')
    view()
    #lb.delete(END,get_selected_row.selected_tuple)
def clear():
    lb.delete(0,END)
    EntryFirstName.delete(0,END)
    EntryLastName.delete(0,END)
    EntryUsername.delete(0,END)
    EntryPassword.delete(0,END)
    EntryPosition.delete(0,END)
    EntryDate.delete(0, END)

lblfirstname = Label(window, text="First Name", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lblfirstname.grid(row=0, column=0, columnspan=2)

lbllastname = Label(window,text="Last Name", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lbllastname.grid(row=1,column=0,columnspan=2)

lblusername = Label(window,text="Username", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lblusername.grid(row=2,column=0,columnspan=2)

lblpassword = Label(window, text="Password", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lblpassword.grid(row=3, column=0, columnspan=2)

lblposition = Label(window,text="Position", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lblposition.grid(row=4,column=0,columnspan=2)

lbldate = Label(window,text="Date", font=("Calibri", 14, "bold"), fg="black", bg="navajo white")
lbldate.grid(row=5,column=0,columnspan=2)

firstname=StringVar()
EntryFirstName = Entry(window,textvariable=firstname, font=("Calibri", 14, "italic"), width=30)
EntryFirstName.grid(row=0,column=0,columnspan=10)

lastname=StringVar()
EntryLastName = Entry(window,textvariable=lastname, font=("Calibri", 14, "italic"), width=30)
EntryLastName.grid(row=1,column=0,columnspan=10)

username=StringVar()
EntryUsername = Entry(window,textvariable=username, font=("Calibri", 14, "italic"), width=30)
EntryUsername.grid(row=2,column=0,columnspan=10)

password=StringVar()
EntryPassword = Entry(window,textvariable=password, font=("Calibri", 14, "italic"), width=30)
EntryPassword.grid(row=3,column=0,columnspan=10)

position=StringVar()
EntryPosition = Entry(window,textvariable=position, font=("Calibri", 14, "italic"), width=30)
EntryPosition.grid(row=4,column=0,columnspan=10)

date = StringVar()
EntryDate = Entry(window,textvariable=date, font=("Calibri", 14, "italic"), width=30)
EntryDate.grid(row=5,column=0,columnspan=10)

AddButton = Button(window,text="Add",width=12,command=add, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
AddButton.grid(row=6,column=0)

UpdateButton = Button(window,text="Update",width=12,command=update, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
UpdateButton.grid(row=6,column=1)

SearchButton = Button(window,text="Search",width=12,command=search, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
SearchButton.grid(row=6,column=2)

ViewAllButton = Button(window,text="View All",width=12,command=view, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
ViewAllButton.grid(row=6,column=3)

DeleteButton = Button(window,text="Delete",width=12,command=delete, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
DeleteButton.grid(row=6,column=4)

ClearAllButton = Button(window,text="Clear All",width=12,command=clear, font=("Calibri", 10, "italic"), fg="black", bg="navajo white", relief=RIDGE, bd=10)
ClearAllButton.grid(row=6,column=5)

lb=Listbox(window,height=20,width=94)
lb.grid(row=7,column=0,columnspan=6)

sb=Scrollbar(window)
sb.grid(row=7,column=6,rowspan=6)

lb.configure(yscrollcommand=sb.set)
sb.configure(command=lb.yview)

lb.bind('<<ListboxSelect>>',get_selected_row)
window.mainloop()

This Account Management System In Python also includes a downloadable Project With Source Code for free, just find the downloadable source code below and click to start downloading.

By the way, if you are new to Python programming and don’t have any idea what Python IDE to use, I have here a list of the Best Python IDE for Windows, Linux, and Mac OS for you.

Additionally, I also have here How to Download and Install the Latest Version of Python on Windows.

To start executing an Account Management System In Python, make sure that you have installed Python in your computer.

Account Management System In Python: Steps on how to run the project

Download the Source Code below!

Summary

This article is a way to enhance and develop our skills and logic ideas which is important in practicing the Python programming language which is the most well-known and most usable programming language in many companies.

Related Articles

• ATM Program In Python With Source Code
• Cab Booking System Project In Python With Source Code
• Library Management System Project in Python with Source Code

Inquiries

If you have any questions or suggestions about the Account Management System In Python, please feel free to leave a comment below.