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”

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”

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”

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 Database File Format: What is an ACCDR File?

Microsoft Access Database File Format: What is an ACCDR File?

You may have come across the ACCDR extension file format option for a Microsoft Access database instead of the standard and more commonly used file extension ACCDB. So what is this file extension format?

Simply put, the letter ‘R‘ could best be denoted as the ‘run-time’ mode of your MS Access application which will lock the database as a ‘read-only’ instance from the design and general application.

microsoft-access-database-file-format-what-is-an-accdr-file

The method is very straight forward! Just simply rename the file extension (once the database file is closed) to ‘.ACCDR’ via the O/S Windows Explorer. Make sure you can see the file extension view (search the web on how to switch this view on).

To open the newly renamed file extension will need to be carried out from either Windows Explorer view or an icon shortcut and not via the Microsoft Access database application’s ‘Open‘ command.

When you do this, you will note the interface will Continue reading “Microsoft Access Database File Format: What is an ACCDR File?”

Microsoft Access Database: Pass Through Queries

Microsoft Access Database:  Pass Through Queries

There are many Microsoft Access queries to choose from that will manage your database reporting requirements but there are a handful of lesser known types of queries that you may not be aware of.

One in particular is a query called ‘Pass Through Query‘ as the following short video tutorial quickly explains…

Putting aside for the heavy American accent, it clearly explains the use for this type of query and the power behind how Continue reading “Microsoft Access Database: Pass Through Queries”

Microsoft Access Database: Next Generation of Spreadsheets

Microsoft Access Database: Next Generation of Spreadsheets

Bringing your Microsoft Access database application into the current online digital age started with the need for this integral tool for small and medium sized businesses way back in the 1990’s.

WordPerfect, Lotus 1–2–3, and dBase are the three software products that dominated the software market for a long period in the history of personal computing. WordPerfect is used for word processing; Lotus 1–2–3 is a spreadsheet program from Lotus Software; and dBase is a database management system for microcomputers.

During the early days of personal computing, spreadsheets and databases coexisted because there was a clear designation of responsibility between the two models.  During those times, the use of spreadsheets were mainly for financial modelling. While databases were intended for everything organization-related.

Spreadsheets and word processors offered the benefits of simplicity and direct manipulability. Databases were never as manageable as word processors and spreadsheets. The main drawback in using databases was in the technical implementation complexity of the software.

Microsoft Access Database Next Generation of Spreadsheets

As a result, average users began using spreadsheets as provisional databases.
After many consultations with dozens of Excel clients, it became clear that almost all of them were using the product not for the purpose of financial modelling but as a conventional tool for making tables instead.

At this point in time, the office productivity perspective had also shifted from a multiplayer market to one subjugated by Microsoft, which put down Lotus 1–2–3 and dBase with its own Excel and Access database products. The growing grey area between spreadsheets and databases gave Continue reading “Microsoft Access Database: Next Generation of Spreadsheets”

Microsoft Access Database Tutorial: Creating a Menu Form

Microsoft Access Database Tutorial: Creating a Menu Form

In this tutorial you will learn how to create a main menu form in your Microsoft Access Database.

Take a quick look at the video tutorial below which will step you through the very basics as I’m often asked how easy is it to build your own MS Access menu forms.

Ignore the general look and feel of the forms demonstrated but more importantly, notice how easy it really is to create command buttons Continue reading “Microsoft Access Database Tutorial: Creating a Menu Form”