Category Archives: Database

Database Training — Microsoft Access

Posted on by

Among the top­ics that I cover in my Microsoft Access train­ing are the following:

  • Rela­tional Databases
  • Nor­m­al­ised Tables
  • Tables
  • Quer­ies
  • Forms and sub forms
  • Reports and sub reports
  • Mac­ros
  • VBA Pro­gram­ming for Access
  • Secur­ity
  • Net­work­ing Front End and Back End Data
  • Recover Data from cor­rupt Access Databases
  • JAWS com­pat­ible data­bases for com­puter users whose vis­ion loss pre­vents them from see­ing screen content

New Data Protection Laws

Posted on by

Irish Times have a very good piece about the new pro­pos­als for Data Pro­tec­tion in Europe including:

  • A single set of rules will apply across the EU
  • Less paper­work for com­pan­ies, as “unne­ces­sary” admin­is­trat­ive require­ments will go
  • Organ­isa­tions and cit­izens will deal with a single data pro­tec­tion author­ity in the EU coun­try where organ­isa­tions have their main base Con­tinue read­ing →

Irish Tax Revenue Has 10 Laptops Stolen

Posted on by

On Fri­day, 28th Janu­ary, the Data Pro­tec­tion Com­mis­sioner has begun an invest­ig­a­tion into the theft of laptops from the Rev­enue Com­mis­sion­ers in Dublin.

Three men walked in to an office block at Ashtown Gate on the Navan Road last night and stole ten laptops.

The Rev­enue Com­mis­sion­ers are still try­ing to determ­ine if any­thing else was stolen, but a spokes­man said all of its laptops are encrypted.

The com­mis­sioner is seek­ing to estab­lish what type of data was on the laptops and how sens­it­ive it was.

Database Development

Posted on by

I design and develop a wide range of data­base sys­tems. These range from desktop Access sys­tems to enterprise/internet wide SQL and MySql. These data­bases are cus­tom­ised 100% for my cli­ents. They are never static and can be developed to grow with your busi­ness / organ­isa­tional needs. Data­bases are far super­ior to spread­sheets — with data­bases you enter the data once and then you can get unlim­ited views and turn that raw data into inform­a­tion. I also spe­cial­ise in recov­er­ing data from cor­rupt Access databases.

The five main reas­ons why people com­mis­sion one of my data­bases are:

• Improve Oper­a­tional Effi­cien­cies
• Reduce Costs
• Gen­er­ate New Rev­en­ues
• Deliver Improved Cus­tomer Ser­vices
• Adhere to good busi­ness practices

Inform­a­tion = Organ­ised Data + Typ­ical Data­base include:

  • Cus­tomer Rela­tion­ship Man­age­ment (CRM)
  • Sales and Sales Ana­lysis Databases
  • Stock / Invent­ory Systems
  • Point of Sale (POS) Systems
  • Time and Billing Systems
  • Fin­an­cial Con­sultancy Systems
  • Bank­ing Databases
  • Order Man­age­ment Systems
  • Equip­ment Hire and Timed Based Invoicing
  • Mar­ket­ing Cam­paign System
  • Cus­tomer Ques­tion­naire / Feedback
  • Health/Safety and Social Wel­fare Databases
  • Research Data­bases
  • Hos­pital Depart­ment Databases
  • Accounts Cus­tom­isa­tion
  • Legal Data­bases
  • Book­ing Systems
  • Data­bases for Solicitors
  • Pen­sion Databases
  • Schools Data­bases

I also recover data from cor­rupt Access databases .

Preventing Enterprise Data Loss — 6 Best Practices

Posted on by

There is an excel­lent Art­icle on ZD Net 15th June 2010 about the 6 Best Prac­tices for Pre­vent­ing Enter­prise Data Loss. These include:

#1: Under­stand what data is most sens­it­ive to your business.

#2: Know where your most sens­it­ive data resides.

#3: Under­stand the ori­gin and nature of your risks.

#4: Select the appro­pri­ate con­trols based on policy risk  and where sens­it­ive data resides.

#5: Man­age secur­ity centrally

#6: Audit secur­ity to con­stantly improve.

Apple and Adobe clash over Flash

Posted on by

In this months Web Designer (issue 171) there is good cov­er­age  of the battle between Apple and Adobe. Basic­ally Apple will not allow Flash to work on either its iPhone or iPad.

“Old rival­ries con­tinue to col­our the battle between Adobe and Apple when it comes to get­ting Flash onto iPhone.

Back in Octo­ber last year we repor­ted from the MAX event in Los Angeles, when Adobe’s Kevin Lynch attemp­ted to con­vince the crowds that Flash was in fact on the iPhone. As it turned out, this related merely to the abil­ity to export apps built with the forth­com­ing Flash Pro­fes­sional CS5 into nat­ive Cocoa/Objective-C code. So in basic prin­ciple, design­ers could build with famil­iar Flash tools but effect­ively pub­lish to a plat­form non-supportive of Flash Player, as we wrote in issue 164:

“Adobe instead attemp­ted some­thing of a quick-change act (dur­ing MAX key­note) by sug­gest­ing that Flash was already on the iPhone, with a selec­tion of com­mer­cial apps lis­ted and avail­able. In fact, what we were shown was a beta ver­sion of Flash CS5 pro­fes­sional com­pil­ing Flash con­tent as Cocoa applic­a­tions – the nat­ive lan­guage for Apple’s coveted device. Agen­cies such as BlueSkyNorth, Bowler Hat Games and South Park Digital Stu­dios have already star­ted pub­lish­ing apps using this very method.”

Fast for­ward to April and the sched­uled launch of Cre­at­ive Suite 5, and Apple decide to drop a pretty hefty bomb­shell. It tran­spires, at Apple’s April 8th key­note that the new iPhone OS 4.0 would come with it the SDK caveat pro­hib­it­ing any such third-party tool from being used in the app devel­op­ment pro­cess. In other words, you can’t use any­thing other than Apple’s own tools provided as part of the offi­cial iPhone Developer Pro­gram… Cue some anxious Adobe faces sud­denly flush­ing as red as their logo.

The response? Well, Adobe ploughed on with the world­wide online launch last Monday with the ‘Flash CS5 Pack­ager for iPhone’ demo intact and the spokes­men quoted in vari­ous sources seemed to sug­gest that they would “look for loop­holes” in order to pre­vent the fea­ture being rendered use­less. It now tran­spires that Adobe is con­tem­plat­ing legal action, along the lines of anti-competition most can only guess, while its product evangelist’s prefer (unof­fi­cially) to tell Jobs and Co. where to stick it.

Tech Update June 11 2010

Posted on by

In today’s Irish Times (June 11, 2010) there is a good review of iPhone 4, HTC Desire and iPhone 3GS.

The iPhone still has no sup­port for Flash and the battle between Apple and Adobe will con­tinue to rage on.

The HTC Desire uses Google’s Android os and sup­ports Flash.

Microsoft has released free online ver­sions of Word, Excel Power­Point and OneLine which will allow users to view, edit and share Office doc­u­ments online.