Microsoft Access Database Tutorial: Creating a Menu Form

Microsoft Access Database Tutorial: Creating a Menu Form

In this tutorial you will learn how to create a main menu form in your Microsoft Access Database.

Take a quick look at the video tutorial below which will step you through the very basics as I’m often asked how easy is it to build your own MS Access menu forms.

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

Ignore the general look and feel of the forms demonstrated but more importantly, notice how easy it really is to create command buttons Continue reading “Microsoft Access Database Tutorial: Creating a Menu Form”

Microsoft Access Database: Creating Database Field Type Templates

Microsoft Access Database: Creating Database Field Type Templates

Microsoft Access database applications just gets richer and richer as time goes by and from version 2010, you can now create field types or in effect user defined fields stored via the ‘Save Selection as New Data Type‘ command which is located from the context sensitive fluent ribbon bar Fields tab (Table Tools).

Take a look at a demonstration of this is set up and used in the video tutorial below (less than 4 minutes).

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

Microsoft Access Database (version 2010 onwards) has a new feature which allows you to preserve existing columns that you can use Continue reading “Microsoft Access Database: Creating Database Field Type Templates”

Microsoft Access Database Tutorial VBA Code Task Tool To Outlook

Microsoft Access Database Tutorial VBA Code Task Tool To Outlook

It’s very strange how Microsoft Access database systems and processes constantly repeat themselves and once again I’m working on some VBA code to communicate with Microsoft Outlook (Email and contact management system).

Here you can see a quick video of such a simple but effective utility I offer (for only the cost of a couple of pints of beer!) – check it out…

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

Microsoft Access Database Tutorial VBA Code Task Tool To Outlook

The Task Tool utility was built to demonstrate the ease of use and how MS Access VBA code can communicate with Continue reading “Microsoft Access Database Tutorial VBA Code Task Tool To Outlook”

Microsoft Access Database – My Very Own Custom Built Utilities

Microsoft Access Database – My Very Own Custom Built Utilities

This time of year and over the last few weeks, we get new users or students entering the Microsoft Access database arena from people of various walks of life whether that is a student learning about IT and computer based systems or starting a new job or career wanting to brush up on their skills that I like to remind all of my custom built utilities which serves more than one objective.

microsoft access database custom built utilities

The tools I offer are not free but they do come with a money back guarantee and 30 day email support so you can at least try and ask questions. The main point to Continue reading “Microsoft Access Database – My Very Own Custom Built Utilities”

Microsoft Access Database: Working With A Database You Didn't Create

Microsoft Access Database: Working With A Database You Didn’t Create

Working with Microsoft Access database is a skill to have and makes you stand out from the crowd of advanced Excel spreadsheet users and those wishing to step up and move into the world of MS Access will probably start by inheriting other people’s databases.

So what’s the first thing you need to do if you are given someone else’s Access database?

microsoft access database working with a database you didnt create

I wrote another post about a couple of years ago which addressed the challenges of inheriting other people’s Microsoft Access databases and Continue reading “Microsoft Access Database: Working With A Database You Didn't Create”

Microsoft Access Database: 5 Settings To Avoid With Microsoft Access Options Causing You Headaches

Microsoft Access Database: 5 Settings To Avoid With Microsoft Access Options Causing You Headaches

Here’s an article I wrote some time ago but is worth a revisit since the newer generation of users tend not to be always aware of the background tasks Access sometimes insists on performing…

When I first started to use Microsoft Access (back in 1993) which was then version 1.1 and quickly moved to the newer version of 2.0, you had various options available that could be set to change the behaviour of how you viewed and ran the basic objects. It probably took you no more than 15 minutes to discover, read (in the help files) and apply all settings that Microsoft Access databases had to offer – job done, never having to return to this area again!

Microsoft Access Database: 5 Settings To Avoid With Microsoft Access Options Causing You Headaches

Move forward 20 plus years and working with Access version 2013 you now have to either employ an individual to study and constantly refine the permutations of how Microsoft Access will work, behave and look. Okay, I may have exaggerated a little about employing and individual but your get the point! You need to Continue reading “Microsoft Access Database: 5 Settings To Avoid With Microsoft Access Options Causing You Headaches”

Microsoft Access Database Names and Reserved Word Problems

Microsoft Access Database Names and Reserved Word Problems

Designing your Microsoft Access database requires a plan, some dedicated time and vision, and without some scope for your new database, you can easily fall at the first hurdle when building and implementing a system with the lack of attention to detail of using key names and reserved words.

Some of the reserved names and words can be used depending where it’s being utilised but some will prompt you with a warning as being ambiguous because they are properties of forms, reports, sections, tables, or global names and constants from the Application object and the DAO, ADODB and VBA libraries.microsoft access database reserved names and words

Because it would not be practical to provide a full list of all reserved names and words, like built-in function names, VBA constant keywords or Continue reading “Microsoft Access Database Names and Reserved Word Problems”

How To Run Microsoft Access On A Mac PC Using CrossOver Software

How To Run Microsoft Access On A Mac PC Using CrossOver Software

You might find this a little strange but I generally prefer Mac to Windows as not all my work is purely Microsoft Access. However, working on Access requires a Windows instance and though I have several computers set up, my Mac Pro also has Access installed using CrossOver Software Installer.

Here’s a quick two minute video tutorial on How To Run Microsoft Access On A Mac which I found to explain the installation process…

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

This is just one way to get Continue reading “How To Run Microsoft Access On A Mac PC Using CrossOver Software”

How To Add A Flash Movie SWF File To A Microsoft Access Form

How To Add A Flash Movie SWF File To A Microsoft Access Form

Working with Microsoft Access form designs requires patience and a plan especially when wanting to work with other form controls over and above the standard tools made available by default.

One particular ActiveX control is the ‘Shockwave Flash Object‘ which will allow you to play flash video (or SWF file formats) in an Access form.

Adding A Flash Movie To A Microsoft Access Form

You will need to first load the library file if not added or enabled in order to render this control ready for use. That means Continue reading “How To Add A Flash Movie SWF File To A Microsoft Access Form”

Converting Microsoft Access Databases Between Versions (ACCDB/MDB)

Converting Microsoft Access Databases Between Versions (ACCDB/MDB)

With the release of Access 2007, a newer file format (ACCDB) was introduced and suddenly users and developers were confronted with a mix of versions and formats to contend.

Therefore, converting Microsoft Access databases between versions required some careful and additional planning for your database. 

Here’s a five minute video tutorial which demonstrates using Access 2013 where and how to convert between the two common file formats.

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

Converting Microsoft Access Databases Between Versions (ACCDB/MDB)

From the tutorial, it clearly highlighted the ease of use and users can convert an Access database with the additional ability to just copy individual objects as a quick copy and paste alternative. 

However, there are some additional points to highlight here that will Continue reading “Converting Microsoft Access Databases Between Versions (ACCDB/MDB)”