Logo
Mail us
ben@accessdatabasetutorial.com

Category Archives: Database Theory

Microsoft Access Database 2016: Printing Reports


Microsoft Access database

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 […]

Tags: , , , ,

Microsoft Access Database Forms: Should We Use Unbound Forms?


Microsoft Access

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 Ms Access form is will help divide the distinction and allow you to determine which approach will suit best. Microsoft Access like any other […]

Tags: , , , ,

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


Microsoft Access

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. The method is very straight forward! Just simply rename the file extension (once the database file […]

Tags: , , , ,

Accountants Should Dump Microsoft Excel for MS Access Database


MS Access

I’ve been saying this for years, MS 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 MS 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 […]

Tags: , , , ,

Microsoft Access Database: What is… Some Popular Questions


Microsoft Access Database

Here are some questions I’ve been asked over the years regarding Microsoft Access database 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 […]

Tags: , , , ,

Microsoft Access 2016 Runtime Now Available For Download


Ms Access Query

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. There are two versions of the currient Access 2016 application. Make sure you have idenrtified which […]

Tags: , , , ,