Microsoft Access Database: 4 Reasons Why It Is Good For Your Business

Microsoft Access Database: 4 Reasons Why It Is Good For Your Business

Here’s an article recently published about Microsoft Access databases called 4 Reasons Why Microsoft Access Is Good For Your Business which highlights the key reasons well.

The four bullet point reasons from the article are:

  • You Probably Already Have A Copy Of It
  • It’s Fully Integrated With Other Office Apps 
  • It’s Highly Versatile & Constantly Improving
  • It’s Scalable For Future Expansion

microsoft-access-database-4-reasons-why-it-is-good-for-your-business

Also take a look at an older article of mine expanding on the benefits of MS Access making it a perfect match for SME’s and individuals.

Ready for more help? Take a look at my eBook offers and see how easy it is to build Microsoft Access Databases. 🙂

Microsoft Access News: Updating the Access Services in SharePoint Roadmap

Microsoft Access News: Updating the Access Services in SharePoint Roadmap

If you have been using Microsoft Access Services (in SharePoint), be aware of the latest news last week of this being dropped.

microsoft-access-news-updating-the-access-services-in-sharepoint-roadmap

Not to surprised! Microsoft Access is a desktop power application tool which works very well with VBA (Visual Basic for Applications).

A web version always had its limitations and it seems now perhaps there was never a large enough take up of developers when Continue reading “Microsoft Access News: Updating the Access Services in SharePoint Roadmap”

Microsoft Access Database: Using Table and Query Naming Conventions

Microsoft Access Database: Using Table and Query Naming Conventions

As part of the good working practices and disciplines when designing your Microsoft Access database, using good naming conventions will be essential as not all parts of the MS Access application is consistent.

Take a look at this quick video tutorial (about two and half minutes)…

As clearly explained, not all aspects of the MS Access application provides a way to easily see what type of object you Continue reading “Microsoft Access Database: Using Table and Query Naming Conventions”

Microsoft Access Database Working On A Mac O/S

Microsoft Access Database Working On A Mac O/S

Don’t shoot the messenger but you can use Microsoft Access database on a Mac O/S – well with some software intervention that is!

The say things happen in three! Over the holiday period and starting the new year, I had to deal with my website hosting and domain provider shutting down forcing a change of all services (hence my new look and feel website), my broadband behaving even more erratically forcing me to upgrade to a super-fast alternative and finally my Windows 7 Pro laptop collapsing having spent all of last weekend trying to rebuild it.

Well, I had a choice – update and purchase a new laptop or consider working solely with my ever faithful Mac Book Pro (Sorry, Microsoft but I’m a Mac man now!).

microsoft access database vmware on a mac

Having decided on the latter, I needed a simple and Continue reading “Microsoft Access Database Working On A Mac O/S”

Microsoft Access Databases – Using Data Analysis Tools

Microsoft Access Databases – Using Data Analysis Tools

Here’s a quick one minute video demonstration on the main Microsoft Access database tools available for your reference.

This video tutorial is based on Access 2013 but it applies to all versions (albeit maybe found in other parts of the application).

As you can see, these tools look a little tired and old style Windows which Continue reading “Microsoft Access Databases – Using Data Analysis Tools”

What Are The New Features In Microsoft Access 2016

What Are The New Features In Microsoft Access 2016

Here’s a quick less than three minute video on what’s new with Microsoft Access 2016 to quickly discover if it’s actually worth the upgrade!

As the video informs us, there seems to be little difference between the previous version (2013) and not convincing us it’s worth the effort or even an additional Continue reading “What Are The New Features In Microsoft Access 2016”

Microsoft Access Database Blog – Six Years On

Microsoft Access Database Blog – Six Years On

Wow! It’s been nearly six years of providing you with Microsoft Access database blogs and I wanted to say a big thank you to all you, the subscribers and of course those who entrusted me by purchasing one of my e-products and e-books.

If this is your first visit to my blog then welcome 🙂 Take a look at this blog site and browse the history by selecting the Archive ‘drop-down’ box by month.

microsoft-access-database-blog-site

There are over 300 posts and several ways to navigate through the archives by clicking a category, selecting a month or using the recent posts feature.

Microsoft Access Database Blog – Six Years On

Remember, to sign up for your free weekly tips and e-book. 

If you want to know more detail or like some of my e-product utilities, why not take a chance and purchase them? In fact, there’s no risk at all as I provide a full money back guarantee plus a 30-day email support to help you through the learning curve (which is not really too steep!).

Once again, a big thank you to all for visiting my Microsoft Access database blog 🙂

Microsoft Access Database: Should We Be Using Calculated Table Fields

Microsoft Access Database: Should We Be Using Calculated Table Fields

With the introduction of Microsoft Access 2010, a new data type field appeared in your table design view which provided a basic way to take fields in the same table and create new expressions as a new dedicated field sitting at the ‘top of hierarchy’ database!

However, should we really be using this new data type and practice at all?

microsoft-access-database-should-we-be-using-calculated-table-fields

Purists will frown upon this technique and say you should stick with Excel to store real values and expressions together. By doing so, you are breaking the rules of database normalisation and also cause a maintenance headache once your database has been deployed.

There are some considerations to think about that may Continue reading “Microsoft Access Database: Should We Be Using Calculated Table Fields”

Microsoft Access 2016 Database – New eBook Arriving Soon

Microsoft Access 2016 Database – New eBook Arriving Soon

Since the release of Microsoft Access 2016 late last year, everyone has been busy re-writing and documenting the changes to MS Access and in essence, there’s little difference when comparing it to the previous version (2013).

However, to help freshen up and bring any newer features into the fold, I too have been busy re-writing my current eBooks which were originally written and supported for most versions ranging as far back as version 2000 (through to 2010).

microsoft-access-2016-database-new-ebook-arriving-soon

As usual, you can expect all the key and Continue reading “Microsoft Access 2016 Database – New eBook Arriving Soon”

Microsoft Access Database Templates – Some Are Even Free!

Microsoft Access Database Templates – Some Are Even Free!

With the latest version of Microsoft Access database (2016) and following on with tradition, Microsoft provides a selection of free Access templates and these can be found via a new database file action where thumbnails are available to get you started.

Quite a few of the standard templates are reasonable and they do require more custom design time to at least make them more user friendly.

microsoft-access-2016-task-template-database

However, take the above ‘Tasks’ database example which created several different objects including tables, queries, forms and reports – In fact, 30 objects were generated which also included macros and a little VBA code.

Other database templates can also been found like Continue reading “Microsoft Access Database Templates – Some Are Even Free!”