Microsoft Access 2016 Will Soon Support Large Number (BigInt) Data Type

Microsoft Access 2016 Will Soon Support Large Number (BigInt) Data Type

Coming soon… Microsoft Access 2016 will gain a new data type called ‘Large Number‘ which will be an extension to the Number at a type or more commonly referred as BigInt (Big Integer).

Large Number (or BigInt) is a new supported data type that will help developers and users with added analytical capability. This extended support means that Access can finally read and write data to and from external data sources which make also makes use of BigInt.

This has been a limitation when importing data into an Access database from larger more robust database applications and this feature will be able to switched on or off (I guess to help keep the application optimised and not slow down too much).

As announced, “When creating new local tables or editing existing ones, Access now allows users to add fields that store BigInt numbers.” The upgrade, which adds a ‘Large Number‘ option to the ‘Click to Add’ menu when adding a new field to local tables, opens up new possibilities, allowing users to work with SQL data and other external data sources that use BigInt.

microsoft-access-2016-will-soon-support-large-number-bigint-data-type

If not already available (as installed), as an Office 365 subscriber you will need to run an update to get the new data type. Other variants of Microsoft Access 2016 will shortly also see this feature be available to download and install.

Watch out for  more information on how this new data type will be practically used in Access and more details will soon be available and reveal the scope of this new field type.

Microsoft Access Database: Using Table and Query Naming Conventions

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)…

As clearly explained, not all aspects of the MS Access application provides a way to easily see what type of object you Continue reading “Microsoft Access Database: Using Table and Query Naming Conventions”

Microsoft Access Database Working On A Mac O/S

Microsoft Access Database Working On A Mac O/S

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!).

microsoft access database vmware on a mac

Having decided on the latter, I needed a simple and Continue reading “Microsoft Access Database Working On A Mac O/S”

Welcome To My Rebuilt Microsoft Access Database Website

Welcome To My Rebuilt and New Look and Feel Microsoft Access Database Website

A new year and a new look and feel website for you 🙂

So, if you haven’t visited us before, we are Access database tutorial – a blog website all about Microsoft Access database.

microsoft-access-database-eproducts

Take a look, browse our blog articles since 2010 and consider some of our unique and exclusive offers and ebooks.

Very easy to follow eBooks and prebuilt eProduct tools to plug into your own Access database with 30 day email support and a money back guarantee (if not satisfied).

Microsoft Access: Office 365 Business Subscription Plans To Be included

Microsoft Access: Office 365 Business Subscription Plans To Be included

Microsoft plans to add Microsoft Access database to its Office 365 Business and Office 365 Business Premium subscription plans.

The above plans currently do not provide this all powerful Access application but from the 1st of December until the end of January 2017 will get this automatically updated to their accounts.

microsoft-access-office-365-business-subscription-plans-to-be-included

Microsoft Access: Office 365 Business Subscription Plans To Be included

Be aware, if an organisation subscribing to either of those two plans has elected to get Office 365 updates via the “deferred channel” update process, then Microsoft Access will start to arrive in June 2017. The Office 365 updates so-called “channels,” arrive every four months are called the “deferred channel.” Therefore, “first release for deferred channel” update release arrives every four months and is designed for testing purposes. Continue reading “Microsoft Access: Office 365 Business Subscription Plans To Be included”

Microsoft Access Databases – Using Data Analysis Tools

Microsoft Access Databases – Using Data Analysis Tools

Here’s a quick one minute video demonstration on the main Microsoft Access database tools available for your reference.

This video tutorial is based on Access 2013 but it applies to all versions (albeit maybe found in other parts of the application).

As you can see, these tools look a little tired and old style Windows which Continue reading “Microsoft Access Databases – Using Data Analysis Tools”

Microsoft Access Database Templates – Some Are Even Free!

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.

microsoft-access-2016-task-template-database

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.

Other database templates can also been found like Continue reading “Microsoft Access Database Templates – Some Are Even Free!”

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”

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

Microsoft Access 2016 Macros: Show All Macro Commands

Microsoft Access 2016 Macros: Show All Macro Commands

The great debate of whether to use Microsoft Access macros or the higher level of VBA code will linger on until the end of time (or realistically, Access is discontinued)!

In the meantime, most Access developers will continue to lean towards Access VBA but the majority of power users, self-taught Access designers will still embrace the ease of g using macros to automate their databases.

Microsoft Access 2016 Macros Show All Macro Commands

With the later versions of MS Access (post 2010), macros have become more powerful and flexible and with the added introduction of better web integration and the fact VBA Continue reading “Microsoft Access 2016 Macros: Show All Macro Commands”