Jump to ratings and reviews
Rate this book

Microsoft Access : How to Build an Access Database

Rate this book
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 guide:

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

75 pages, Kindle Edition

Published November 23, 2018

7 people are currently reading
4 people want to read

About the author

Ben Beitler

11 books1 follower

Ratings & Reviews

What do you think?
Rate this book

Friends & Following

Create a free account to discover what your friends think of this book!

Community Reviews

5 stars
1 (25%)
4 stars
2 (50%)
3 stars
1 (25%)
2 stars
0 (0%)
1 star
0 (0%)
No one has reviewed this book yet.

Can't find what you're looking for?

Get help and learn more about the design.