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 “Microsoft Access Database 2016: Printing Reports”

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 “Access Database Forms: Should We Use Unbound Forms?”

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

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”

Microsoft Access 2016 Runtime Now Available For Download

Microsoft Access 2016 Runtime Now Available For Download

If you are going to distribute your Microsoft Access 2016 database to other users who do not have a licenced copy of Access 2016, you can give them a free run-time version.

Click here: Download Microsoft Access 2016 Runtime

Note: Please make sure you have checked out the licence agreement and understood the terms before deploying the above run-times. Search on Microsoft’s website for further information.microsoft-access-2016-runtime-now-available-for-download

There are two versions of the currient Access 2016 application. Make sure you have idenrtified which operating system you have installed (including the correct Windows o/s too) as you can choose between the 32 bit and 64 bit versions.

All versions can only run from Windows 7 or higher and that may need some updates added first.

Microsoft Access 2016 Runtime Now Available For Download

Microsoft Access 2016 provides a rich platform for developing database management solutions with easy-to-use customisation tools. If no end user customisation is required (including report modifications), you can choose to distribute those Access 2016 solutions so that they run without requiring a full installation of Access 2016. To do so, you must package and distribute your application with Access 2016 Runtime.

Make sure you also check out our other Access free stuff.

Microsoft Access 2016 Database Specifications

Microsoft Access 2016 Database Specifications

Welcome to a brand new year – 2016 which continues with regular blog posts – all about Microsoft Access databases.

So, with the recent release of Microsoft Access 2016, we now have parity and I thought as a recap (as with earlier versions of the past), we may as well start with Access 2016 specifications and get to know your limits (if any)!

This information about the limits of Microsoft Access database files and objects can be found from the official Microsoft support website.

microsoft access 2016 database specifications

Any database can exceed they limits which can cause performance issues and become corrupt overtime which is why Continue reading “Microsoft Access 2016 Database Specifications”

Microsoft Office 2016 (Preview): First Look

Microsoft Office 2016 (Preview): First Look

This quick video tutorial doesn’t mention Microsoft Access 2016 but the general newer look and feel and functionality will follow suite and not much seems may have changed.

So in this video, the narrator must have recorded the audio on double speed or his just very enthusiastic and wants to cram in as much as possible in less than four minutes!

Microsoft Office 2016 (Preview): First Look

So what about Access 2016? There’s very little on the net to confirm what’s new (if anything).

We know VBA programming language will be retained and be known as VB7.1 which hasn’t really changed since 1998 when it was first introduced but the emphasis on web applications is realised with this release (or hopefully, that is!). Continue reading “Microsoft Office 2016 (Preview): First Look”

Microsoft Access Table Relationships

Microsoft Access Table Relationships

An ideal database is free of redundant or duplicate data. To achieve that, you must split your data into many subject-based tables so each subject is presented only once. To do that in Microsoft Access, you place common fields in tables that are related. But before you do that, you must need to understand the relationships between your tables, then you can specify these relationships in your Access 2013 database.

microsoft access table relationships

In this article, I will elaborate to you the ten things you need to know about table relationships in Microsoft Access.

1. A one-to-many relationship is when one record in the parent table connects to many records in the child table.

To exemplify this, let’s take for example two tables: one for doctors and the other is for patients. A doctor can have several patients. In this case, you will Continue reading “Microsoft Access Table Relationships”

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”