Microsoft Access Database: Becoming an Expert MS Access Database Programmer

The following article covers some good points on how you would go about learning and understand programming with VBA in Microsoft Access.

It also shows you how by using the well known search tool (web) and other useful resources and vendors available including the author himself you can start to break  through the ice on this otherwise complex subject.

I have also added my own Continue reading “Microsoft Access Database: Becoming an Expert MS Access Database Programmer”

Microsoft Access Database Templates – Why Should I Use Them?

I found this article which talks about Microsoft Access database templates and how easy there are to use when creating an Access database.

There are many different types of templates available of which many are free to download from official Microsoft websites covering many processes but at the end of the day, you will need to change and tweak any standardised template database file.

The main elements are discussed in this article but it’s not clear as to the ‘call to action’ and what you really need to do next. Continue reading “Microsoft Access Database Templates – Why Should I Use Them?”

Microsoft Access Database: Creating a Validation Rule in an Access Table

Take a look at this quick and clear explanation of how to set Validation Rules in Microsoft Access via a table.

The validation rules use the same logical expressions that can be found typically in criteria of a query and must return a logical value of either TRUE or FALSE in order to accept or reject the value and trigger an exception (validation text property). This simple property is easier to apply than attaching a macro or VBA code to an event which means learning VBA programming!

Additionally, you can set validation rules in a form too but remember this will only be available in the one form compared to a table which other forms inherit making it more globally available.

Finally, don’t confuse validation rules for field in a table which this video tutorial is about to validation rules for a record which is also available in a table.

I would love to hear from you by commenting below on how you use validation rules perhaps sharing some examples for other members to see and understand.

Microsoft Access Database: Top 5 Tips To Get You Started and Control an Access Database

Check out one my recent articles that I published in getting users to control the Microsoft Access database application environment that can help manage objects and speed up end-user tasks.

I call it my top 5 tips but to be honest there are many tips ‘n’ tricks available and you may not agree with me. Use this article Continue reading “Microsoft Access Database: Top 5 Tips To Get You Started and Control an Access Database”

Microsoft Access Database: Encrypting your Database File

From time to time, you may want to encrypt and set a password for your Microsoft Access database application. This is used to protect and secure access to your database file preventing unauthorised users prying into your database.

Access Database File Formats

First of all let’s clear things up regarding database file formats. As you may be aware that we have two file formats in Microsoft Access; MDB and ACCDB.

Encrypting with a password only applies to ACCDB file formats which are available to only Access 2007 and 2010. MDB files Continue reading “Microsoft Access Database: Encrypting your Database File”

Microsoft Access: Export Data From Access To Excel, PDF or Text File

Microsoft Access 2010 is brilliant when it comes to exporting data to other applications offering many file formats…

Exporting data from Microsoft Access 2010 & 2007 is even easier than previous versions as it firstly provides an easy to view Ribbon Bar (External Data tab) displaying clear icons for different file formats and secondly being able to save your export actions for re-use.

I personally like the ability to now export to a PDF file which is also mentioned in this video tutorial as well as easily setup a connection to SharePoint services for publishing over either a network or the internet.

Emailing (as attachments) is a breeze too with a single click of a button locating your default email editor. If your have to export data to an unusual file or system, you can always investigate the ODBC Database option (found  under the More drop-down icon).

Finally, this video tutorial clearly highlights working the relationship between Microsoft Access and Microsoft Excel (which the majority will have available) taking advantage of the rich set of tools Excel provides.

I welcome your comments below – perhaps you may know of a shortcut to export data in Microsoft Access!

Hidden Tables in Your Microsoft Access Database

Any sophisticated piece of software like Microsoft Access will have many hidden and internal files which are archived to maintain the application’s environment and user customisations. In Access, we are talking about System Objects; in particular the MSysObjects Table which is a hidden table that can be used to extract information about your Access database.

Microsoft Access System Objects consist of several tables that gives you important and useful information about your database application. In this post, I’m going to focus on  Continue reading “Hidden Tables in Your Microsoft Access Database”

Microsoft Access Functions

There are over a 100 commonly available functions that can be utilised in an Access database application. I have no intention of listing them all here but the following category of functions may give you the appetite and confidence to explore other functions available.

? Arrays ? General
? Conversions ? Inspection
? Database ? Math
? Date/Time ? Messages
? Domain Aggregate ? Program Flow
? Error Handling ? SQL Aggregate
? Financial ? Text

The above categories Continue reading “Microsoft Access Functions”

MS Access 2007 – Action! Create a MAKE TABLE QUERY

MS Access (2007) Make-Table Action Query

Check out this quick and useful video tutorial on one of the Action queries known as the MAKE-TABLE query.

A quick video tutorial on how one the 4 Action queries; Make Table Query works and is quite safe to use as it create a copy leaving your data in the original place.

It’s a useful little query which fits within the ‘database maintenance’ activities of your Microsoft Access application as it can be used to create backups, merge data together and prepare data for either exporting or archiving elsewhere.

To learn more about queries and other more advanced concepts, you may want to review one of my eBook offers on Database queries here.