"Learn about Access Databases. Plenty of Access database tutorials, step by step - get you started!"I know from a personal (and sometimes painful) experience of the long nights spent drinking plenty of black coffee sitting in a small dingy smoked filled room with a good friend of mine learning how to build, implement and work with this application wishing we had decent help files, books and even a useful website resource; the number of mistakes and frustrations working with then version 1.1 were made and the heartache of realising some of the methods implemented could have been altogether avoided if only someone had provided me with help and the human element of using an Access database system. This website is for those who don’t like drinking black coffee or the long nights and working in the dark as I attempt to provide and part my experience with plenty of Access tutorials, templates and help files covering all versions (current version being Access 2010) that will assist you in designing that illusive database using the correct methodologies and techniques. About Access databases provides all users whatever their levels of abilities covering from beginners wanting to learn how to create a standard stand-alone database using simple Access templates, downloading example databases to picking up Tips 'n' Tricks along the way through to the more advanced accomplished user who wants to know about advanced queries, forms and reports design techniques. The Access database application provides a rich set of powerful tools ranging from a simple database design model to the multi-user network version using Access's administrative tools at all levels which include the Relationship Window, Database Splitter, Linked Manager Tool and Access Security module to name but a few. For the more technical, we discuss and show the database design methodologies, illustrate database normalisation principles, use Access SQL and master Access VBA code. With this wesbite 'About Access Databases', I’ll show you how to use the application’s help files correctly and efficiently, cover frequently asked questions and provide SQL and VBA code examples (for the advanced user) to help smooth that learning process at a good pace and slowly flatten what sometimes appears to be a steep learning curve! For beginners, I suggest you start by reviewing the pages on Access fundamentals and complete the tutorials to ease you through this learning curve. Even intermediate users may find some discussion points useful and you never know, the penny may drop too. Learning about Access databases to produce great looking applications is at the end of a mouse click in this website and this is my gift to you with no obligation to buy anything at all - it’s all free information! I hope you enjoy using this website and start learning the power of using Microsoft Access. Thank You.
PS: Check out my other
Access Database Tutorial Blog Let’s Connect!
 This website is continually being re-developed and more content will appear on a week by week basis. If you wish to know more about an Access database topic and can not find it on this website, please send a personal email to me - ben beitler and I will respond within 24hrs.
|
Links
Learning SEO Optimization | Finding Keyword Phrases
Reviews - Books
The following books are my personal recommendations for all levels of Access database users and developers.
Enjoy!
It covers versions from 2000 through to 2010 which has some very interesting and new powerful features. Beginner or not, there is something for everyone and Microsoft now encourages developers to use Access macros as the first choice option to automate your database.
This is a great book for beginners. It takes you through from the very beginning without too much jargon 'computer' talk and adds a little humour to your learning.
This is one of my favourites and is a starter recommendation for my students.
Get the Access 2010 information you need to succeed with this comprehensive reference. If this is your first encounter with Access, you'll appreciate the thorough attention to database fundamentals and terminology.
You’ll want to keep this soup-to-nuts Access reference close at hand!
This book provides you with the tools and techniques you’ll need in order to build more sophisticated solutions. After walking through the features of Access 2007 VBA, you’ll learn all about object–oriented programming and ADO. Two comprehensive case studies presents you with the hands–on experience in building real–world solutions using the concepts covered in the book.
It's the one I use as a reference for VBA students!
(click on image below)