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!
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.
Comparing Microsoft Access 2016 App and MS Access Desktop Database
Here’s an overview of the comparisons between using Microsoft Access 2016 App and the desktop version.
An Access app is a database that you design and modify in Microsoft Access 2016 and use in a standard web browser. The data and database objects are stored in SQL Server or Microsoft Azure SQL Database, so you can share the data within your organisation using on-premises SharePoint or Office 365 for business. An Access App is created either from a template or from scratch.
Generally, a desktop database is a database system created to run on a single computer. Desktop databases are much more limited and constrained than larger data centre or data warehouse systems, where primitive database software is replaced by sophisticated hardware and networking setups.
An MS Access desktop database helps you store and track any kind of information such as inventory, contacts, or business processes. Like the Access app, you can also create an Access desktop database by using a template or creating it from scratch.
How to identify the two types of Access templates? An Access app template has a globe icon in its picture and the title of the app does not contain “desktop.” For example, “Asset tracking” or “Custom web app.” While an Access desktop database template has no globe in the picture and its title has “desktop” in it. For example, “Desktop asset tracking,” or “Blank desktop database.”
Access app and Access desktop database serve different purposes. You may want to check the table below to see which one works best for you.Continue reading →
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.
Any database can exceed they limits which can cause performance issues and become corrupt overtime which is why Continue reading →
In this section I’m going to list the advantages and disadvantages of using Access macros that is an exercise developers need to carry out to determine how they will programme their application going forward and avoid the dreaded result of having a ‘pear shaped’ and inflexible database.
Benefits of using Access Macros
Here’s the list:
1. Easier to write! You do not have to have a university degree in computer programming to understand and utilise macros. The command reference is intuitive and easy to apply. It just requires some investment of your time.
2. Disabled Mode – From version 2007 by default, any database opened that contained VBA code would not run as part of the security changes made to Microsoft Office applications and prevent unwanted macro virus threats that the VBA code could contain some malicious routines which some programmers seem to get a kick out of! Macros used within templates in Access are safe and run in normal mode.
3. Access Services – With the introduction of SharePoint server where you can now publish your Access database on the web in a secured environment, VBA code is Continue reading →
Back in 2012, I posted an article on how to create a splash screen formwithout VBA code too using a little trick to name your database with an .bmp extension to it – a hidden gem!
However, in this quick video tutorial, the alternative way is to create a navigation form in Microsoft Access (from version 2010) and take advantage of the Access options and a simple macro...take a look…
Excuse the music and text narratives but hopefully you should have been able to follow the prompts?
There are other Access form options and properties to set to help present a smoother and more polished form including modal, pop-up Continue reading →
Looking at Microsoft Office development is like looking at an old tree’s cross-section – you will find different layers from different eras. Each layer is carefully maintained for compatibility. Run the just-released Word 2016, enable the Developer ribbon, click VBA, and there is Visual Basic for Applications 7.1, using traditional VB as found in the long-deprecated VB 6.0 from 1998.
Since VBA is built on COM (Microsoft’s object technology) and has fast access to the COM interfaces exposed by Office applications, VBA is well suited to automating Office. The ability to record your actions as editable VBA macros is one great feature for the developers. Apart from that, you can also write COM add-ins for Office applications in any language that supports COM, still fully supported in Office 2016.Continue reading →
Microsoft Access Database 2016 Is Not Included In Office 365
Since its release, Microsoft Access database will not be available for all users of Office 365. Shocking isn’t it?
Users who have purchased an Office 365 Business Premium were surprised to discover that Access 2016 wasn’t included in their subscriptions.
Access 2016 is not included with any of the Office 365 Business subscriptions, even in Office 365 E1 or Office 365 Pro Plus enterprise subscriptions. If you want Microsoft Access 2016 in your enterprise, you should be opting instead for the full Office 365 E3 subscription.
What is more perplexing is the fact that Microsoft Access 2016 is included in Continue reading →
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 →
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.
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 →