Category Archives: Utilities

Split A Database: How To Manually Split A Microsoft Access Database

Split A Database: How To Manually Split A Microsoft Access Database Whichever version you use, to split a database is simple enough to apply and set up using the normal method of the Database Splitter tool which is a built … Continue reading

Posted in Database Theory, Microsoft Training, Utilities | Tagged , , , , | Leave a comment

Working With Linked Tables In Access That Have A Password Applied To It

Working With Linked Tables In Access That Have A Password Applied To It Working with linked tables in Access probably means you have engaged in the process of splitting your database between the tables which is deemed the back-end (BE) … Continue reading

Posted in MS Access, Tables, Utilities | Tagged , , , , | Leave a comment

Using DropBox: Storing Your Microsoft Access Database Online

Using DropBox: Storing Your Microsoft Access Database Online Ever contemplated using DropBox? I use this great free online service to store, transport and share large Microsoft Access database files – Yep, it can be shared and even keep track of … Continue reading

Posted in Database Theory, MS Access, Utilities | Tagged , , , , | 6 Comments

Access Security Warning: Decide Whether To Trust Your Access Database

Access Security Warning: Decide Whether To Trust Your Access Database The Access security warning system was changed and further enhanced with the release of Access 2007 and improved again with version 2010 making this even simpler to use as you now decide … Continue reading

Posted in Microsoft Training, MS Access, Utilities | Tagged , , , , | 1 Comment

Update Query In MS Access – A Little Trick Using The Access VBA Immediate Window

Update Query In MS Access – A Little Trick Using The Access VBA Immediate Window Here is one my free weekly tips (No. 86) for you that I wanted to share today because one particular client recently asked how you can … Continue reading

Posted in MS Access, Queries, Utilities, VBA | Tagged , , , , | 3 Comments

How To Import Access Database Objects

How To Import Access Database Objects In the past, I’ve talked about importing data into Access but someone recently asked about how to import Access database objects since you cannot copy and paste tables, queries, forms or reports. It’s really … Continue reading

Posted in Microsoft Training, MS Access, Utilities | Tagged , , , , | Leave a comment

What Is Database Auditing – Microsoft Access Tools

What Is Database Auditing Using Microsoft Access Tools? The question I’m often asked is What is database auditing and how do I create an audit trail in Microsoft Access? The second part to that question means the inquisitor has realised there … Continue reading

Posted in Database Theory, Forms, MS Access, Utilities, VBA | Tagged , , , , | Leave a comment

How To Create A Splash Screen In Access

How To Create A Splash Screen In Access Have you ever noticed the standard splash screens that pop-up in many applications and wondered how you could create a splash screen to replace the original and customize your database file to … Continue reading

Posted in Microsoft Training, MS Access, Utilities | Tagged , , , , | 1 Comment

How To Write SQL Queries In Access

How To Write SQL Queries In Access Just in case you haven’t heard, SQL stands for Structure Query Language and is the backbone code to asking those all important questions in your Access database or any database application as a … Continue reading

Posted in Database Theory, MS Access, Queries, Utilities | Tagged , , , , | 3 Comments

Microsoft Access Developer Challenges When Inheriting Databases

Microsoft Access Developer Challenges When Inheriting Databases I recently visited a prospect client to assess and evaluate a mix of Access databases and Excel spreadsheet files which constituted in the company side operational database system only to discover as a … Continue reading

Posted in Database Theory, MS Access, Utilities | Tagged , , , , | 1 Comment