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.
Microsoft Access Reports - Passing Totals From A Subreport Into The Main Report
Working with Microsoft Access Reports can be time consuming and fiddly to master and one of the common challenges is correctly writing calculated expressions between main reports and their embedded sub-reports.
MS Access Database Forms: Using The SelStart And SelLength Properties
Have you noticed when you navigate between control fields in your MS Access database forms that it automatically selects the entire content (if not empty) instead of placing the cursor to the end of the last character?
Using some simple Access VBA code, you can now control the placement for the cursor to mimic and automate placing the insertion point Continue reading →
What Types Of Things Can I Do With A Microsoft Access Database?
Microsoft Access offers a variety of different ways to how a database can be used. There are six general types of applications which a database will naturally fall under. They are:
• Personal or One-to-one use
• Small-business (SME) use
• Departmental use
• Corporation-wide use
• Front-end only use (client/server databases)
• Web use
Of course the above uses can be merged into each other but at the very beginning when planning your Access database, you need to know the scope and general use – hence the above categories.
At a basic level, you can use Microsoft Access to develop simple, personal database-management systems (which can also be relational – RDBMS). Some users automate everything from their music CD collections to their home finances and is very easy to use with the built in templates and where applicable wizard tools that make MS Access look like a product that anyone can use.
SQL Commands: MS Access SQL Versus SQL Server – The Differences
It’s a common mistake when MS Access developers assume their know SQL commands being common to all platforms. Yes, there is a common standard syntax but at the same time, there are variances between software systems.
It’s like choosing a flavour of ice cream; different tastes but it’s still ice cream and if you mix them, again different tastes but may not always be compatible to the palette!
I’ve seem many questions come up on forums about the differences and conversions between MS Access SQL and T-SQL (SQL Sever) which there are of course some differences between the two language syntax’s.
So, here’s a few example SQL commands to help you out with or when needing Continue reading →
Microsoft Access Forms – How To Build Your Own MS Access Form Wizard
One of the many uses that Microsoft Access forms can be used for includes the ability to create your very own MS Access form wizard feature.
As you will be familiar with Microsoft Office in general, wizards are useful utilities that provide assistance for general users to complete a task that would otherwise take much longer to manually create step by step.
In MS Access alone, there are many wizard features around ranging from the query wizard to adding predefined (embedded) code for a command button.
Here’s an illustration of a custom form that I’ve built in the past which contains a four page screen for a user to scroll between using the navigation command buttons.
This wasn’t at all complicated and required very little Access VBA code too which developers Continue reading →