Data Access Macros – Unique To Microsoft Access Database 2010

Data Access Macros – Unique To Microsoft Access Database 2010

Access macros have always been around going right back to the earliest releases of the 1990’s and as new versions became more sophisticated and richer so macros had a more important role to play. VBA code of course was later introduced and is typically the number one choice for programmers but Access macros are making a come back with the new exclusive addition of Data Macros to Microsoft Access 2010.

httpv://www.youtube.com/watch?v=bZRJF0ZykNU

Data Access Macros – Unique To Microsoft Access Database 2010

With the additional new enhancements of Data Access macros, the need to solely depend on Access VBA has diminished. The ‘Die-Hard’ developer may hold a debate on the power and benefits of using macros in the first lace but let me remind you that Microsoft Access wasn’t designed for the programmer – it was designed for the ‘Power-User’.

data access macrosUse Data Access macros to manage auto updates of records changes which is the equivalent to SQL Server Triggers and now if you play with this a little more, could you build your very first audit log system within Microsoft Access?

Microsoft Access Database: Query In Microsoft Access As Nested

Microsoft Access Database: Query In Microsoft Access As Nested

Here’s a quick video tutorial which covers how a query in Microsoft Access is nested in another Access query and the reason why you may want to approach this technique instead of creating one big query in the first place.

BTW: The narrator sounds like one my former physics lecturers which if being in a classroom on a hot summers Friday afternoon didn’t send you into a comatosed state then he did!

It’s only three and half minutes long  – luckily :)…

httpv://www.youtube.com/watch?v=3xQEfon-JPY

Microsoft Access Database: Query In Microsoft Access As Nested

The way I use a nested query in Microsoft Access is for the purpose of re-using queries again and again making it modular. This means, one query could be a base query for other queries to hang off it when wishing to summarise data and provide more locally based reporting.

In other words, split the query in Microsoft Access into two tiers; a base query for queries that will have dependencies making reporting easier to manage.

To learn more about queries, take a look at my eBook offer about more advanced queries.

The Pros And Cons Of Using Access Queries Or Table Recordsets In A Form

Microsoft Access Database: The Pros And Cons Of Using Access Queries Or Table Recordsets In A Form

I wrote the following article this week based on a comment from a facebbok fan who wanted to know which type of record source should you use when building Microsoft Access database forms and reports.

microsoft access database record sourceHere’s the aritcle…

You build your database using tables and queries testing the architecture and setting keys and indexes. Then you want to make the reporting easy to use and pretty to look at and now you are into spending Continue reading “The Pros And Cons Of Using Access Queries Or Table Recordsets In A Form”

Microsoft Access Database: How To Really Hide Access 2007 Ribbons With VBA

Microsoft Access Database: How To Really Hide Access 2007 Ribbons With VBA

Let’s start by saying this also applies to Microsoft Access 2010 since it also uses the Fluent Ribbon Bar.

I’m not talking about how to hide or show the Access 2007 ribbons (or Access 2010 ribbons for that matter) but how to really hiding the ribbon bar which requires some simple Access VBA code.

Take a look at the following screenshot which hides the standard hidden ribbon bar but only displays the menu tabs (try it by toggling CTRL + F1 keyboard):

access 2007 ribbonNow take a look at the next screenshot and the Continue reading “Microsoft Access Database: How To Really Hide Access 2007 Ribbons With VBA”

Microsoft Access Database: Using The Tag Property in Microsoft Access Forms

Microsoft Access Database: Using The Tag Property in Microsoft Access Forms

Using a Microsoft Access database always requires a plan when developing software applications, which includes the scoping, specification, building and then testing begore using.

Building Access forms and especially automating it with macros or VBA, there are some properties that can help and the one I want to show is the Access Form Tag Property.

Take a look at my video below.

httpvh://www.youtube.com/watch?v=MDAc6biQWBY

Microsoft Access Database: Using The Tag Property in Microsoft Access Forms

microsoft access forms tag property

Even reports have this Tag property available but most developers will use Access forms first and foremost.

 

Want to learn more about Microsoft Access?

Take a look at my eBooks and offers available that is full of rich and valuable information and come with a 100% money back, no questions asked guarantee if not fully satisfied.

How To Remove Multiple Records With A Microsoft Access Delete Query

How To Remove Multiple Records With A Microsoft Access Delete Query

Here’s an article I wrote for EzineArticles about handling multiple records or duplicated records in a table and that by calling a couple of the four action queries; in this case the delete and append queries you can clean up your database without the need to use any form of coding using either VBA or a macro (or two).

Take a look at this article and I welcome your comments in the reply box below and share your experiences with this community.

How To Remove Multiple Records With A Microsoft Access Delete Query

Microsoft Access Delete Query – one of the four action queries.

Reporting in a Microsoft Access database is as only good as data inputting or how records are stored (including importing) in your Access database – You can only get out, what you put in!

Microsoft Access database icon - blueIf data archiving is out of your remit and your have no control, how do you handle duplicated or multiple records that can sometimes leak into your Access database?

Microsoft Access queries are the most powerful set of objects available as it serves you for your normal reporting requirements as well as maintaining data processes or data management procedures. These types of queries are known as ACTION Queries.

Why do you sometimes have multiple records in the first place?

  1. Well maybe, they are not duplicates but repetitive records for different instances and therefore should not be removed! Check your Continue reading “How To Remove Multiple Records With A Microsoft Access Delete Query”

Microsoft Access Database: Access VBA to Microsoft Outlook Tasks

Microsoft Access Database: Access VBA to Microsoft Outlook Tasks

Take a quick look at this Access VBA video (less than 3 minutes) of my latest utility offer demonstrating how to send data using Microsoft Access VBA to a new task in Microsoft Outlook.

httpvh://www.youtube.com/watch?v=-gm0aBVfKMg

Microsoft Access Database: Access VBA to Microsoft Outlook Tasks

This is a simple and very affordable utility offer with a 100% money back guarantee.

access vba outlook task design

Microsoft Access Database: How To Speed Up a Slow Microsoft Access Database Running Over a Network

Microsoft Access Database: How To Speed Up a Slow Microsoft Access Database System

microsoft access database lan


I found the following article which gives you some pointers on how to speed up a slow running Microsoft Access database application when being shared over a network (LAN) and your Access database is playing the role of ‘Client/Server‘ as part of your business IT systems.

Take a look, read on…

Microsoft Access Database: How To Speed Up a Slow Microsoft Access Database Running Over a Network

Microsoft Access is the perfect tool for building databases for companies of all sizes. However, when it comes to sharing that database over a network, amongst Continue reading “Microsoft Access Database: How To Speed Up a Slow Microsoft Access Database Running Over a Network”