Welcome to the Access Database Tutorial website that will show you how to use Microsoft Access Database by learning and managing this powerful application using the most effective techniques and tools available for visitors with very little or no knowledge to get you up and running without the need to learn all the ‘geek’ speak keeping it Jargon free that most trainers and consultants like to impress you with!
Also, this website contains a blog, products on offer and free general tips to help users find out all about latest news and articles I feel worth mentioning along with my recommendations of videos and books.
The quickest way the building an Access database application is to use the wizard and template tools available which are a breeze! But you need to have some idea of what type of database you are going to end up with a bit of planning first.
To help you along, I have written seven articles (courtesy of EzineArticles) to help explain the database methodologies further.
Microsoft Access Tutorial: Hiding Access Tables As ‘USYS’ System Tables
Hiding tables (or any object) in your Access database is a simple enough process. You only need to set the objects hidden property (to True) and reveal the ‘Hidden Objects’ setting from the navigation pane options screen.
But in this quick Microsoft Access tutorial here, there is another method of stopping your tables appearing in Navigation pane (or Database window) by renaming the table(s) with the prefix USYS. This will convert your table into a system object, which cannot be viewed in the normal environment.
A great overview for new users to Access as wells as for users migrating from the earlier versions of Microsoft Access (2003, XP, 2000, 97!).
This video tutorial makes it look easy to create and manage an Access database because it really is easy to do so!
This quick guide can also apply to the later version of Microsoft Access (2010) though the ‘Office‘ button has now been replaced with a ‘File‘ tab taking you to the ‘Backstage‘ environment.
You will need to get up to speed on how to build more in depth tables, queries, forms and reports as well as understand database terminology and methodologies including how relational databases work (rdbms).
Here’s a brief history of Microsoft Access just in case you wish to step back and reminisce
A brief history of Microsoft Access
Late 1992, Microsoft released the first version of Access (version 1.0) desktop database application for the Windows operating system and was shortly replaced with version 1.1 in mid 1993 to incorporate better compatibility with other Microsoft Office products of that time and more importantly introduce the ability for programmers to code this application using Access BASIC.
Version 1.1 was buggy! and had performance issues and in the same year Microsoft released Windows 3.1 operating system along with Microsoft Office 4.3 Pro (suite of applications including Excel, Word, PowerPoint with Access – version 2.0) as it required the improved hardware, software memory and the power supported by Windows 3.1.
This was an ideal desktop database application tailored to the small to medium sized business that required a low cost database. At that time, the capacity of a disk hardrive was less than 100 MB (mega bytes) and typical document file sizes were in the 100’s of bytes. Continue reading “Here’s a brief history of Microsoft Access”
This video is a good advert that shows some of the new features – adding a navigation form with tabs that allows you to move between other forms replacing the conventional menu manager tool from previous versions.
It also gives you a quick overview of how sleek looking this version is compared to earlier versions (not so much Access 2007 but earlier) and how interactive the Ribbon Bar is to the selected item (object) with dynamic previews when formatting the components.
New users to Microsoft Access will find this a pleasing application to work with but be warned the learning curve is a little steep at first but with determination and persistence, you will be able to master this application much quicker than perhaps its predecessors.
By the way! You can always engage in a training session (or two) with me to learn Microsoft Access in quick time.
This video from YouTube takes you from the very beginning even before working with the actual database application which is often overlooked when designing and planning an Access database.
It’s a good guide to help relate how you actually would use and benefit from any database in the ‘real world’ making this a very human and user friendlier approach and best of all it’s ‘geek’ speak and jargon free!