Microsoft Access 2016: From Design to Use - Full Database Guide

by Ben Beitler

A  book that will give a comprehensive and practical direction to your endeavour to learn about Microsoft access 2016 and how to use it to get maximum output from the software. To learn about any new technology, there needs to be the practical and comprehensive approach in order to apply ms access programming in everyday life and achieve maximum output from it. But when you search for the materials make this happen, they often disappoint you with their content which is written by theorists who don’t focus on practical applications which is, in reality, what you actually require. Microsoft access 2016 step by step enables you to create powerful and comprehensive databases because of all the features the software possesses. But to someone who doesn’t have the complete know-how of the software and how it works, such a software can be more problematic than useful.This textbook will enable you to use the software to its full extent as I have been teaching Relational Database Management System Administration for a number of years and by virtue of that I have a hands-on approach towards using this software which I have put forward in the book itself. The book contains the screen to screen pictures and procedures to achieve any task possible in Microsoft access 2016 and enables the reader use the software with ease even if he/she happens to be a non-programmer. Here’s what you will find inside this The Best Ways to Design and Build an vba access My Insider Techniques and Design Methodologies Clearly Explained How to avoid the ‘Pear Shaped Database’ trap Instantly improve your confidence and approach to building an ms access Ways to overcome the parts of an Access Database The giant myth about ‘Database Normalisation’ and how to handle this process What are the difference between Access Tables v Access Queries The techniques in building an Access Query for all levels Mastering the correct conventions used avoiding the common errors A step by step guide for new users A summary of other variations of queries Clear Step by Step instructions for each query type Useful tips and tricks to handle the output Covering the powerful calculation and summary techniques Special queries – creating a league table How to use an interactive query (no programming required) Understanding relational databases with queries Using Macros and some easy vba access Creating Dialog (modal) screens and Menu Navigation interfaces Mastering the all-important combined properties to release the power of a Form Building an Access Report from Scratch Introducing the Properties and Terminology Building Sub-Reports from Scratch – a real document example Building a Chart Report and using the Microsoft Graph Utility Download free sample data to test and follow all my examples Web applications using SharePoint and other serv

525 pages, Kindle Edition

Published December 1, 2017

Reviews

[Steve Conway · Rating 4 out of 5]

Great Introduction to Access and Databases

A little more useful than the standard introduction book, and goes a bit further than others I have read.
Well written, introduces the topic and terminology without getting bogged down.
Read in a Kindle app (and was available on Kindle unlimited) and was fine.
Would recommend for beginners who like to be treated as having a modicum of intelligence by the author.