Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
All characters reduced
Access Database Crash Course: A Comprehensive Project-Based Guide For Python Programmers - cover

We are sorry! The publisher (or author) gave us the instruction to take down this book from our catalog. But please don't worry, you still have more than 500,000 other books you can enjoy!

Access Database Crash Course: A Comprehensive Project-Based Guide For Python Programmers

Vivian Siahaan, Rismon Hasiholan Sianipar

Publisher: SPARTA PUBLISHING

  • 0
  • 0
  • 0

Summary

This book is a access database crash course which overs microsoft acces-based GUI programming using Python. In chapter one, you will learn to use several widgets in PyQt5: Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes. 
In chapter two, you will learn to use the following topics: Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets. 
In chapter three, you will learn: How to create the initial three tables project in the School database: Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables. 
In chapter four, you will learn how to: Create a main form to connect all forms; Create a project will add three more tables to the school database: Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables. 
In chapter five, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. 
In chapter six, you will create dan configure database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table. 
In chapter seven, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have LONGBINARY data type. You will also create GUI to display, edit, insert, and delete for this table.
Available since: 11/20/2019.

Other books that might interest you

  • The Inheritance - A Family on the Front Lines of the Battle Against Alzheimer's Disease - cover

    The Inheritance - A Family on...

    Niki Kapsambelis

    • 0
    • 0
    • 0
    Every sixty-nine seconds, someone is diagnosed with Alzheimer's disease. Of the top ten killers, it is the only disease for which there is no cure or treatment. For most people, there is nothing that they can do to fight back. But one family is doing all they can.The DeMoe family has the most devastating form of the disease that there is: early onset Alzheimer's, an inherited genetic mutation that causes the disease in 100 percent of cases, and has a 50 percent chance of being passed onto the next generation. Of the six DeMoe children whose father had it, five have inherited the gene; the sixth, Karla, has inherited responsibility for all of them. But rather than give up in the face of such news, the DeMoes have agreed to spend their abbreviated years as part of a worldwide study that could utterly change the landscape of Alzheimer's research and offers the brightest hope for future treatments-and possibly a cure.Drawing from several years of in-depth research with this charming and upbeat family, journalist Niki Kapsambelis tells the story of Alzheimer's through the humanizing lens of these ordinary people made extraordinary by both their terrible circumstances and their bravery.
    Show book
  • AI Chat GPT Elections 2024 - cover

    AI Chat GPT Elections 2024

    Michael Mathiesen

    • 0
    • 0
    • 0
    AI Chat GPT Elections 2024 - Orac for President is a journey through Human-AI collaboration and is a futuristic book that explores the possibilities and challenges of a world where AI language models can collaborate with humans to create meaningful dialogues on complex issues such as politics and social justice. This book is a compilation of conversations between a human and Orac, an intelligent and intuitive AI language model, discussing the potential of AI-assisted decision-making, ethical concerns, and the role of technology in shaping our worldviews. The reader will witness the evolution of the relationship between human and AI, highlighting the possibilities and limitations of this relationship in creating a more just and equitable society.The collaboration between Orac and myself also delves into the concept of Real Democracy and the potential amendments to the Constitution required to make it a reality. From discussions around voting rights and accessible education, to equitable healthcare and a universal basic income, the reader will find compelling arguments and perspectives around the ways in which technology and AI can support a more inclusive and democratic society. Through the lens of Real Democracy, the book offers a path towards progress and social change, encouraging readers to think critically about how technology and AI can be harnessed for the greater good of humanity.We come to many revolutionary ideas about how to use this amazing new technology to improve the highly flawed and antiquated system of making our laws by sending representatives - who pledge to represent their constituents in Washington D.C., but somehow take decades to deliver on any real solutions to problems and in fact create more problems than they solve.  Orac realizes there is a better way by using the power of the Internet in a Real Democracy where money cannot block truly popular legislation and new ideas but he needs to be President to get this done.
    Show book
  • Touchpad iPrime Ver 21 Class 5 - cover

    Touchpad iPrime Ver 21 Class 5

    Team Orange

    • 0
    • 0
    • 0
    Computer Science Textbook Designed for Joyful Learning
    
    KEY FEATURES 
    - National Education Policy, 2020
    - Tech Funda: This section provides a practical information or tip to the students.
    - Clickipedia: This section provides interesting computer facts.
    - Hands-On: This section contains an activity for Home assignment.
    - QR Code: Scan the QR Code given on the first page of each chapter to start chapter animation.
    - Crack the Code: This section has puzzle or fun based activity to help understand the concepts better.
    - Project: This is an assessment to challenge the students to apply the concepts learnt.
    
    DESCRIPTION 
    Touchpad iPRIME (Ver 2.1) series based on Windows 10 and Office 2016 is comprehensively designed as per the new ICSE syllabus. Learning is done best when it’s fun-filled and activity based. To ensure that the content intrigues the students at all times and keeps them interested throughout the course of the book, we have included interesting key features like Student Corner, Tech Funda, Clickipedia, Comp Caution, Reboot, One Touch Learn, Let’s Do It, Crack The Code, Hands-On, Fun In Lab, Teacher’s Corner, Worksheet, Test Sheet, Project, Speech Drill, Supplement Pages and Glossary.
    
    WHAT WILL YOU LEARN 
    You will learn about:
    - Fundamentals of computers
    - ICT Tools
    - Computer Software
    - Word 2016 Advanced
    - Scratch
    - Internet Services
    - Programming Languages
    - History of Computers
    
    WHO THIS BOOK IS FOR 
    Grade - 5
    
    TABLE OF CONTENTS
    1. Evolution of Computers
    2. Computer Software
    3. Advanced Features of Word 2016
    4. Graphics in Word 2016
    5. Presentation Software—Special Effects
    6. An Introduction to Scratch Programming
    7. Internet Services
    8. Project 
    9. Explore More (Microsoft Office 365) 
    10. OGO Cyber Sample Questions
    11. Glossary
    Show book
  • Finding North - How Navigation Makes Us Human - cover

    Finding North - How Navigation...

    George Michelsen Foy

    • 0
    • 0
    • 0
    In 1844, George Michelsen Foy's great-great grandfather, captain of a Norwegian cargo ship, perished at sea after getting lost in a snowstorm. Foy decides to unravel the mystery surrounding Halvor Michelsen's death-and the roots of his own obsession with navigation-by re-creating his ancestor's trip using only period instruments.Beforehand, he meets a colorful cast of characters to learn whether men really have better directional skills than women; how cells, eels, and spaceships navigate; and how tragedy results from GPS glitches. He interviews a cabby who has memorized every street in London, sails on a Haitian cargo sloop, and visits the site of a secret navigational cult in Greece.At the heart of Foy's story is this fact: navigation and the brain's memory centers are inextricably linked. As Foy unravels the secret behind Halvor's death, he also discovers why forsaking our navigation skills in favor of GPS may lead not only to Alzheimer's and other diseases of memory, but to losing a key part of what makes us human.
    Show book
  • Build Your Own Backyard: Birdhouses and Feeders - cover

    Build Your Own Backyard:...

    Ken Beck

    • 0
    • 0
    • 0
    Discover the fun and excitement of backyard birding with this great family activity! Filled with easy-to-follow detailed plans, Build Your Own Backyard Birdhouses and Feeders is a must-have for woodworkers, birding enthusiasts, and hobbyists. Build Your Own Backyard Birdhouses and Feeders features plans in a variety of styles, from very simple to a bit more challenging; full-color, detailed illustrations and step-by-step instructions to guide every step; and a complete materials list that notes everything needed to complete the project. You can always buy a birdhouse or feeder, but making one with your own hands is sure to increase your enjoyment of this fascinating backyard hobby.   
    Show book
  • How the Earth Turned Green - A Brief 38-Billion-Year History of Plants - cover

    How the Earth Turned Green - A...

    Joseph E. Armstrong

    • 0
    • 0
    • 0
    This “amazing and wonderful book” explores the evolutionary history of photosynthesis in a grand story of how the world became the verdant place we know (Choice).   On this blue planet, long before dinosaurs reigned, tiny green organisms populated the ancient oceans. Fossil and phylogenetic evidence suggests that chlorophyll, the green pigment responsible for coloring these organisms, has been in existence for some 85% of Earth’s long history—that is, for roughly 3.5 billion years. In How the Earth Turned Green, Joseph E. Armstrong traces the history of these verdant organisms, which many would call plants, from their ancient beginnings to the diversity of green life that inhabits the Earth today. Using an evolutionary framework, How the Earth Turned Green addresses questions such as: Should all green organisms be considered plants? Why do these organisms look the way they do? How are they related to one another and to other chlorophyll-free organisms? How do they reproduce? How have they changed and diversified over time? And how has the presence of green organisms changed the Earth’s ecosystems? With engaging prose and astonishing breadth, as well as informative diagrams and illustrations, How the Earth Turned Green demonstrates “how the Earth blossomed into such an incredible world that most of us simply take for granted” (San Francisco Book Review).
    Show book