Saturday August 17th 2019




‘MS Access 2007’ Archives

Data Analyst

Data Analyst

Data Analyst-OPE0000008Q Description Company Profile:   Direct Energy is one of North America's largest energy and energy-related services providers with over 5 million residential and commercial relationships.  Direct Energy provides customers with choice and support in managing their energy costs through a portfolio of innovative [...]

Changing a Traditional information system to adapt new technologies for effective decision making

Changing a Traditional information system to adapt new technologies for effective decision making

This is about an experience of an anonymous writer of this post describing his/her hands on experience in upgrading company’s information to adapt to new technologies for effective decision making and resultantly growth of the company. This post also reveals that how the hands on experience sets the foundations of understanding new [...]

Precision and Scale in Sql Server

We are writing this post because recently we received a query regarding automatic rounding in quantity column. The user was previously using MS Access and they upgraded to SQL Server database. Although solution is simple but sometimes it becomes difficult to resolve when confronting the problem. SQL Server Books online very well addressed the [...]

MS Access 2007 – Creating Acces Project file (.adp)

We believe that change is important but not at the cost of additional training, but should compliment existing experience. Creating ACCESS Project file (.adp) extension for connecting to MS SQL Server data was found to bechallenging / required additional time to search how to do that; however we implemented the same and presenting it in simple [...]

Ungrouping Controls in MS Access 2007

Today We would like to share an annoying experience in MS Access 2007. We were building a form and were trying resize the text boxes on Form, the annoying thing was when we resize one text box, other text boxes also affected. The solution is very simple and is presented below; 1- Go arrange tab. 2- Select the control or all controls 3- Go to [...]