Edit product
Your Cart
    Subtotal

    Is this your street address?

    Card

    ···· ···· ···· 4242
    Test card

    05/18

    Card

    Use a different card?

    Card

    pp paypal

    or pay with

    We do not keep any of your sensitive credit card information on file with us unless you ask us to after this purchase is complete.

    or pay with

    Please confirm your location:
    You'll be charged .

    Your purchase was successful!

    We charged your card and sent you a receipt

      Gumroad Library

      Download from the App Store or text yourself a link to the app

      99¢

      Designing Professional Database Management Systems Using Microsoft Access 2013, 2016 and MySQL: Simplified Guides to Learning RDBMS Administration and SQL with Some Practical Examples and Exercises

      Designing Professional Database Management Systems Using Microsoft Access 2013 and 2016 eBook (pdf)! written by Kelly Joseph is the all-in-one tutorial book to help you achieve your goals in Relational Database Management System Administration. The book shows the screen to screen pictures of each step or procedure to achieve any task in MS Access 2013 and 2016 and also in MySQL Database application. 

       Due to the inevitable rate of technological development, many companies now use these basic MS Office Packages like Access for interview. Microsoft Access and MySQL relieve you of many Office stresses especially Database System Analysts who analyze data. Most graduates miss employment opportunities due to their illiteracy in these basic Microsoft Office Packages like Microsoft Access, Excel and PowerPoint. That is why Kelly Joseph has chosen to help you out. He gives you some real life and practical exercises after each chapter to help you digest the knowledge you acquired in that chapter. 

       Kelly Joseph carefully wrote this book step by step to help those who had the type of zeal he had seven years ago. This book: Designing Professional Database Management Systems Using Microsoft Access 2013 and 2016 is needed by everybody both students and Relational Database System Management Professionals because it covers the curriculum for both fields. He concentrated on the two most popular Relational Database Management System (RDBMS) Packages: MS Access and MySQL which is one of the three applications he knows well. Even if you don’t have a previous knowledge in Database Management, don’t panic because Kelly assumes that every user of this book has no previous knowledge of this course. This enabled him start from the scratch in other to carry everybody along!

      CONTENTS

      CHAPTER ONE

      PART 1: INTRODUCTION TO MS-ACCESS (ACCESS 2007, 2010, 2013 AND 2016)

      PART 2: GETTING STARTED WITH MS-ACCESS AND ITS USER INTERFACE

      CHAPTER TWO

      PART 1: OBJECTS OF A DATABASE – TABLE, FIELD PROPERTIES AND DATA TYPES

      PART 2: TABLE OPERATIONS AND RELATIONSHIPS/JOINS - INTRODUCTION

      CHAPTER THREE

      PART 1: FORM OPERATIONS AND SOME POWERFUL BUILT IN FUNCTIONS IN MS ACCESS 2016 AND 2013

      PART 2: BUSINESS APPLICATIONS OF MS ACCESS BUILT IN FUNCTIONS TO SALES REPORTS AND STOCK REPORTS

      PART 3: BUSINESS APPLICATIONS OF MS ACCESS BUILT IN FUNCTIONS TO STOCK CONTROLS AND BUDGET CONTROLS

      CHAPTER FOUR

      PART 1: INTRODUCTION TO QUERIES IN MICROSOFT ACCESS 2013 AND 2016

      PART 2: SOME SPECIAL QUERY FUNCTIONS & EXPRESSIONS IN MS ACCESS & THEIR APPLICATIONS

      PART 3: SOME SPECIAL QUERY FUNCTIONS & EXPRESSIONS IN MS ACCESS & THEIR APPLICATIONS

      PART 4: PRACTICAL APPLICATION OF MS ACCESS QUERY FUNCTIONS IN STUDENTS’ RESULT SYSTEM

      PART 5: PRACTICAL APPLICATION OF MS ACCESS QUERY FUNCTIONS IN WORKERS’ PAYROLL SYSTEM - PART 5

      CHAPTER FIVE

      PART 1: HOW TO BUILD ADVANCED & ACTION QUERIES IN MS ACCESS 2013 & 2016

      PART 2: HOW TO BUILD THE FIND DUPLICATES, FIND UNMATCHED & CROSSTAB QUERIES THROUGH MS ACCESS QUERY WIZARD

      PART 3: HOW TO BUILD AND MANIPULATE PARAMETER QUERIES IN MS ACCESS 2013 & 2016

      CHAPTER SIX

      PART 1: LEARN SQL IN MS ACCESS & MySQL DATABASES – STEP BY STEP GUIDE

      PART 2: FULL EXPLANATION & ILLUSTRATION OF SQL CLAUSES & KEYWORDS IN MS ACCESS & MySQL

      PART 3: PRACTICAL APPLICATION OF SQL IN MS ACCESS & MySQL - UNION & JOIN QUERIES

      PART 4: HOW TO CREATE JOIN QUERIES IN MS ACCESS & MySQL– OBJECT JOINS OR RELATIONSHIPS

      CHAPTER SEVEN

      PART 1: HOW TO DESIGN PROFESSIONAL REPORTS IN MS ACCESS USING VARIOUS METHODS

      PART 2: GUIDES TO CREATE MAILING LABELS AND VARIOUS TYPES OF CHARTS & GRAPHS IN MS ACCESS

      PART 3: FORMATTING A REPORT IN MS ACCESS: PRINTING, PREVIEWING, AND EXPORTING

      CHAPTER EIGHT

      PART 1: STEP BY STEP GUIDES TO CREATE EMBEDDED & STANDALONE MACROS IN MS ACCESS

      PART 2: STEP BY STEP GUIDES TO ENCRYPT & DECRYPT MS ACCESS DATABASE

      PART 3: GUIDES TO DESIGN & CUSTOMIZE A FUNCTIONAL SWITCHBOARD FOR MS ACCESS DATABASE

      Sorry, this item is not available in your location.
      Sold out, please go back and pick another option.

      You've purchased this product

      Give it a rating:

      See it in your library

      View in Library
      • Size 4.38 MB
      • Length 197 pages
      • Format PDF

      Checkout

      Designing Professional Database Management Systems Using Microsoft Access 2013, 2016 and MySQL: Simplified Guides to Learning RDBMS Administration and SQL with Some Practical Examples and Exercises

      Enter your info to complete your purchase

      Card

      ···· ···· ···· 4242
      Test card

      05/18

      Card

      Use a different card?

      Card

      pp paypal

      or pay with

      We do not keep any of your sensitive credit card information on file with us unless you ask us to after this purchase is complete.

      or pay with

      Please confirm your location:
      You'll be charged US$0.99.

      Your purchase was successful!

      We charged your card and sent you a receipt

        Gumroad Library

        Download from the App Store or text yourself a link to the app

        Thanks for the purchase. Feel free to get back to us on our website if you find any difficulty in studying the book

        Good news! Since you already have a Gumroad account, it's also been added to your library.

        Powered by Gumroad