Comparing Microsoft Access App and MS Access Desktop Database

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

microsoft acces-app-icon microsoft access-desktop-icon

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 “Comparing Microsoft Access App and MS Access Desktop Database”

Microsoft Access Databases: Pros & Cons of Access Macros

Microsoft Access Databases: Pros & Cons of Access Macros

Here’s an snippet from my popular Microsoft Access database eBook on How To Use Microsoft Access Macros & Automate Your Application 

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.

access macros ebook cover

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 “Microsoft Access Databases: Pros & Cons of Access Macros”

Microsoft Access Database 2013 Tutorial On Forms

Microsoft Access Database 2013 Tutorial On Forms

Microsoft Access forms are ways of making your data entry convenient, safe without exposing its profound work to most database users and provide a smooth workflow reflecting business practices. The benefit of taking the time to build good and workable forms will pay dividends later.

Importing/Creating The Database

In creating an access form, the first thing you need to do is to either import or create the database. As a pre-step, follow the simple steps below:

  1. When you open your Microsoft Access 2013, select “Blank desktop database”.
  2. To import the database, go to “External Data” tab then select XML file or another file format.
  3. Browse the location where you either unzip the file or load the file and click the OK button.

Microsoft Access Database 2013 Tutorial On Forms

microsoft access database 2013 tutorial on forms

An Access Form is a customisable design object that allows users to have an accessible and easier database experience. A well-designed form supports Continue reading “Microsoft Access Database 2013 Tutorial On Forms”

Microsoft Access Validation Rules In Tables

Microsoft Access Validation Rules In Tables

A validation rule restricts or controls what a user can input in a table field. You can think of it as a set of layers which ensures that your users input data properly.

Here’s a quick video tutorial to get you going and very easy to apply.

Microsoft Access provides several ways to validate data: data types, field sizes, table properties, and input masks. Among these, table properties provide specific types of data validation.

One example is setting the required property to YES which results to forcing the users to enter a value in that specific field.

Another technique is by using the Validation Rule property to require specific values, and the Validation Text property to alert your users to any errors. For example, putting a rule such as Continue reading “Microsoft Access Validation Rules In Tables”

Microsoft Access Database 2013: Building A Navigation Control Form

Microsoft Access Database 2013: Building A Navigation Control Form

This quick three and half minute video tutorial will demonstrate how easy it is to build Microsoft Access database navigation control forms keeping the controls and property settings to a minimum whilst also utilising the ribbon bar too…

There’s no voice over but some light melodic tones to easily follow the tips and techniques in building that navigation control form.

Microsoft Access Database 2013: Building A Navigation Control Form

Of course, one assumes you have also pre-prepared and built either the forms or reports that will be linked and associated to each tab added which Continue reading “Microsoft Access Database 2013: Building A Navigation Control Form”

Microsoft Access Database Tutorial – Selecting Unique And Distinct Values In A Query

Microsoft Access Database Tutorial – Selecting Unique And Distinct Values In A Query

There are many different types and ways to run queries that your Microsoft Access database application provides and one useful ms access query is where you can create a distinct or unique value list from duplicate or repeating values from other records.

Check out this 4 minute video tutorial which clearly explains two ways to create a unique value query report.

As the video shows, you can use either the property sheet to select unique value or the SQL statement approach using the keyword Distinct. In fact, an extension to Continue reading “Microsoft Access Database Tutorial – Selecting Unique And Distinct Values In A Query”

Access Database Tutorial is 4 Years Old

Access Database Tutorial is 4 Years Old – This Week!

I can’t believe it, Microsoft Access Database Tutorial is 4 years old this week!

Spending the time to create a website offering various tools, resources and free tips and tricks was really down to my students which I’m very grateful to them for inspiring me to create a successful online service and it’s been an amazing journey so far but where has the time flown? 4 Years on!

microsoft access database tutorial 4 years old

With all the newer applications and online web processes of today, Microsoft Access has kept up at a reasonable level too with SharePoint and better collaboration but ultimately it’s the power of the desktop version with the power of Access VBA that really can’t be Continue reading “Access Database Tutorial is 4 Years Old”

Microsoft Access Tutorial – How to use Input Masks

Microsoft Access Tutorial: How to use Input Masks

Microsoft Access databases provide a wealth of tools and utilities to help control design layouts and data integrity. Working with the latter, you can reduce and even dismiss any programming at all to control data entry to a field in a table or via a form using the Access Input Mask feature.

Take a quick look at this useful Microsoft Access tutorial (using version 2010) on how to set up an input mask.

Very easy to create indeed and the video covers the pre-set options which to be honest is based on the US style conventions for Continue reading “Microsoft Access Tutorial – How to use Input Masks”

Microsoft Access Database: 5 Settings To Avoid With Microsoft Access Options Causing You Headaches

Microsoft Access Database: 5 Settings To Avoid With Microsoft Access Options Causing You Headaches

Here’s an article I wrote some time ago but is worth a revisit since the newer generation of users tend not to be always aware of the background tasks Access sometimes insists on performing…

When I first started to use Microsoft Access (back in 1993) which was then version 1.1 and quickly moved to the newer version of 2.0, you had various options available that could be set to change the behaviour of how you viewed and ran the basic objects. It probably took you no more than 15 minutes to discover, read (in the help files) and apply all settings that Microsoft Access databases had to offer – job done, never having to return to this area again!

Microsoft Access Database: 5 Settings To Avoid With Microsoft Access Options Causing You Headaches

Move forward 20 plus years and working with Access version 2013 you now have to either employ an individual to study and constantly refine the permutations of how Microsoft Access will work, behave and look. Okay, I may have exaggerated a little about employing and individual but your get the point! You need to Continue reading “Microsoft Access Database: 5 Settings To Avoid With Microsoft Access Options Causing You Headaches”

Microsoft Access Database – Working With Two Digit Hour Time Formats

Microsoft Access Tutorial – Working With Two Digit Hour Time Formats

Here’s a quick Microsoft Access tutorial video I found about applying formatting to the date/time data type control concentrating on the two digit hour time format that doesn’t always show up in two digit form.

Even if you create a custom date/time format within Microsoft Access, the two-digit hour which is supported using the convention of “hh” via the format property doesn’t always work. It will show a single digit hour even though you’ve specified the right code. Take a look at the video below.

Microsoft Access Tutorial – Working With Two Digit Hour Time Formats

In the video tutorial, it mentioned one of three ways to Continue reading “Microsoft Access Database – Working With Two Digit Hour Time Formats”