fbpx
Logo
Mail us
ben@accessdatabasetutorial.com

Category Archives: Tables

Microsoft Access Database: Creating Database Field Type Templates


Microsoft Access database applications just gets richer and richer as time goes by and from version 2010, you can now create field types or in effect user defined fields stored via the ‘Save Selection as New Data Type‘ command which is located from the context sensitive fluent ribbon bar Fields tab (Table Tools). Take a look at a demonstration of this is set up and used in the video tutorial below (less than 4 minutes). Microsoft Access Database (version 2010 onwards) […]

Tags: , , , ,

Microsoft Access Tutorial – How to use Input Masks


Microsoft Access

Microsoft Access databases provide a wealth of tools and utilities to help control design layouts and data integrity. Working with the latter, you can reduce and even dismiss any programming at all to control data entry to a field in a table or via a form using the Access Input Mask feature. Take a quick look at this useful Microsoft Access tutorial (using version 2010) on how to set up an input mask. Very easy to create indeed and the […]

Tags: , , , ,

Microsoft Access Database – Working With Two Digit Hour Time Formats


Microsoft Access

Here’s a quick Microsoft Access tutorial video I found about applying formatting to the date/time data type control concentrating on the two digit hour time format that doesn’t always show up in two digit form. Even if you create a custom date/time format within Microsoft Access, the two-digit hour which is supported using the convention of “hh” via the format property doesn’t always work. It will show a single digit hour even though you’ve specified the right code. Take a […]

Tags: , , , , ,

How to Use Smart Tags In Microsoft Access 2010 ?


Microsoft Access

How to use smart tags in Microsoft Access will only be applicable to 3 versions (2003, 2007 and 2010). Forget about the earlier versions and now even with the latest Access 2013, this too has been dropped! Since most users are still engaged with the main three releases mentioned, I thought it may be worth a re-visit to understand how to apply a smart tags for your fields in a table. The key decision to consider when a smart tag […]

Tags: , , , ,

How To Create A Database In MS Access And Link To MySQL Database


MS Access

Check out and follow these easy steps with this video tutorial (less than 2 minutes) to learn how to create a database in MS Access and link it an MySQL database using the ever popular ODBC connection. The acronym ‘OBDC’ stands for ‘Object Database Connectivity’ and has been around for a very long time now which is now considered the standard for creating a gateway to you MS Access link. As the video shows, you first establish the database source driver, create an […]

Tags: , , , , ,

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


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. 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 […]

Tags: , , , , ,