MS Access Database Images: How To Correctly Handle Them ?

Microsoft access database was never really designed to handle images the same way other Office applications do and maybe it was deemed as bit of an afterthought.

Different versions lead to different challenges and the latest version (2016) still have issues ending sometimes up with invisible images on those forms and reports. This is further complicated by having a 32-bit version of Access 2016 (16.0.4229.1024) and perhaps not the 64-bit version installed but that may not be a good enough reason to use the 64-bit version at all (unless of course images are your thing!).

In Access, images should appear properly but some simply do not. The original Images used this application was the BMP file format and they continue to properly show up however, other graphic types such as GIF, JPG and PNG formats may end up as a blank non-starter!

One thing you could check out is the database’s Picture Property Storage Format when the picture was added to the form or report. This can be found under the ‘Access Options’ setting for the Current Database:https://www.accessdatabasetutorial.com/

There two options are:

  • Preserve source image format (smaller file size)
  • Convert all picture data to bitmaps (compatible with Access 2003 and earlier)

If the image is added when the above option is set to the second option (Convert), the non-BMP graphics do not appear in the 2016 version. Continue reading “MS Access Database Images: How To Correctly Handle Them ?”

Building Access Forms – Thе Design Concept

create_a_form_in_Microsoft_access access database tutorialUѕіng MS Access forms tо display records іn а fаr easier layout аnd format wіll give user’s thе confidence аnd thе protection of controlling data processing tasks.

MS Access forms аllоwѕ thе uѕе оf data tо bе presented, managed аnd controlled іn а user-friendly environment making Access mоrе intuitive tо use.

Designing forms іѕ critical fоr оthеr users whо wіll bе responsible fоr thе day-to-day running оf а database аnd hаvе vеrу lіttlе knowledge оf thе structure оf аn Access database оr іtѕ background processes. Continue reading “Building Access Forms – Thе Design Concept”

What’s New with Microsoft Access 2010 Macros

The new macro interface tool is a welcome feature and well overdue! fitting nicely with the rest of Microsoft Access 2010 namely the Ribbon Bar & easy to use templates.

The simple drag n drop actions and in line arguments makes this a far more intuitive system to use which is easily managed by expandable and collapsible sections.

This version now has more keywords and arguments and is a strong case to stick with macros and using Microsoft Access vba (Visual Basic for Applications) as a ‘plan B‘ option for the more advanced user and any procedure that no macro is designed to do.

How to Utilise and Apply Access Database Normalisation Techniques?

Access Database Normalisation levels 1, 2, 3; getting normal about it!

The process of Database Normalisation was developed by E.F.Codd who is widely considered the father of relational database theory.

There are several rules which provide theoretical structures and disciplines which are not always practical to follow but help provide the main goals which are:

  1. Eliminate redundant information
  2. Increase data integrity
  3. Make systems more efficient

Modern databases should be in BCNF Boyce-Codd Normal Form which is deemed to be at third normal form of which there are considered to be five in all. This article focuses on what I believe is considered a good balance to applying some of these rules and covers up to the third norm of database normalisation.

Continue reading “How to Utilise and Apply Access Database Normalisation Techniques?”

Why it is Essential to Regularly Compact and Repair Microsoft Access Databases?

Building Your First Database with Microsoft Access 3One of the most powerful features of Microsoft Access database is that it allows databases to consistently increase in size. This way you do not have to worry about size limitations while developing the databases or while working on them. On the other hand, this means that even if you delete a record or even entire tables, Access simply indicates that the space may be made use of, for new records without actually giving up the space. Similarly, even if any extra space is created when you shorten or possibly modify records, that space is not released. This will not only cause enormous amount of defragmentation of the database, but more importantly it will eventually lead to corruption in the MDB files. The only way to restore data from the damaged files may then be to resort to high level MDB recovery.

The best way to make use of the extra space and the space created by deletions is to regularly compact the Access database. On the other hand, not compacting the Access database at all will mean that the extra space is being wasted and the database will continue to demand more space as more records are added.

Continue reading “Why it is Essential to Regularly Compact and Repair Microsoft Access Databases?”

Microsoft Access IIF Function in a Query

This video tutorial is clear and simple to follow and explains the IIF function well (in it’s simplest form).

Users who are normally familiar with Microsoft Excel’s IIF function will be able to relate to this function as it is the same!

The only aspect you will need to know of course is how to create a calculation in a query which is demonstrated quickly in this video but if want to know more about how to calculate in a ms access query and use some of the other tools namely, the Expression Builder.

Brief history of Microsoft Access

Here’s a brief history of Microsoft Access just in case you wish to step back and reminisce

A brief history of Microsoft Access

Late 1992, Microsoft released the first version of Access (version 1.0) desktop database application for the Windows operating system and was shortly replaced with version 1.1 in mid 1993 to incorporate better compatibility with other Microsoft Office products of that time and more importantly introduce the ability for programmers to code this application using Access BASIC.

Version 1.1 was buggy! and had performance issues and in the same year Microsoft released Windows 3.1 operating system along with Microsoft Office 4.3 Pro (suite of applications including Excel, Word, PowerPoint with Access – version 2.0) as it required the improved hardware, software memory and the power supported by Windows 3.1.

This was an ideal desktop database application tailored to the small to medium sized business that required a low cost database. At that time, the capacity of a disk hardrive was less than 100 MB (mega bytes) and typical document file sizes were in the 100’s of bytes. Continue reading “Brief history of Microsoft Access”

Microsoft Access Databases – Learning the Fundamentals

access-application-programmerThe Access database application provides a rich set of powerful tools ranging from a simple database design model to the multi-user network version using Access’s administrative tools at all levels which include the Relationship Window, Database Splitter, Linked Manager Tool and Access Security module to name but a few.

If you have wondered where you start to learn access database then the quickest and simplest way, then welcome as I will step you through and guide you to learn access database the easy way!

Access beginners sometimes find this application overwhelming as there are a lot of objects and components to an Access Database. I am going to start by de-mystifying some of these objects and introduce you to Access Terminology first and foremost.

Getting to grips with some of the Access terminology will serve as a useful glossary for learning access database and mastering this application and any supporting resources you may use.

Continue reading “Microsoft Access Databases – Learning the Fundamentals”

Access 2007 – The Navigation Pane Window View

This video tutorial is a good overview for those new to the Access 2007 screen and how objects are managed into groups and other filter views. It is a vast improvement from the previous database window (of earlier versions).

The Navigation Pane Window view contains all the Access objects stored as it is in one file. You can create, edit, open, delete, duplicate, search and maintain natural groups.

I like the quick ‘right’ mouse click on the ‘Navigation Pane‘ banner to set properties including showing and hiding system objects.

Here’s one of my shortcut tips; press the F11 function key from the keyboard to toggle the hide/show the Navigation Pane Window view instead of clicking the >> << chevron icons on the banner.

Planning an Access Database – Video

Learn access database,This video from YouTube takes you from the very beginning even before working with the actual database application which is often overlooked when designing and planning an Access database.

It’s a good guide to help relate how you actually would use and benefit from any database in the ‘real world’ making this a very human and user friendlier approach and best of all it’s ‘geek’ speak and jargon free!