Logo
Mail us
ben@accessdatabasetutorial.com

Monthly Archives: February 2012

Microsoft Access String Function: Borrowing String Functions from Excel


Microsoft Access Database

I published an article last week on how you can use an Access string function that doesn’t really exist in Microsoft Access. In fact, you can build any function you like but using Microsoft Excel which has the function I wanted to utilise saved my having to create a function from scratch.Check it out below how you can do this… Custom Microsoft Access Functions: How To Borrow Functions From The Microsoft Excel Library The definition of any function no matter […]

Tags: , , , , ,

How To Make Labels In Access Databases Using The Label Wizard Tool ?


Access Databases

Take a look at this video tutorial which is under 7 minutes long on how to make labels in Access using the label wizard tool. It’s a very simple utility to use and the video explains in good detail of each step required to build effective labels for your Access database reports. How To Make Labels In Access Databases Using The Label Wizard Tool? It’ s refreshing to see the author of this video see some ‘error‘ or warning prompts […]

Tags: , , , , ,

How To Create An Access Query: The Simple Steps (Part 2) ?


Microsoft Access 2007

In part 1, I explained the worklfow and planning on how to create an Access query by taking a pen and paper exercise to create that checklist. In this second part, I’m going to quickly step you through the essentials. As a reminder, here’s the pseudo statement that started the process to list your tables, fields and other key attributes including criteria and sorting: Show a list of order transactions for the first quarter of 2011 of all customers based […]

Tags: , , , ,

ListBox Controls In Microsoft Access Database Forms


MS Access Database

ListBox Controls In Microsoft Access Database Forms – Simple To Create This video tutorial (less than 3 minutes) demonstrates what Listbox controls are in a Microsoft Access form and explains the difference between this control and the similar ComboBox control. ListBox Controls In Microsoft Access Database Forms – An Alternative To The ComboBox Control Using default control wizard utility, the system builds Listbox controls (including the ComboBox too) in seconds with the option of either defining your own value list […]

Tags: , , , , ,

How To Create An Access Query: The Simple Steps (Part 1) ?


Microsoft Access Database

In this post, I’m going to talk about the planning of how to create an Access query, which is the step prior to using Microsoft Access itself (that’s in part 2). The Access query is an important object to your database as it will serve you in your final reports, maintain data integrities and control workflows with code. How To Create An Access Query: The Simple Steps (Part 1) Here are my steps to planning and create an Access query […]

Tags: , , ,

Microsoft Access Dependencies: What Is The Object Dependencies Pane?


Access Database VBA

You may have been using Microsoft Access for some time now but there are always new techniques and tools to know including Access dependencies. This utility gives you a view of related Access objects including tables, queries, forms and reports. What if you decided to delete say a query? How would that impact the rest of your database? Using this tool, you at least get an idea to which other objects are somehow related before taking any action. Take a […]

Tags: , , , , ,