Embedded Macros in Access2007

Introduction.There is only one difference between the stand-alone Macros and embedded macro; they will not appear in the navigation pane under the Macros Group.  They are written directly on Forms/Reports or on their control's event property.  When you make a copy...

Read More

Report Design in Access2007

Introduction.In Microsoft Access 2007 there are some interesting design-time features; Report View (not Print Preview) and Layout View besides Design View and Print Preview. These two new views allow working with the report interactively.  In earlier versions of Access,...

Read More

Memo Field Text Formatting

Introduction.We know that Memo Fields in Microsoft Access Tables give us much-needed flexibility to record variable length Text data.  But, Access Versions earlier than 2007 allows us to enter in plain text format only like we do in Notepad.The need for some form of text...

Read More

Sub-Query in Query Column Expressions

IntroductionQueries are the main data processing component of the database systems.  Queries work behind the scene shaping the data into Reports and other forms of outputs.  Microsoft Access Users (mostly beginners) attempt to create the output for a Report, by chaining...

Read More