Logo
Mail us
ben@accessdatabasetutorial.com

Category Archives: MS Access

Microsoft Access: The mindset of the VBA programmer


Microsoft Access

Microsoft Access Database : The mindset of the VBA programmer From my new VBA book due out soon, here’s an extract about the mindset of the Microsoft Access database VBA programmer… We need to start by establishing a frame of reference as to what we should expect when we are writing VBA code. Consider the scenario where you command a child to “open the door.” Think about all the individual actions that it takes to accomplish that one statement. The child […]

Tags: , , , , ,

Microsoft Access Database Library: 7 Reasons Why It Should Be Used


Microsoft Access Database

7 Reasons Why Microsoft Access Database Should Be Used First of all, let’s clear up what is actually a Microsoft Access Database library. Simply put, it’s a code library or code database when programming your Access database (using VBA code) and is used to manage and access other objects from other applications and sources that are deemed external to MS Access. Therefore, to communicate with say Microsoft Excel or Microsoft Outlook, you would need to first enable and allow permission […]

Tags: , , ,

How to Hide the Ribbon When Launching Microsoft access database ?


Hide the Ribbon When Launching Microsoft access database Having Ribbons in your Microsoft access database application helps a lot when you need to use all the tabs that are present on the ribbon. However, there are times that you need to prevent the tabs on the ribbon from displaying when launching the application. MS Access, by default, does not provide an option for hiding the ribbon. Because of that,you have to opt for external approaches. One way is to create and […]

Tags: , , , , , , ,

MS Access Data Projects: 4 Guidelines to Help You Move On


MS Access Data Projects: 4 Guidelines to Help You With the most recent versions of Microsoft Access 2016, it no longer offers support for Access Data Project (ADP) files but for the more seasoned releases it will still continue to support ADP’s. End-users will find it imperative to learn about the alternatives they could use when planning to update the application. Before recommending any options, there are certain basics you need to understand first. Why Access is never again supporting […]

Tags: , , , , ,

Microsoft Access Database: How To Completely Remove A Database ?


Microsoft Access : How To Completely Remove A Database ? Microsoft Access Database, like with many of the other Microsoft applications is very versatile and can be a valuable asset for businesses (of all scopes). However, unlike MS Word and MS Excel which are normally used in the workplace for the day to day and general running of the business work flow and then can be also used to support Microsoft Access at a level that complements other systems, Microsoft Access Database is the kind of application that takes office applications […]

Tags: , , , , , , ,

Why You Should Avoid Using Memo Fields for Grouping in MS Access ?


A memo field can store a huge quantity of information, allowing up to 65,536 characters, with different choices. In the most recent release of Microsoft access database, it can store up to 1 GB of characters and enables rich text formatting. However, it is often advised to avoid the use of memo fields for grouping in Access. Memo Fields In the 2009 edition of Microsoft access database and including the recent version, there was a bug in which the memo […]

Tags: , , , , ,