Access Conditional Formatting: How To Apply Logical Formatting To Access 2013 Reports And Forms

Access Conditional Formatting: How To Apply Logical Formatting To Access 2013 Reports And Forms

Using the Access conditional formatting tool was introduced way back with version 2000 and was designed to remove the programmability element to your Access forms and reports when wanting to highlight certain targets or spotting trends.

Take a look at the video tutorial below of the latest version (Access 2013) which demonstrates three different methods between using the value, expression and an aggregate rule.

httpvh://www.youtube.com/watch?v=G911ll1iYhM

Access Conditional Formatting: How To Apply Logical Formatting To Access 2013 Reports And Forms

The pre-defined data bars when  Continue reading “Access Conditional Formatting: How To Apply Logical Formatting To Access 2013 Reports And Forms”

Access Form Design: Discover My 10 Key Properties To Your MS Access Database Designs

Access Form Design: Discover My 10 Key Properties To Your MS Access Database Designs

I wrote an article last year of my 10 key properties to Access form design which is just the beginning to mastering an access database that help to control and improve the look and feel to your application.

access form design

I’ve decided to add it here in my blog as this has recently come back as a discussion in a recent training course that Continue reading “Access Form Design: Discover My 10 Key Properties To Your MS Access Database Designs”

Using Wild Card Characters When Searching MS Access Queries

Using Wild Card Characters When Searching MS Access Queries

With your Access queries, everyone should be aware of the commonly used two wild card characters when searching your database records which are the ‘*’ (asterisk) and the ‘?’ (question mark).

Here’s a quick video tutorial to refresh your memory (particularly for the beginner!).

httpv://www.youtube.com/watch?v=39HPAbEackQ

As the video quickly explains, you use the ‘*‘ and the ‘?‘ to find any number of characters or a single character placement for your text based values.

Therefore, the following results would look like image below if you Continue reading “Using Wild Card Characters When Searching MS Access Queries”

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

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

split a databaseWhichever 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 in utility separating your tables from all the other remaining objects known as the front-end database.

However, to manually split an Access database means learning how to create linked tables to your front-end database which typically stores all your queries, forms and reports.

Just as a reminder for

Continue reading “Split A Database: How To Manually Split A Microsoft Access Database”