Hi [fname] and welcome to the January 2010 In-Touch newsletter.

Microsoft Access 2007 Tip

Macros now provide support for simple variables, error handling and some limited looping.

Embed a macro within the event property of a control like a button to open a form or report, all without the need for VBA code.

This is significant, as Access macros still work even when VBA code is disabled for security.

Identity Theft

A Veda Advantage Identity Crimes Report by Galaxy Research found that more than 1.5 million Australians had credit cards illegally copied and 1.2 million had bank accounts illegally accessed. Mail theft is one of the easiest ways to get details of someone's identity and the report found 7% of respondents had personal mail stolen.

www: garjewa.com.au email: consulting@garjewa.com.au skype: garjewa
If you can't read this version then try http://www.garjewa.com.au/newsletter/archieves/In-Touch200910.pdf

Happy 2010 ҉

DNA anyone?

Some time was spent in Hobart working with the Tasmania Police. The system was a quality control database for forensic evidence. It uses an Access front end and an SQL back end. Most of the work involved changes to facilitate inter departmental communication, a barcode reader interface and improvements to business processes to aid workflow. Is working smarter, not harder, something you could do with in your day?

How can I minimise system downtime?

This was the question posed by a professional practice in Launceston. They had data on one machine (PC1) with other client PCs on a local area network with UPS support. If the PC1 disk was to fail the practice would stop until a new disk was installed and the machine rebuilt. To lower the risk of disk failure we installed a file server with a RAID 1 array. This provided greater protection of the data with hot swappable disks that would rebuild should a disk fail. Are your systems critical to your business continuity?

National Broadband Network (NBN) and business opportunities.

2010 and beyond. GARJEWA has just installed a DELL PowerEdgeWindows 2008 R2 server as a test bed for our Software as a Service (SAS) development. We are looking forward to a lot of Microsoft Silverlight development over the next 12 months and our goal is to provide a platform for a "Green" alternative for training delivery and assessment.

Best regards, Jeff Garner.

Special Offer - $10,000 for charity

Yes, we are giving away $10k of our services to help registered charities get the most from their IT.

Do you want that database fixed, need some training or perhaps a professional assessment of your systems security, backups or business workflow processes? Then take advantage of this offer.

See conditions at www.garjewa.com.au/specialoffers/specialoffers.htm or call on 03 6330 2158 / 0411 878 658.

At GARJEWA we work to provide you with the best Information Systems Security, Training and Software Development solutions available. Securing your future by helping you work smarter and achieve more with your IT.