Some useful smatterings of information, and some more substantial ones too, to make your working life easier.
Day in the Life of a Database Programmer
9:00am Finish off work on an existing project for a recruitment company. The user wants to be able to click a button and email all his clients individually with their timesheet data attached as an Adobe PDF This involves writing and implementing code in VBA for Microsoft Access which carries out the process automatically. The code is almost there but with a few teething errors, I go through the code step by step using a debugger to determine where the errors are occurring. After the errors are fixed I double check that the process works and save the changes leaving the file ready for testing tomorrow.
9:58am Import an update to a database for a client who has a stock management database that we built. Send a transfer file to the customer which contains only the tables, queries, forms and reporrs that need updating. Log on to their PC remotely. I first backup their live database in case anything goes wrong. I then import the file to overwrite their existing files and run through the updates of the database to check they are working.
10:23am I receive a phone call from another client during the update process saying that they have a problem with their database. I arrange to phone them back when I am finished.
10:34am Call back the client from earlier. They want a quick change to an exisitng form. I carry out the work required on our version of the database and note down the steps that I have taken. I check this works and then log in to the client’s pc and carry out the same process there.
11:00am Start building a new database from a specification produced by Philippa. We have already talked through the background and requirements of the business. I start by creating the back file of the database in Access– this is where all the data is stored in tables.
1:00pm Run the daily backup for all our files and then break for lunch.
1:30pm Carry on working on the new project, finish the back file and start working on the front which is linked to the tables in the back file. The front file is what the user sees and is where they enter and view all the data.
2:05pm Receive a phone call from a company who is looking for someone to build them a database. I take down their contact details and check that their requirement sounds like something we can help with before passing them through to Philippa who deals with the enquiry in detail.
2:13pm Check and reply to emails.
2:34pm Carry on the project from earlier.
3:30 - 4:45pm Several phone calls, including one for me. Pass the other ones over to Philippa and James. Keep going on the project in between.
5:30pm Finish for the day after noting where I am on the project
Top TipSitting at desk all day can be bad for your health so make sure to move about every so often. If you need to talk to some one the other side of the office, why not get up and go talk to them rather than phone or email them?
pro·gram·mer or pro·gram·er
One who programs, especially:
- Computers One who writes computer programs.
- One who prepares or writes instructional programs.
The American Heritage® Dictionary of the English Language, Fifth Edition
Who am I?
If you have recalled the last Smatterings, I am Philippa!In case you were wondering, Katherine left us to have a baby and her son, Daniel, is now just over a year old. Keith has now replaced her. More about him next time!
Welcome back to Time-savers, our handy little hints and tips to save you time and frustration whenever you use your computer!
PS: Don't forget our Gamble-Free Guarantee. We guarantee to save you money overall – if we don't then we'll refund the difference. We won't take something on unless it's worth your while, which means you really can't lose!