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)…
Don’t shoot the messenger but you can use Microsoft Access database on a Mac O/S – well with some software intervention that is!
The say things happen in three! Over the holiday period and starting the new year, I had to deal with my website hosting and domain provider shutting down forcing a change of all services (hence my new look and feel website), my broadband behaving even more erratically forcing me to upgrade to a super-fast alternative and finally my Windows 7 Pro laptop collapsing having spent all of last weekend trying to rebuild it.
Well, I had a choice – update and purchase a new laptop or consider working solely with my ever faithful Mac Book Pro (Sorry, Microsoft but I’m a Mac man now!).
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.
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
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?
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.
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 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.
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.
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 .