Category Archives: Microsoft Training

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

Excel vs Access – The Argument Continues

Excel vs Access – The Argument Continues Once again this week, a client questioned the argument of Excel vs Access when building a data processing system for their organisation. There are many pros and cons to using Microsoft Access over … Continue reading

Posted in Database Theory, Microsoft Training, MS Access | Tagged , , , , | 1 Comment

Access Tab Control: How To Create Multi-Page Forms

Access Tab Control: How To Create Multi-Page Forms If you have been developing with Access Forms for a while then you may have noticed the Access tab control which allows you to split logical sections of fields into smaller and … Continue reading

Posted in Forms, Microsoft Training | 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

Working With Hyperlinks In Access – Create A Button Link

Working With Hyperlinks In Access – Create A Button Link With an Access database, there are many ways to perform similar functions like creating a clickable button using the standard CommandButton or using hyperlinks in Access instead – that’s a … Continue reading

Posted in Database Theory, Forms, Microsoft Training, Web | Tagged , , , , | 1 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 Open Microsoft Access Database Appear Outside Of Access

How To Open Microsoft Access Database Appear Outside Of Access If you have ever browsed the Access options and design properties of your database then you will know some of the neat tricks that help to blend your database application … Continue reading

Posted in Forms, Microsoft Training, MS Access | Tagged , , , , | 8 Comments

MS Access Indexing: What And How To Apply

MS Access Indexing: What And How To Apply Working with your database, Access indexing is often overlooked and ignored – why? Because your application will still run, working well and see no reason to take any action. In fact, ignoring … Continue reading

Posted in Database Theory, Microsoft Training, MS Access, Tables | Tagged , , , , | 1 Comment

Access Datasheet View: How To Apply Formatting

Access Datasheet View – Formatting Options Take a look at the following two and half minute video tutorial on how you apply formatting to your Access datasheet view in your tables; the back-end area of your Acess database file. Access … Continue reading

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

Distinct Queries? How To Create An Access Database Query And Make It Unique

Distinct Queries? How To Create An Access Database Query And Make It Unique Microsoft Office Professional ships with the MS Access database application that lets you analyse and manage large amounts of data better than say an Excel spreadsheet. Sometimes, … Continue reading

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