Using the MS Access Macro to Automate Your Database

The MS Access macro has divided developers ever since their introduction. They’ve not changed a great deal in each release, although Office 2010 will see the most significant changes yet. Cryptic error messages, hard to debug and low on error checking are just some of the complaints from seasoned developers.

Despite the criticisms, MS Access macros are surprisingly powerful and you will find you can create some amazing functionality. Think about all those mundane, repetitive tasks that you end up performing time and time again. Could you automate any of them with a macro? Continue reading “Using the MS Access Macro to Automate Your Database”

Calculated Values in Microsoft Access Forms or Reports Video Tutorial

A quick video tutorial showing how to carry out basic calculations in a form though it can be applied to a report too.

It demonstrates using the Expression Builder tool which is useful for picking and choosing functions, setting operators and locating other objects from other forms, report, queries and tables.

A new look in Microsoft Access 2010 is the Expression Builder tool and has essentially the same functionality as the old one. Also, you can now even store a calculated field into a table for the first time.

Finally, if your are going to calculate in a query, you do not start with the ‘=’ sign as demonstrated with a form (and for a report).

Learn About Subqueries in Access Courses

An understanding of queries is critical to database management. Without Access queries, you can’t get at the information and the data is useless.

Once you master queries, a subquery is a powerful tool that greatly expands your abilities to get exactly the data you need. To unleash the real power of a subquery, you need to become familiar with SQL (pronounced “sequel”), the language of database queries. This type of knowledge, usually taught in advanced level Access courses and can make your database exponentially more powerful. Continue reading “Learn About Subqueries in Access Courses”

Make Microsoft Access Open Up Excel with VBA – Video Tutorial

This is for the more advanced Access user/developer but hey! new users who have some understanding or experience with VBA in other applications (and I’m really suggesting Excel VBA) then this may be of interest to you too.

This is why this video tutorial talks about Access and Excel with VBA which is a common code requirement and is clearly explained here not leaving anything to the imagination trying to guess what happened next.

Just remember the author demonstrates by running and stepping line by line through the code using the F8 function key which allows you to observe at your own speed what each line of code actually excutes.

If you are serious about VBA, you will need some reference guide and/or book. Maybe a training session? Let me know – Contact Me

3 Useful Things You’ll Learn in Microsoft Access Training Courses

Most people say that they feel intimidated by MS Access. Training courses designed for rapid learning however, can get you feeling confident in just a matter of days. There are any number of reasons why you or your employees could benefit from taking Access training; from improving efficiency, to seeing data in new ways, to building better relationships with your customers through superior tracking of customer inquiries and orders.

Most people know that Access is a database program, but since many people haven’t explored it in detail, they aren’t sure what they might learn in MS Access training. Here are 3 interesting and useful things you’ll learn after just two or three days of Access courses that could drastically change the way your business operates. Continue reading “3 Useful Things You’ll Learn in Microsoft Access Training Courses”

Microsoft Office Access 2007 & Microsoft Office Excel 2007 – Which one to use?

A quick and useful video demonstration highlighting the pros and cons between the popular Microsoft Office applications.

As newer versions are released (the latest being Microsoft Office 2010), so the functionality becomes richer and the closer applications become making it even harder to decide which one to choose. Luckily, Microsoft Office (Professional) has both Excel and Access, the only problem now is to understand the key differences.

It’s natural to lean towards Microsoft Excel – why? Well, everyone starts here before migrating to the more powerful Microsoft Access database application but many more simply stay put – in the comfort zone!

This video demo is a good start to help differentiate the two – well worth two and half minutes of your time!

Converting a Microsoft Access Database File to a MDE File or ACCDE File

Microsoft Access database applications are normally planned, designed and built using the standard single file format in either .MDB or the newer .ACCDB (Access 2007/2010) and then distributed with all the objects (Tables, Queries, Forms, Reports, Macros and Modules -VBA code) fully accessible with the standard default settings applied.

To help lock down and prevent certain objects especially Forms, Reports and any code being modified (via the design mode), you can convert your database file into an ‘executable‘ file format where the .MDB becomes a copy as an .MDE and the .ACCDB to a .ACCDE.

This will protect and seal the database file which is better than deploying just the open file format into either an Access runtime or the full version of Access still allowing users to be able to utilise, store and process data as well as run the other objects as normal.

Continue reading “Converting a Microsoft Access Database File to a MDE File or ACCDE File”

Using Microsoft Access To Organise Your Life

A useful introduction video showing the ‘back-end’ tools namely Tables and Queries being designed and used. It’s only the start though and you will need to do some more research.

I like this video because it’s not been scripted or rehearsed showing how we all think when creating a table and a query with the author making decisions on the go applying changes during his presentation – great!

If you want help, please contact me for advice and how you and I can work together getting you up to speed quickly.

When to Use Microsoft Access, When to Use Microsoft Excel

Tea or coffee? Shoes or trainers? Access or Excel? Life is full of different options but most of the time the decision comes down to practical requirements. If you need a shot of energy to get you through the day then you’ll be better off with a big mug of coffee. Likewise if you have an important business meeting scheduled it is probably best to stick to more formal footwear.

But say that you have a volume of information that needs assimilating and analysing within a functional, logical framework. Both Excel and Access can fulfil the role superficially but there are crucial differences between a spreadsheet and a database that can radically affect the processing of data.

Microsoft Excel’s spreadsheets are non-relational, which means that the data that is formulated in them can only relate to itself. For example, a list that groups together employees with their particular salaries can be manipulated into various formats (alphabetical order, highest earning to lowest etc.) but it can only do that based on the data that is present in the list. As such its purpose is useful but limited.

Continue reading “When to Use Microsoft Access, When to Use Microsoft Excel”