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

Accountants Should Dump Microsoft Excel for Microsoft Access Database

Accountants Should Dump Microsoft Excel for Microsoft Access Database

I’ve been saying this for years, Microsoft Access databases is simply far better than Excel. In fact Access is just Excel on steroids!

As the following link to this article says “we are all Excel-aholics who can’t get through the day without busting out a spreadsheet…“. 

Here’s the article link: http://goingconcern.com/post/accountants-should-dump-microsoft-excel-database-software

Accountants Should Dump Microsoft Excel for Microsoft Access Database

Accountants Should Dump Microsoft Excel for Microsoft Access Database

The default reaction is to lean towards Excel and that’s understandable but that’s because it’s how we are all first taught to use this application and the ease of how a spreadsheet  can be to manipulate data and analyse out.

But where data integrity and security protection  is key to the maintenance and workflows of a system, you simple have to consider Microsoft Access databases.

There’s also a compromise where both could be used and this maybe a fair outcome to get the best of both using their strengths and dismissing the weaknesses at the same time.

Want to learn more? Take a look at my eBook bundle covering the key objects of Microsoft Access database.

Microsoft Access Database: What is… Some Popular Questions

Microsoft Access Database: What is… Some Popular Questions

Here are some questions I’ve been asked over the years regarding Microsoft Access databases which I thought you may want to review. 

Q: What features make Microsoft Access a valuable tool over say the more popular Excel spreadsheet or any other desktop software?

A: The key feature is the ability to “ask questions” and perform actions with large amounts of the data via Queries which is its real strength.  For the common MS Office user who doesn’t know anything about MS Access databases, this application can seem fairly user-friendly and most users tend to lean to a more comfortable environment, namely Excel.

microsoft-access-database-what-is-some-popular-questions

Q: What’s the best way to start learning Microsoft Access?

A: It all depends on how you best absorb information and learn new technologies. Some people prefer a book but that can be quite time consuming and hard to follow as most books tend to be Continue reading “Microsoft Access Database: What is… Some Popular Questions”