Bar Code Font That Can Be Freely Used With Microsoft Access

Bar Code Font That Can Be Freely Used With Microsoft Access

Many Microsoft Access databases are designed to manage the products and order workflows of any production based or manufacturing business and with any delivery note or dispatch document using bar codes makes capturing data very easy.

However, your operating system (typically Microsoft Windows) will not have a default bar code font installed but with this free resource courtesy of BarcodesInc, you can now download and install the free fonts that is available across Windows and not just for MS Access.

bar code font for ms access

When you download and install this new font, you add Continue reading “Bar Code Font That Can Be Freely Used With Microsoft Access”

Can A Foreign Key Be Null: Cascade to Null Relationships In Microsoft Access

Can A Foreign Key Be Null: Cascade to Null Relationships In Microsoft Access

The first thing to note here when asking the question can a foreign key be Null? is to clarify what a foreign key is, what is meant by the value Null and something known as setting the ‘Enforce Referential Integrity‘ option for your joined tables.

can a foreign key be null

Simply put:

A Foreign Key is way to index a field which can accept duplicate values that are found from the ‘many‘ side of a ‘one-to-many‘ relationship and cannot be left blank.

A Null value is an unknown value or a data entry which has no value to it which can happen with your text and date/time data types. When Continue reading “Can A Foreign Key Be Null: Cascade to Null Relationships In Microsoft Access”

Microsoft Access Reports: How To Number Entries In A Report

Microsoft Access Reports: How To Number Entries In A Report

If you need to know how to number records for your Microsoft Access reports and haven’t added a sequential data field namely the AutoNumber (which should be a primary key), then here’s a quick way to add such a feature directly into your reports.

microsoft access reports

Design your report using one of the various Continue reading “Microsoft Access Reports: How To Number Entries In A Report”

MS Access Multiple Values For A Single Field: A New Data Option From Version 2007

MS Access Multiple Values For A Single Field: A New Data Option From Version 2007

With traditional Access databases, storing data values in a field were very ‘single-minded’! However with the introduction of version 2007, Access multiple values can be achieved into one field using the new element called ‘Allow Multiple Values‘ which is a new option available when using the Lookup Wizard feature to create either a drop-down Combo box or List box.

For the ‘purist’ database developer, you do not even need to use the wizard tool as there are new properties available via the ‘Lookup‘ tab for each field in your table design view.

access multiple values

Before I step you through the very basics of creating a multiple value input field, one needs to Continue reading “MS Access Multiple Values For A Single Field: A New Data Option From Version 2007”

Password For Access Database: How To Set Database Passwords Using The Simple Encrypt Feature

Password For Access Database: How To Set Database Passwords Using The Simple Encrypt Feature

Setting a password for Access database applications is a simple and straight forward affair and now as a standard way to apply such protection, Microsoft Access (from version 2007) provides the basic password encrypted feature which means a better secure way to stop unauthorised users opening your database file.

Take a quick look at this video tutorial stepping your through how to apply the encryption password method.

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

In this video, it covered the very essentials of setting a password and you may have noticed that each time you wanted to add, edit or even remove a password (applying decryption) you first had Continue reading “Password For Access Database: How To Set Database Passwords Using The Simple Encrypt Feature”