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