Mail us
Home » Posts tagged "Access Databases"

Tag Archives: Access Databases

How to Create an Autokeys Closing Macro in Microsoft Access ?

Microsoft Office 2016

As a follow on from my last post about Microsoft Access Macros, here’s a good working example clearly explained using the ‘unsafe’ CloseWindow command… It walked you through creating a custom hotkey for Microsoft Access (using version 2010 though it will also apply through to the current version, 2016) which used the ‘Autokeys’ macro. This macro shows you how to avoid a problem during a design and run-time for a form where incorrectly closing this object can save filters and sorts into their properties and alter their behaviour when […]

Tags: , , , ,

Data Types In Access Databases: Knowing More About Date/Time

Access Databases

This quick 80 second video simply shows you how to set data types in Access and this example is the Date/Time data type. It’s not that difficult to create but just in case you weren’t sure – it’s below here for your information before I explain a little background to the Date/Time data type. Data Types In Access Databases: Knowing More About Date/Time How are dates stored in Microsoft Access? Knowing more about data types in Access will give better […]

Tags: , , , , ,

How To Make Labels In Access Databases Using The Label Wizard Tool ?

Access Databases

Take a look at this video tutorial which is under 7 minutes long on how to make labels in Access using the label wizard tool. It’s a very simple utility to use and the video explains in good detail of each step required to build effective labels for your Access database reports. How To Make Labels In Access Databases Using The Label Wizard Tool? It’ s refreshing to see the author of this video see some ‘error‘ or warning prompts […]

Tags: , , , , ,

Structuring Queries In Access 2007

People prefer to keep complex data sets in databases rather than in flat files because data can be found and grouped more precisely when it is stored in a database. The ability to draw data out of a database depends upon the ability to structure queries, or requests that define specific records. Structuring queries in Access 2007 is relatively easy because Access is designed to handle many different types of operators. An operator is a special symbol or reserved word […]

Tags: , , , , , , , ,