Welcome to Microsoft Access Database Tutorial

Saturday, Aug 27, 2016

Welcome to the Access Database Tutorial website that will show you how to use Microsoft Access Database by learning and managing this powerful application using the most effective techniques and tools available for visitors with very little or no knowledge to get you up and running without the need to learn all the ‘geek’ speak keeping it Jargon free that most trainers and consultants like to impress you with!

If you are new to Access or wish to know what is MS Access, please take a look at

An Introduction To Microsoft Access

Also, this website contains a blog, products on offer and free general tips to help users find out all about  latest news and articles I feel worth mentioning along with my recommendations of videos and books.

Microsoft-Access-2016-eBook-CoverAccess 2016 eBook  

 

As a Thank You for Visiting…

Claim Your Free eBook NOW!

Enjoy and thank you for visiting!

Posted in MS Access | Tagged , , | Comments Off on Welcome to Microsoft Access Database Tutorial

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

Posted in Database Theory, Microsoft Training, Tables | Tagged , , , , | Leave a comment

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

Posted in Database Theory, Microsoft Training, MS Access | Tagged , , , , | Leave a comment

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

Posted in Database Theory, Microsoft Training, MS Access, Utilities | Tagged , , , , | Leave a comment

Microsoft Access Database 2016: Printing Reports

Microsoft Access Database 2016: Printing Reports

A report is only as good as the data stored and retrieved (typically via a query) in your Microsoft Access database but this simple video tutorial (less than 3 minutes) demonstrates what the feature you can run from your report print preview…

 

While you can print reports using commands via the Backstage view, you can also use Print Preview. Print Preview shows you how your report will appear on the printed page. It also allows you to modify the way your report is displayed, print it, and even save it as a different file type like the popular PDF format . Continue reading

Posted in Database Theory, Reports, Utilities | Tagged , , , , | Leave a comment

Access Database Forms: Should We Use Unbound Forms?

Access Database Forms: Should We Use Unbound Forms?

I’ve always been a big fan of Microsoft Access databases, why? Because I like the way a rich application like this can be customised and designed from the floor up with little IT programming and development knowledge. Plus, I like building things :)

As a recap, knowing the difference between what an unbound versus a bound Access form is will help divide the distinction and allow you to determine which approach will suit best.

access-database-forms-should-we-use-unbound-forms

MS Access like any other development IDE will provide an endless set of properties across the ‘one-stop shop’ set of objects and forms are no different. One property we are talking about of course is Continue reading

Posted in Database Theory, Dialog Boxes, Forms, MS Access | Tagged , , , , | Leave a comment

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

Posted in Database Theory, MS Access, Utilities | Tagged , , , , | Leave a comment

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.

Posted in Database Theory, Microsoft Training, MS Access | Tagged , , , , | Leave a comment

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

Posted in Database Theory, Microsoft Training, MS Access | Tagged , , , , | Leave a comment

How to Create an Autokeys Closing Macro in Microsoft Access

How to Create an Autokeys Closing Macro in Microsoft Access

As a follow on from my last post about Microsoft Access Macros, here’s a good working example clearly explained using the ‘unsafe’ CloseWindow command…

It walked you through creating a custom hotkey for Microsoft Access (using version 2010 though it will also apply through to the current version, 2016) which used the ‘Autokeys’ macro.

This macro shows you how to avoid a problem during a design and run-time for a form where incorrectly closing this object can save filters and sorts into their properties and alter their behaviour when re-visiting the form.
Continue reading

Posted in Forms, Macros, MS Access | Tagged , , , , | Leave a comment

Microsoft Access 2016 Macros: Show All Macro Commands

Microsoft Access 2016 Macros: Show All Macro Commands

The great debate of whether to use Microsoft Access macros or the higher level of VBA code will linger on until the end of time (or realistically, Access is discontinued)!

In the meantime, most Access developers will continue to lean towards Access VBA but the majority of power users, self-taught Access designers will still embrace the ease of g using macros to automate their databases.

Microsoft Access 2016 Macros Show All Macro Commands

With the later versions of MS Access (post 2010), macros have become more powerful and flexible and with the added introduction of better web integration and the fact VBA Continue reading

Posted in Macros, MS Access, Utilities | Tagged , , , , | Leave a comment