Designing Professional Database Management Systems Using Microsoft Access 2013 & 2016 & MySQL: Simplified Guides To Learning RDBMS Administration And SQL ... (Microsoft Office Tutorials Series)
File Size: 11665 KB.
Print Length: 292 pages.
Formats: PDF, ePUB & mobi.
(4.5 / 5) (5 votes).
Designing Professional Database Management Systems Using Microsoft Access 2013 & 2016 & MySQL: Simplified Guides To Learning RDBMS Administration And SQL … (Microsoft Office Tutorials Series)
Do You Want to Learn Microsoft Office Access and MySQL Database Management Systems up to the Professional and Advance Level?
Then Designing Professional Database Management Systems Using Microsoft Access 2013 and 2016! 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!
Some of the Topics Covered in this book include:
•DATABASE TERMINOLOGIES AND IMPORTANCE OF SETTING UP A DATABASE IN AN ORGANIZATION
•HOW TO GET MS-ACCESS 2016 OR 2013 ON YOUR WINDOWS PC
•OBJECTS OF A DATABASE – TABLE AND TABLE OPERATIONS
•OBJECTS OF A DATABASE
•TABLE AND TABLE OPERATIONS
•FOUR PRINCIPLES FOR BUILDING A STRONG FOUNDATION FOR YOUR DATABASE
•FORMS AND MANIPULATIONS IN MICROSOFT ACCESS
•SOME POWERFUL MS ACCESS BUILT-IN FUNCTIONS
•WORKING WITH QUERIES IN MS ACCESS
•PRACTICAL ILLUSTRATION OF QUERY
•BUILDING ADVANCED & ACTION QUERIES IN MS ACCESS
•LEARNING SQL IN MS ACCESS & MYSQL DATABASES
•PRACTICAL APPLICATION OF SQL IN MS ACCESS DATABASE
•CREATING REPORTS IN MS ACCESS
•CREATING MACROS & SWITCHBOARDS IN MS ACCESS
You are very lucky to have located this simplified guide to learning Microsoft Office Access to an expert level!
If while studying this book, you find any section confusing, visit www.microsofttut.com, search the related tutorial post to the confusing section category and type your question under the the comment section. I will clarify you!