Sharepoint 2010 and Access 2010 Tutorial

A very quick overview of how to share an Access database (2010) over the internet using SharePoint 2010 services, the new way to publish Access database files on the web.

It really is that simple as the steps shown in this video tutorial and you will soon learn the do’s and don’ts when the system always analyses the objects from your Access database file.

Make sure you do some more research first and know what your options are before you just start sending objects for publishing onto the internet.

Click on this link to find out more about Access database on the web

Practice Microsoft Access Database Decorum to Reap the Rewards

Before you enthusiastically enter all your information into a Microsoft Access database it is wise to apply some organisation to the process.

As you open the application you will see that the programme can hold vast amounts of data that can boost the efficiency of your business. The software is commonly found in offices and businesses which are seeking to keep on top of paperwork and many other tasks that require analysis and storing of data. Unlike MS Excel, you have great freedom with MS Access as there is much more that you can do with the program.

For instance, it allows you to create databases that can be linked to each other, which are more complex than Excel spreadsheets. Within these databases are different ‘objects’ that you can utilise if you wish. The types of objects you choose to apply often depend on your knowledge of the program, meaning you are free to avoid using them until you feel ready and have attended training courses if necessary.

Continue reading “Practice Microsoft Access Database Decorum to Reap the Rewards”

Access 2007 Reports Tutorial

It always amazes me when users and developers design an Access database they pay a lot of attention to the designing and planning of the database structures – and of course this is very important.

The next step is usually building the objects starting with the Tables then Queries followed by the Forms and finally the Reports.

By the time they are onto the Reports, it seems a bit of an after thought and the designs are very basic because of the the time consuming element reports can take. It is important to spend time in the design view of an Access report which is as I say is overlooked a lot of the time.

This video tutorial is a good introduction as it covers the report wizard tool which everyone starts with (and a lot of the time that’s it!) followed by the switching between the different views showing you how to add groups, calculate and change the various key properties for a report. It even explains the footer calculation for pages and concatenation (look the word up!).

At the end of the day, if you are going to present the results to your customers or executives, you need good looking Access database reports and the report wizard tool will simply not do!

Learn About the Benefits of a Split Access Database

Microsoft Access database is a wonderfully simple application and can scale easily from just a few users for a small business to many users for a large organization. One can enhance the flexibility and scalability of Microsoft Access by splitting the database so that it performs better and provides better security to data.

What makes an Access database so easy to handle and use is the fact that it uses just one MDB file to store both the data and the interface objects. However, this could also lead to some problems, particularly if you are planning on having a shared database. When you are sharing the MDB file containing both data and interface objects with multiple users, there is a greater chance of the file getting corrupted. This means that even if all the users are typically using the interface objects, there could be damage to the data and in some cases, this could result in loss of data. Instead of having to constantly repair MDB files that have become damaged due to these reasons, it is much better to work with a split database. Most experts will tell you that not only is a split Access database with two MDB files much easier to protect, but performs faster and is also easier to maintain.

Continue reading “Learn About the Benefits of a Split Access Database”

Publish an Access 2007/Access 2010 database to the web

This is what Microsoft should have done some versions back and have an Access database  easily uploaded to the web – a big CHEER please!!!

You do need to have web services in place and Microsoft SharePoint is the obvious choice here. Ryan (the author of this video) makes it look easy – and it is.

Remember, the web version and its functionality will never be as rich as the LAN version (client interface) and therefore you still need to design a good Access database system as its back-end.

Thanks Ryan for the heads up 🙂

Microsoft Access 2007 Database Tutorial – Trust Center Locations

This quick two and half minute video tutorial won’t win any Emmy awards for best production and script but it puts the point across clearly when users see the unwanted ‘security’ banner warning in Access 2007 (and Access 2010) and how to avoid this banner for future use.

The author doesn’t like this feature of Access and I can understand why but Microsoft felt it was needed to add extra protection as a warning for unknown database files being opened ‘ad-hoc’.

Personally, it’s easy to stop the banner showing and therefore can be ignored once it has been dealt with. The challenge for users is how you control the settings and you will need to navigate through various screens to accomplish this which is why I’ve put the video on my blog rather than writing an article on the matter.

Ready to consider upgrading to Access 2010 or Access 2007?

“Ready to consider upgrading to Microsoft Access 2010 or Microsoft Access 2007?…It may well be worth it!…”

If you have been using Microsoft Access 2007 for a while now, moving to Access 2010 will be seamless and all you need to do is understand what new features have been introduced and what it has also replaced (where applicable).

However, a lot more users haven’t yet upgraded to Microsoft Access 2007 and are still using Access 2003 (or even an earlier version). So I’ve decided to include and combine the latest two versions and their new features to help with the transition and migration.

I will clearly point out where a feature is exclusive to either version so that you have the heads up and understanding of what you will expect to see and more importantly how to access the feature due to new GUI (graphical user interface).

Continue reading “Ready to consider upgrading to Access 2010 or Access 2007?”

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 use 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?

One of the most powerful features of Microsoft Access 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.

Fortunately, Microsoft Access provides a powerful Compact and Repair tool that can be used to make use of the space available and to prevent excess defragmentation of the database. This tool works in two phases – in the first, it compacts the database so as to get rid of all the extra space and in the second, it repairs the MDB file if the fragmentation had caused any damage to it. The tool also helps in reducing the physical size of the database thereby making it more manageable for Access and also reducing the risk of requiring an extensive MDB recovery process. In fact, compacting an Access database is the only way that you can actually reduce the size of the database.

The frequency with which you should run the Compact and Repair tool depends a great deal on how often you use your Access database and more importantly on how frequently you add, modify or delete records from the database. If you are a regular user, then it is important that you run the tool often to reduce the risk of corruption in the MDB files. If you do not compact your database regularly, chances are that the MDB file may become corrupted at some point in time. You can then use the Repair utility to actually repair the corrupted MDB file. However, you should bear in mind that this Repair utility can only restore corrupted data objects such as records, tables and indexes.

If after running both the Compact and Repair tools, your database still appears damaged, there is no need to panic. It should still be possible for you to restore almost all your data but you will need to use more specialized, third-party tools such as Advanced Access Repair from DataNumen to carry out an MDB recovery. While these tools are very powerful and have the ability to restore data from seriously corrupt MDB files, they are also very efficient and easy to use.

The official website of Advanced Access Repair is

Article Source:

This article explains why and what the ‘Compact and Repair’ feature is when using Microsoft Access databases (version 2003 or earlier) though it also applies to later versions (Access 2007 and 2010 uing the newer file extension .ACCDB).

The author is spot on regarding why you use it and how it basically works which is very clear. I like to refer to ‘Compacting’ the database which reduces the file size issue (as a fragmented file) by ‘squeezing the air out in between‘ bringing the file into a normal manageable size.

The added point to mention here is the ‘Repair’ element which also releases the locking file (.LDB file) when used in a multi-user environment and therefore adminstrators should ensure they are the only user using the database (as exclusive mode) before running this utility.