Exclusive articles from Jayaram Krishnaswamy
We are glad to share these articles written exclusively for us by Jayaram Krishnaswamy with you. Our aim is to give you an extra bonus to our AccessFIX file repair software. We hope you will find them helpful.
In MS Access accdb Microsoft introduced a new data type called attachments. Many types of files can be stored in a column which has the attachment data type. Someone can add bitmap files, jpg files, sound files, word documents, etc. to a column without increasing the size of the database.
If you need to make changes to records or move a group of records in MS Access, you may want to use an action query. This article explains what an action query is, as well as one of the four basic types of action queries.
Jayaram Krishnaswamy
http://jayaramkrishnaswamy.sys-con.com/
Dr. Jay Krishnaswamy, a graduate of the IISC Bangalore, writes extensively on database and web related topics to several web sites.
Before working in the IT industry as a MCT and a Siebel consultant he taught and researched at several post-graduate institutions and national laboratories in India, Japan, Australia, Netherlands, Brazil , Canada, and USA.
Jayaram Krishnaswamy is a US based freelance technical writer for several web sites on database and web related articles. He has recently completed the Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 that will be available in December 2007.
Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 provides you with the basic knowledge that you should have before you move on to more advanced ETL [Extraction, Transformation, and Loading]. The book will also provide you with a comprehensive description of the many designer windows that you may encounter while working with the designer. This guide provides the building blocks describing each block by way of an example as well as describing the nuts and bolts that bind the blocks. A majority of SSIS tasks are covered in this book and they are described fully in the summary of table contents section. You start building packages right from Chapter 2 and continue on to Chapter 20 gathering and building upon your knowledge in each step.
