Author Archives: Ben

Microsoft Access Database Tutorial – How To Use Spellchecker On A MS Access Form

Microsoft Access Database Tutorial – How To Use Spellchecker On A MS Access Form You’ve seen the Microsoft’s spell checker tool across Word, Excel and other Office applications and it’s even available within Microsoft Access database too. When entering data … Continue reading

Posted in Forms, MS Access, Utilities, VBA | Tagged , , , , | Leave a comment

Microsoft Access Forms – How To Build Your Own MS Access Form Wizard

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 … Continue reading

Posted in Forms, MS Access, VBA | Tagged , , , , | 4 Comments

How to Convert Microsoft Access Macros To Visual Basic For Application VBA

How to Convert Microsoft Access Macros To Visual Basic For Application VBA The scenario: You’ve inherited an Access database that was originally built way back say with version 97 and some of the forms have started to look a little … Continue reading

Posted in Macros, MS Access, Utilities, VBA | Tagged , , , , | Leave a comment

Microsoft Access Database: How to Make MS Access Database Executable

Microsoft Access Database: How to Make MS Access Database Executable This is not the first time I’ve discussed how to make MS Access database executable by converting it into either a MDE or ACCDE file format but some of the … Continue reading

Posted in Database Theory, Microsoft Training, MS Access, Utilities | Tagged , , , , | 5 Comments

Designing An Access Database: Some Simple Steps For Your New MS Access Database

Designing An Access Database: Some Simple Steps For Your New MS Access Database As I have preached many times and so it seems other Access database experts are of the same opinion, designing an Access database requires a plan, time … Continue reading

Posted in Database Theory, MS Access | Tagged , , , , | Leave a comment

Access Form Designs – How To Create A Report Interface For Your Access Database

Access Form Designs – How To Create A Report Interface For Your Access Database For the more polished and professional database, using Access form designs doesn’t necessarily mean viewing records from tables and queries. It can also serve as a … Continue reading

Posted in Dialog Boxes, Forms, MS Access, Reports, VBA | Tagged , , , , | 2 Comments

Microsoft Access Queries – How Many Types Do You Know And Use In Your Access Database?

Microsoft Access Queries – How Many Types Do You Know And Use In Your Access Database? You use Microsoft Access queries to view, change, and analyse data in different ways. You can also use them as a source of records … Continue reading

Posted in MS Access, Queries | Tagged , , , , | Leave a comment

Microsoft Access Tutorial: How To Resize Form Fields Dynamically Using MS Access VBA

Microsoft Access Tutorial: How To Resize Form Fields Dynamically Using MS Access VBA I often see many poorly designed Access forms that just make it hard and clumsy to navigate and use. One particular element (and there are many) is … Continue reading

Posted in Forms, MS Access, VBA | Tagged , , , , | Leave a comment

Welcome to Microsoft Access Database Tutorial

Sunday, Oct 26, 2014 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 … Continue reading

Posted in MS Access | Tagged , , | Comments Off

Microsoft Access Tutorial: How To Create A Leading Dot List

Microsoft Access Tutorial: How To Create A Leading Dot List If you wanted to generate a table of contents or a set of index pages, the format for this type of document tends to have leading dots connecting narratives with … Continue reading

Posted in Forms, Functions, MS Access, Reports | Tagged , , , , | Leave a comment