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 2016 Will Soon Support Large Number (BigInt) Data Type

Microsoft Access 2016 Will Soon Support Large Number (BigInt) Data Type

Coming soon… Microsoft Access 2016 will gain a new data type called ‘Large Number‘ which will be an extension to the Number at a type or more commonly referred as BigInt (Big Integer).

Large Number (or BigInt) is a new supported data type that will help developers and users with added analytical capability. This extended support means that Access can finally read and write data to and from external data sources which make also makes use of BigInt.

This has been a limitation when importing data into an Access database from larger more robust database applications and this feature will be able to switched on or off (I guess to help keep the application optimised and not slow down too much).

As announced, “When creating new local tables or editing existing ones, Access now allows users to add fields that store BigInt numbers.” The upgrade, which adds a ‘Large Number‘ option to the ‘Click to Add’ menu when adding a new field to local tables, opens up new possibilities, allowing users to work with SQL data and other external data sources that use BigInt.

microsoft-access-2016-will-soon-support-large-number-bigint-data-type

If not already available (as installed), as an Office 365 subscriber you will need to run an update to get the new data type. Other variants of Microsoft Access 2016 will shortly also see this feature be available to download and install.

Watch out for  more information on how this new data type will be practically used in Access and more details will soon be available and reveal the scope of this new field type.

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”

Welcome To My Rebuilt Microsoft Access Database Website

Welcome To My Rebuilt and New Look and Feel Microsoft Access Database Website

A new year and a new look and feel website for you 🙂

So, if you haven’t visited us before, we are Access database tutorial – a blog website all about Microsoft Access database.

microsoft-access-database-eproducts

Take a look, browse our blog articles since 2010 and consider some of our unique and exclusive offers and ebooks.

Very easy to follow eBooks and prebuilt eProduct tools to plug into your own Access database with 30 day email support and a money back guarantee (if not satisfied).

Microsoft Access: Office 365 Business Subscription Plans To Be included

Microsoft Access: Office 365 Business Subscription Plans To Be included

Microsoft plans to add Microsoft Access database to its Office 365 Business and Office 365 Business Premium subscription plans.

The above plans currently do not provide this all powerful Access application but from the 1st of December until the end of January 2017 will get this automatically updated to their accounts.

microsoft-access-office-365-business-subscription-plans-to-be-included

Microsoft Access: Office 365 Business Subscription Plans To Be included

Be aware, if an organisation subscribing to either of those two plans has elected to get Office 365 updates via the “deferred channel” update process, then Microsoft Access will start to arrive in June 2017. The Office 365 updates so-called “channels,” arrive every four months are called the “deferred channel.” Therefore, “first release for deferred channel” update release arrives every four months and is designed for testing purposes. Continue reading “Microsoft Access: Office 365 Business Subscription Plans To Be included”

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 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”